The Role
Own and enhance a Microsoft Fabric-based financial reporting platform integrating ERP, payroll, and CRM data. Build ETL/ELT pipelines, semantic models, governed Power BI dashboards, automated refreshes, and financial KPIs. Support FP&A forecasting, month-end close, reconciliation, and self-service analytics adoption. Optimize SQL and reporting performance, administer platform components, monitor data quality, and train Finance stakeholders.
Summary Generated by Built In
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.
Key Responsibilities
- 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.
Requirements
- 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
Preferred Qualifications-
- 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.
Skills Required
- Advanced Power BI development, DAX, Power Query M, semantic modeling, and row-level security
- Microsoft Fabric experience including OneLake, Lakehouse, Warehouse, Dataflow Gen2, Data Factory, and Medallion Architecture
- Advanced SQL, including CTEs, joins, window functions, and query optimization
- Snowflake experience
- ETL/ELT design, dimensional modeling, star schemas, and snowflake schemas
- REST API integration
- Automation, Alteryx, advanced Excel and VBA, and Power Query automation
- Python with Pandas and NumPy
- FP&A reporting and knowledge of financial statements, GL, Trial Balance, KPIs, and budget-versus-actuals reporting
- Stakeholder management, cross-functional collaboration, Agile/Scrum, and end-user training
- Microsoft Certified: Fabric Data Engineer Associate DP-700 certification, required or in progress
- Power BI certification such as PL-300 or equivalent
- Alteryx certification
- Experience integrating finance or accounting, HRIS/payroll, and CRM systems
- Media, e-commerce, or professional services experience
- Exposure to Azure Data Lake Storage Gen2, Fivetran, or similar ingestion tools
- Bachelor's degree in Computer Engineering, IT, or a related field
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
GAIN is a creative-led, insight-driven marketing and technology company that combines data, technology, creativity, campaigns, and customer science to help brands and organisations grow. Its services span creative studios, customer transformation strategy, media, data and analytics, SEO, conversion-rate optimisation, experimentation, and user-centred digital experiences. GAIN also develops AI-enabled tools, including a plug-and-play AI CRO product, to deliver measurable business impact.
