Sign upLog in

Business Intelligence (BI) Developer-Knoxville Office

Edfinancial Services LLC

Knoxville, TN

Apply
JOB DETAILS
SKILLS
Agile Programming Methodologies, Apache Hadoop, Application Programming Interface (API), Business Intelligence, Communication Skills, Data Analysis, Data Entry, Data Management, Data Quality, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Delivery Management, Desktop PC, Detail Oriented, Dimensional Modeling, Documentation, Kanban, Mathematics, Metrics, Microsoft Dynamics CRM, Microsoft Excel, Microsoft Outlook, Microsoft Product Family, Microsoft SQL Server, Microsoft SharePoint, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Microsoft Word, Power BI, Quality Metrics, Reliability Engineering, Reporting Dashboards, Requirements Management, Risk, SQL (Structured Query Language), SQL Databases, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Sales Pipeline, Standards Development, Star Schema, Stored Procedures, Sybase Powerbuilder, Warehousing
LOCATION
Knoxville, TN
POSTED
5 days ago

Apply

Description

General Purpose of Job

As a BI Developer, you'll build and manage data pipelines, architect data stores, and deliver reports and dashboards for internal and external clients.

Duties and Responsibilities (Daily and Monthly)

Pipelines & Integration

  • Design, build, and maintain robust ELT/ETL pipelines (SSIS, SQL Agent) that ingest from Hadoop, flat files, Excel, and APIs - engineered for reliability, auto-recovery, and observability.
  • Implement layered data flow (staging ? integration ? presentation) with automated data-quality checks and clear documentation of sources, transformations, and lineage.

Data Warehousing

  • Design and build data warehouses and subject-area marts using dimensional modeling and star schemas - well-formed facts and dimensions, conformed dimensions, and deliberate slowly changing dimension strategies.
  • Establish a single source of truth with shared definitions, modeling standards, and warehouse-level data quality, so metrics stay consistent as the platform grows.

Reporting & Analytics

  • Build and maintain reports and dashboards in SSRS and Power BI (semantic models, DAX, row-level security, gateways), feeding Azure/SharePoint Lists and Dynamics CRM.
  • Source reporting from the warehouse, define each metric once, and curate a maintainable, certified reporting catalog.

Planning

  • Translate business requirements into scoped, estimated work; manage dependencies and delivery risk; and report progress in sprint ceremonies.

Requirements

Educational

  • Associate degree preferred
  • Bachelor's degree preferred

Professional

  • Minimum one year experience in Data & Analytics

Computer Skills

  • Data Entry
  • Microsoft Excel and Microsoft Word
  • Microsoft Outlook and Microsoft Teams

Additional Requirements: Excellent communication skills and attention to detail.

Knowledge, Skills & Abilities

  • Minimum one year in Data & Analytics; associate or bachelor's degree preferred.
  • Working knowledge of T-SQL, stored procedures, and views on Microsoft SQL Server - including Azure SQL Managed Instance and Azure SQL Database.
  • Working knowledge of SSIS, SQL Agent, and SSRS; knowledge of dimensional modeling, star schema design, and/or SSAS a plus.
  • Working knowledge of Power BI Desktop and/or Power BI Report Builder.
  • Knowledge of Microsoft Fabric, Data Factory, OneLake, Data Warehouse a plus.
  • Strong communication skills, attention to detail, and solid logic and math skills.
  • Experience in a financial environment and exposure to Agile (Kanban) a plus.

About the Company

E

Edfinancial Services LLC

Edfinancial Services provides exceptional customer-driven student loan servicing. In addition, we have created streamlined processes and higher education services specifically designed with schools in mind - such as call center capabilities, financial aid process outsourcing, and default prevention services.

Perpetual motion is our constant state. We are absolutely driven to excel on behalf of our stakeholders - borrowers, schools, businesses, and state and federal agencies. We stay ahead of the technology curve in higher education. We anticipate new trends and respond with products that improve operational efficiencies and corporate compliance.

Headquartered in Knoxville, Tennessee, Edfinancial Services has satellite facilities in Jacksonville, Florida, and Little Rock, Arkansas. Since the only constant in this business is change, we're not looking back. Edfinancial Services is focused on the future. We're seeing through the eyes of our customers to sharpen our focus and align our vision with your reality. A company in motion, Edfinancial Services is moving forward, putting vision into action. Come grow with us in 2011.

COMPANY SIZE
100 to 499 employees
INDUSTRY
Education
FOUNDED
1995
WEBSITE
https://www.edfinancial.com/Home