Business Intelligence (BI) Developer-Knoxville Office

Edfinancial Careers; Knoxville (TN); On-site; USD 70,000 - 95,000; Full time

Job summary

Edfinancial Careers in Knoxville, TN seeks a BI Developer to build and manage data pipelines, architect data stores, and deliver reports and dashboards for internal and external clients.

You will design ELT/ETL pipelines, implement data quality controls, create data warehouses with dimensional modeling, and develop SSRS/Power BI reports, collaborating with teams in an Agile environment.

Qualifications

• Minimum one year in Data & Analytics with related education preferred.
• Experience designing ETL/ELT pipelines and data warehouses.
• Proficiency in Power BI, SSRS and SQL Server environments.

Responsibilities

• Design, build, and maintain ELT/ETL pipelines (SSIS, SQL Agent) with reliable data ingestion.
• Create data warehouses and marts using dimensional modeling and star schemas.
• Develop reports/dashboards in SSRS/Power BI and maintain a reporting catalog.
• Translate requirements into scoped work and manage sprint delivery.
• Ensure data quality, lineage, and documentation across sources.

Skills

Data & Analytics

T-SQL

Power BI

SSIS

SQL Server

Communication skills

Attention to detail

Agile (Kanban)

Education

Associate degree preferred

Bachelor’s degree preferred

Tools

Power BI

SSIS

SSRS

SQL Server

Job 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.

Description

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.