01 Oct
|
This is Gain
|
Mumbai
01 Oct
This is Gain
Mumbai
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
• Pro
📌 GAIN- Central Finance- Senior Finance Data Analyst (Mumbai)
🏢 This is Gain
📍 Mumbai