Ebusiness-BI Analyst-Knoxville-Hybrid-Close Date 2/1/2026 at Edfinancial Services LLC

Knoxville, Tennessee, United States -

Full Time

Start Date

Immediate

Expiry Date

06 Apr, 26

Salary

0.0

Posted On

06 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL Server, Database Schema Design, T-SQL, Microsoft Reporting Services, Microsoft SSIS, ETL, Excel, Query Optimization, Microsoft PowerBI, Dimensional Modeling, Star Schema, Communication Skills, Organizational Skills, AGILE Methodologies, Financial Environment Experience

Industry

Higher Education

Description

Description General Purpose of Job 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. Educational And Professional Experience Requirements 2 year degree in a related field plus 3 years of BI experience. Knowledge,Skills & Abilities Desired Advanced knowledge of SQL Server Advanced Knowledge of database schema design Advanced knowledge of T-SQL Advanced knowledge of Microsoft Reporting Services Advanced Knowledge of Microsoft SSIS or any ETL tool Advanced Knowledge of Excel Medium knowledge of query optimization Medium knowledge of Microsoft PowerBI or any dashboarding tool Basic knowledge of Dimensional Modeling and Star Schema designs 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 Duties and Responsibilities Translate BI business requirements into tasks and estimate the size of the tasks. Research requirements for BI requests to provide the requested functionality of each request, e.g. data extract, report, dashboard, etc. Decide the best use of available technologies to complete a variety of assigned tasks. Design and implement data marts. Extend existing data mart implementations. Develop reports using Microsoft SQL Server Reporting Services development environment Develop dashboards using MS Power BI. Develop code using the T-SQL language to meet BI project requirements. Develop MS SQL Server SSIS packages 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.

Responsibilities

The Ebusiness-BI Analyst will translate BI business requirements into tasks, research requirements for BI requests, and design and implement data marts. They will also develop reports and dashboards, analyze performance, and troubleshoot technical issues.