Senior Business Intelligence (BI) Developer-Knoxville Office

Edfinancial Careers; Knoxville (TN); On-site; USD 100,000 - 140,000; Full time

Job summary

Edfinancial Careers in Knoxville seeks a Senior BI Developer to build data pipelines, architect data stores, and deliver dashboards for clients. You will mentor the Data Services team and drive modern data warehousing and durable systems.

Ideal candidates have 8+ years in Data & Analytics, advanced T-SQL, SSIS/SSRS, Power BI, and Azure SQL experience, plus strong communication and leadership skills in a financial services setting.

Qualifications

• Eight or more years of experience in Data & Analytics.
• Expertise in T-SQL, stored procedures, and data modeling.
• Experience designing and implementing ETL/ELT pipelines and data warehouses.
• Strong communication and mentoring abilities in a team setting.

Responsibilities

• Design, build, and maintain ELT/ETL pipelines with reliability and observability.
• Architect data stores and dimensional models with conformed dimensions.
• Develop reports/dashboards in SSRS and Power BI; manage semantic models and security.
• Lead planning, manage dependencies, and mentor the Data Services team.

Skills

Communication

Attention to detail

Analytical thinking

Mentoring

Education

Associate degree

Bachelor’s degree

Tools

SSIS

SQL Agent

SSRS

Power BI

DAX

Azure SQL (Managed Instance / Database)

SSAS

Data Factory

OneLake

Purview

Job description

General Purpose of Job

As a Senior BI Developer, you’ll build and manage data pipelines, architect data stores, and deliver reports and dashboards for internal and external clients. As a Data & Analytics technologist, you’ll also mentor the Data Services team and champion modern data warehousing, durable systems, and industry best practices.

Description

General Purpose of Job

As a Senior BI Developer, you’ll build and manage data pipelines, architect data stores, and deliver reports and dashboards for internal and external clients. As a Data & Analytics technologist, you’ll also mentor the Data Services team and champion modern data warehousing, durable systems, and industry best practices.

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 & Leadership

• Translate business requirements into scoped, estimated work; manage dependencies and delivery risk; and report progress in sprint ceremonies.
• Mentor the Data Services team and lead adoption of best practices across pipelines, modeling, and reporting.

Requirements

Educational

• Associate degree preferred
• Bachelor’s degree preferred

Professional

• Minimum eight years’ 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 8 years in Data & Analytics; associate or bachelor’s degree preferred.
• Advanced T-SQL (including query optimization), stored procedures, and views on Microsoft SQL Server — including Azure SQL Managed Instance and Azure SQL Database.
• Advanced SSIS, SQL Agent, and SSRS; advanced dimensional modeling and star schema design; working knowledge of SSAS.
• Advanced Power BI Desktop; Power BI Report Builder a plus.
• Knowledge of Microsoft Fabric, Data Factory, OneLake, Data Warehouse, and Purview governance.
• Strong communication skills, attention to detail, and solid logic and math skills.
• Experience in a financial environment and exposure to Agile (Kanban) a plus.