Job description

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Activesoft, Inc., is seeking the following. Apply via Dice today! 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.

Requirements