> Markdown version of [/jobs/ext/150834-business-intelligence-analyst-knoxville-office](https://www.wearedevelopers.com/jobs/ext/150834-business-intelligence-analyst-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). --- # Business Intelligence Analyst-Knoxville Office - **Company:** Edfinancial Services - **Location:** Knoxville, TN, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Access, Microsoft Word, Microsoft Excel, Agile Methodology, Databases, Extract Transform Load (ETL), Data Mart, Data Mining, Dimensional Modeling, Integrated Development Environments, Microsoft SQL Server, Microsoft PowerPoint, Query Optimization, Power BI, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, Transact-SQL, Microsoft Fabric, Optimization Algorithms, Star Schema - **Published:** May 16, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=8122112f7664b98f ## About the Role Do you have experience in Writing skills?, Do you have a Associate's degree?, * Associates Degree Preferred * Bachelor's Degree Preferred * Educational And Professional Experience Requirements 2 year degree in a related field plus 3 years of BI experience. Computer Skills * Data Entry * Customer Service * Microsoft Word * Power Point * Excel * Access Additional Requirements: Excellent oral, grammatical, written, and multi-tasking skills. Knowledge, Skills & Abilities Desired * Advanced knowledge of Microsoft SQL Server * Advanced knowledge of databases, schemas, table definitions, views, and stored procedures * Advanced knowledge of T-SQL * Advanced knowledge of Microsoft SSIS or other ETL tools * Advanced knowledge of Microsoft SSRS * Knowledge of Microsoft Fabric and Power BI * Basic understanding of Dimensional Modeling and Star Schema designs * Advanced knowledge of Excel * Familiarity with query optimization * Ability to understand & translate reporting business requirements into ETL processes, reports, and/or dashboards * Ability to work with software developers on system designs to advise on BI-related processes * Demonstrate logic and math skills along with the ability to be inquisitive in analyzing requirements * Effective communication and organizational skills * Experience in a financial environment is a plus * Exposure to AGILE methodologies is a plus ## Description Implement database processes, reports, dashboards and various other BI artifacts and processes for internal and external clients based on business requirements using industry best practices. Duties and Responsibilities (Daily and Monthly) * Translate business requirements into tasks and estimate the size of the tasks. * Research requirements for requests to provide the functionality expectations of each request, e.g., data extraction, report, dashboard. * Decide the best use of available technologies to complete a variety of assigned tasks. * Develop SSIS packages to meet BI project requirements. * Design and implement data marts. * Extend existing data mart implementations. * Develop reports using SSRS development environment. * Develop report and dashboards using Power BI. * Develop code using the T-SQL language to meet BI project requirements. * Design report layouts that provide a user-friendly experience. * Analyze performance of each report or query and implement proper optimization techniques. * Follow documented processes to generate reports, packets, charts to various business units. * Troubleshoot and resolve technical issues. * Report progress to team(s) on the implementation of assigned projects/work items through daily scrum meetings. * Maintain a positive work atmosphere by behaving and communicating in a manner that will facilitate working with customers, clients, co-workers, and management. * Responsible for the security of workstation and work area in regard to the confidentiality of the data and the systems. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [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) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## 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) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)