Why This Role Stands Out
This hybrid role offers a significant opportunity to transform financial reporting by building and managing a cutting-edge data platform, empowering you to drive impactful, automated analytics. If you're a skilled data professional eager to own a critical system and advance your expertise in Microsoft Fabric and Power BI within a reputable technology company, this is your chance to shine. Apply today to be at the forefront of financial data innovation!
Quick Overview
Job Description
JD- About the Role
We're hiring a Senior Power BI Developer & Microsoft Fabric Data Engineer to own and evolve our enterprise financial data platform. You'll take over a Fabric-based FP&A reporting ecosystem that integrates Finance, Payroll, and CRM data into a single source of truth, and continue the shift from manual, spreadsheet-based reporting to automated, near-real-time self-service analytics for Finance Business Partners and senior leadership.
- Own and administer the Microsoft Fabric platform (OneLake, Lakehouse, Warehouse, Dataflow Gen2) supporting FP&A and operational analytics.
- Architect ETL/ELT pipelines integrating ERP (e.g., Sage Intacct), HR/payroll (e.g., Cezanne HR), and CRM (e.g., HubSpot) systems via REST APIs, CData connectors, and On-Premises Data Gateway.
- Manage automated, multi-daily data refreshes with monitoring, alerting, and Teams-based notifications.
- Build enterprise semantic models with RLS, standardized KPIs, and Time Intelligence calculations.
- Develop self-service Power BI dashboards for Revenue, GP, COS, forecasting, budget vs. actuals, and WoW/YoY variance.
- Partner with Finance Business Partners to automate forecast submissions (incl. VBA-enabled Excel) and streamline month-end close.
- Ensure data governance, quality, and reconciliation across financial reporting, including GL and Trial Balance.
- Optimize SQL, data models, and reports for performance at scale.
- Provide training and support to drive self-service BI adoption.
- Core BI Tools- Power BI (advanced), DAX, Power Query (M), Semantic Modeling, RLS
- Data Platform- Microsoft Fabric (OneLake, Lakehouse, Warehouse, Dataflow Gen2, Data Factory, Medallion Architecture)
- Database & SQL- Advanced SQL (CTEs, joins, window functions), query optimization, Snowflake
- Data Engineering- ETL/ELT design, dimensional modeling, star/snowflake schema, REST API integration
- Automation, Alteryx, Advanced Excel & VBA, Power Query automation
- Programming- Python (Pandas, NumPy), Jupyter (preferred)
- Domain Knowledge- FP&A reporting, financial statements (GL, Trial Balance), KPI reporting, budget vs. actuals
- Soft Skills- Stakeholder management, cross-functional collaboration (Agile/Scrum), end-user training
- Microsoft Certified: Fabric Data Engineer Associate (DP-700) — required or in progress.
- Power BI certification (e.g., PL-300 or equivalent); Alteryx certification a plus.
- Experience integrating finance/accounting (Sage Intacct, NetSuite), HRIS/payroll, and CRM (HubSpot, Salesforce) systems.
- Media, e-commerce, or professional services background a plus.
- Exposure to Azure Data Lake Storage Gen2, Fivetran, or similar ingestion tools a plus.
- Bachelor's degree in Computer Engineering, IT, or related field.
Success Metrics - Reduce manual month-end reporting cycles through automation (benchmark: 70% reduction previously achieved).
- Maintain reliable, low-downtime automated data pipelines.
- Increase self-service Power BI adoption among Finance and business stakeholders.
- Sustain strong data governance and reconciliation standards.