Business Intelligence (BI) Developer-Knoxville Office at Edfinancial Services LLC

Knoxville, Tennessee, United States -

Full Time

Start Date

Immediate

Expiry Date

29 Sep, 26

Salary

0.0

Posted On

01 Jul, 26

Experience

0 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

T-SQL, SSIS, SSRS, Power BI, Dimensional Modeling, ETL/ELT Pipelines, Data Warehousing, DAX, Azure SQL, Microsoft Fabric, Star Schema, SQL Server

Industry

Higher Education

Description

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.

Responsibilities

The BI Developer is responsible for designing and maintaining robust ELT/ETL pipelines and architecting data warehouses using dimensional modeling. They will also create reports and dashboards in Power BI and SSRS to provide actionable insights for internal and external clients.