Walmac Solutions is seeking a Power BI Analyst with a strong finance background to deliver financial reporting and maintain SQL-driven feeds into their Fabric Lakehouse/Warehouse. The ideal candidate will leverage Power BI and T-SQL skills to transform data into actionable insights.
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 qualitydocument 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. Security Clearance Required: No Visa Candidate Considered: No Compensation: Full-time hours - Salary roles Benefits - Full Relocation Assistance Available - No Commission Compensation - No Bonus Eligible - No Overtime Eligible - No Interview Travel Reimbursed - No Ideal Candidate: 2- 5 year experienced 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.
Walmac Solutions is seeking a Power BI Analyst with a strong finance background to deliver financial reporting and maintain SQL-driven feeds into their Fabric Lakehouse/Warehouse. The ideal candidate will leverage Power BI and T-SQL skills to transform data into actionable insights.