Financial Data Analyst (Power BI & Microsoft Fabric) - Louisville, KY - Fulltime Position.

Overview

On Site
Depends on Experience
Full Time

Skills

Microsoft Power BI
Financial Reporting
Financial Software
DAX
SQL
Transact-SQL
Microsoft Fabric Data Analyst
Extract
Transform
Load

Job Details

Financial Data Analyst Power BI & Microsoft Fabric

Louisville, KY (2 days onsite in a week)

Fulltime / Permanent Position

Summary

Business-minded Power BI / Microsoft Fabric Data Analyst with a strong finance background who can deliver immediate financial reporting (e.g., real-time AR aging) and maintain SQL-driven feeds into our new Fabric Lakehouse/Warehouse. The role combines deep Power BI, T-SQL and practical data-science skills with finance acumen to transform raw data into actionable insight and accelerate our migration to a modern data-warehouse framework.

Qualifications:

  • Education / Experience Business-finance degree (or equivalent) + 3-5 yrs in data analysis or reporting.
  • T-SQL (3-5 yrs) complex queries, PIVOT, cursors, stored procedures.
  • Power BI expertise dataset & workspace governance, advanced visuals, DAX mastery (time-intelligence, aggregations).
  • Fabric / Data-warehouse exposure Lakehouse tables, Warehouse views, Data Factory pipelines, Direct Lake mode (preferred).
  • ETL & data-quality controls incremental loads, closed-period logic.

Essential Functions:

  • Understand business operations & KPIs; translate finance questions (month-end close, budgeting, forecasting) into data requirements.
  • Develop Fabric Lakehouse / Warehouse models and star schemas linking financial facts to time, customer and product dimensions.
  • Author Data Factory / Fabric Dataflow pipelines for automated, incremental loads feeding Power BI.
  • Create and maintain Power BI dashboards with advanced DAX measures for real-time insight (AR aging, revenue trends).
  • Apply practical statistics (variance, trend analysis) and math ops (averages, ratios) to highlight risk/opportunity.
  • Write, tune and document T-SQL objects that supply downstream financial systems and the Fabric Warehouse.
  • Partner with stakeholders to present findings in clear business language and recommend actions.
  • Ensure governance & data quality document lineage, enforce OneLake naming/security, and follow SOX/PCI requirements.
  • Performs other tasks as assigned.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.