Overview
Build and support data pipelines in Microsoft Fabric and the Power BI semantic models, dashboards and reports that sit on top of them, working daily with onsite business analysts, data engineers and stakeholders.
What you'll do
- Build and maintain data pipelines, Dataflows Gen2 and notebooks in Microsoft Fabric to ingest data from cloud and on-premises sources into Lakehouse and Warehouse.
- Implement transformations across a layered (medallion) architecture, applying agreed source-to-target mappings and business rules.
- Build data quality and cleansing checks so reporting data is accurate and reconciles to source.
- Monitor pipeline runs and refresh schedules and troubleshoot failures and data discrepancies.
- Design, develop and maintain interactive dashboards and reports in Power BI.
- Build and optimize semantic models using star schema design, DAX measures, Power Query, incremental refresh and row-level security.
- Develop paginated reports (Power BI Report Builder or SSRS) where formatted, print-ready output is required.
- Tune report and model performance using Performance Analyzer, DAX Studio and refresh optimization.
- Work with onsite business analysts, data engineers and stakeholders to understand reporting needs.
- Support requirement gathering, iterative development and user acceptance testing.
- Provide support for production reports and dashboards, including timely updates and defect fixes.
- Manage Power BI and Fabric assets in Git and promote changes through Azure DevOps or Fabric deployment pipelines.
- Automate report refresh, subscriptions and distribution using Power BI Service.
- Build and maintain Power Automate flows to trigger dataset refreshes and pipelines, distribute reports, send data alerts and route approvals.
- Document data flows, models and support procedures.
What you'll need
- 3+ years of hands-on Power BI development, including DAX, Power Query, semantic modeling and Power BI Service (workspaces, gateways, row-level security).
- 1+ years of hands-on Microsoft Fabric experience (Lakehouse, Warehouse, Data Pipelines, and Dataflows Gen2 or notebooks).
- 3+ years of SQL (T-SQL) experience, including complex queries, stored procedures and performance tuning.
- Experience building ETL/ELT pipelines with Fabric, Azure Data Factory or SSIS.
- Hands-on experience building Power Automate flows (cloud flows, connectors, triggers and error handling), including integration with Power BI and Microsoft 365.
- Strong knowledge of data warehouse architecture and dimensional modeling.
- Ability to connect Power BI to cloud and on-premises data sources.
- Strong problem-solving skills, with experience tuning BI solutions for performance.
- Clear written and spoken communication, with the ability to work with onsite teams remotely.
Nice to have
- Microsoft certifications such as PL-300 (Power BI Data Analyst) or DP-600 (Fabric Analytics Engineer).
- Python, PySpark or Spark SQL for data transformation in Fabric notebooks.
- Experience with SSRS paginated reports and Power BI Report Server setup and administration.
- Experience with CI/CD and DevOps practices for BI and data assets.
- Familiarity with Tabular Editor and DAX Studio.
- Experience with finance or professional services data.
Details
- Location: Mumbai.
- Flexibility to manage your days in support of work/life balance.
Read the full description and apply on the company’s own careers page.