GAIN- Central Finance- Senior Finance Data Analyst

This is Gain Ltd

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.