Business Intelligence (BI) Developer-Knoxville Office

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.