Overview
On Site
$110,000
Full Time
Accepts corp to corp applications
Skills
Analytical Skill
Attention To Detail
Augmented Reality
Budget
Business Operations
DAX
Dashboard
Data Analysis
Data Flow
Data Quality
Data Science
Data Skills
Data Warehouse
Dimensional Modeling
Extract
Transform
Load
Finance
Financial Reporting
Financial Software
Forecasting
KPI
Management
Mathematics
Microsoft
Microsoft Power BI
Migration
Modeling
Payment Card Industry
Real-time
Reporting
SQL
Sarbanes-Oxley
Star Schema
Statistics
Stored Procedures
Transact-SQL
Trend Analysis
Warehouse
Job Details
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.
Knowledge / Skills / Abilities:
- Business Knowledge / Acumen deep understanding of financial operations, KPIs & reporting cycles (AR, budgeting).
- Relational Data Skills proven star-schema modelling in Power BI / Fabric.
- Data-Science Skills apply math & statistics in DAX; forecast & detect variance drivers.
- Traits analytical, collaborative, business-focused, detail-oriented; able to maintain confidentiality.
- Other duties 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.