> Markdown version of [/jobs/ext/731672-senior-business-intelligence-developer-knoxville-office](https://www.wearedevelopers.com/jobs/ext/731672-senior-business-intelligence-developer-knoxville-office). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Business Intelligence Developer-Knoxville Office - **Company:** Edfinancial Services - **Location:** Knoxville, TN, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Microsoft Word, Microsoft Excel, Application Programming Interfaces (APIs), Agile Methodology, Microsoft Azure, Microsoft Outlook, Data as a Services, Extract Transform Load (ETL), Data Stores, Data Warehousing, Dimensional Modeling, Microsoft Dynamics CRM, Apache Hadoop, Microsoft SQL Server, SQL Azure, Query Optimization, Power BI, Microsoft SharePoint, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Agent, SQL Server Integration Services, SQL Server Analysis Services, Data Streaming, Transact-SQL, Build Management, Microsoft Fabric, Data Analytics, Star Schema, Data Pipelines - **Published:** June 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=82500619f83944d7 ## About the Role Do you have experience in T-SQL?, Do you have a Associate's degree?, 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. ## Description 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., * 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. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)