Developer - Data analytics and engineer

EisnerAmper; Mumbai; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

EisnerAmper, a leading accounting and advisory firm, seeks a Microsoft Fabric and Power BI Developer to build data pipelines and semantic models in Fabric and BI dashboards in Power BI. You will collaborate with onsite analysts, data engineers, and stakeholders, owning development and support with architecture direction from leads.

The role emphasizes data integration across cloud/on-prem sources, governance via layered architecture, and deploying changes via Git and Azure DevOps.

Qualifications

• 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.

Responsibilities

• 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 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 where formatted outputs are 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.

Skills

Power BI development

DAX

SQL (T-SQL)

Fabric Data Pipelines

Data modeling

ETL/ELT

DevOps / CI-CD

Tools

Microsoft Fabric

Power BI Service

SSRS

Power Automate

Azure DevOps

Git

Job description

Job Description

At EisnerAmper, we look for individuals who welcome new ideas, encourage innovation, and are eager to make an impact. Whether you re starting out in your career or taking your next step as a seasoned professional, the EisnerAmper experience is one-of-a-kind. You can design a career you ll love from top to bottom - we give you the tools you need to succeed and the autonomy to reach your goals.

We are seeking a Microsoft Fabric and Power BI Developer to join our Information Solutions team. You will build and support data pipelines in Microsoft Fabric and the Power BI semantic models, dashboards and reports that sit on top of them. You will work daily with onsite business analysts, data engineers and stakeholders, and you will own the development and support of the solutions you deliver, with direction from onsite leads on architecture and priorities.

What it Means to Work for EisnerAmper:

You will get to be part of one of the largest and fastest growing accounting and advisory firms in the industry

You will have the flexibility to manage your days in support of our commitment to work/life balance

You will join a culture that has received multiple top Places to Work awards

• We believe that great work is accomplished when cultures, ideas and experiences come together to create innovative solutions
• We understand that embracing our differences is what unites us as a team and strengthens our foundation
• Showing up authentically is how we, both as professionals and a Firm, find inspiration to do our best work

What Work You Will Be Responsible For:

Microsoft Fabric & Data Engineering

• 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.

Power BI Development & Reporting

• 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.

Collaboration & Support

• 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.

Automation & DevOps

• 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.

Basic Requirements

• 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.

Preferred/ Desired Skills

• 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.

About EisnerAmper:

EisnerAmper is one of the largest accounting, tax, and business advisory firms, with nearly 5,000 employees and more than 450 partners across the world. We combine responsiveness with a long-range perspective; to help clients meet the pressing issues they face today and position them for success tomorrow.

Our clients are enterprises as diverse as sophisticated financial institutions and start-ups, global public firms, middle-market companies, as well as high net worth individuals, family offices, not-for-profit organizations, and entrepreneurial ventures across a variety of industries. We are also engaged by the attorneys, financial professionals, bankers, and investors who serve these clients.

About EisnerAmper India:

EisnerAmper (India) Consultants Pvt. Ltd. ( EA India ) is a subsidiary of Eisner Advisory Group LLC ( EA Group ), which practices in an alternative practice structure with EisnerAmper LLP. EA India employees provide advisory services to clients of EA Group and audit services to clients of Eisner Amper LLP and comply with the professional standards applicable to each of EA India, EA Group and EisnerAmper LLP. EA India employees also provide operational services to EA Group and EisnerAmper LLP. The policies and procedures of EA India, including obligations of confidentiality and non-disclosure, apply to all services provided by EA India employees. All applicants are applying to positions for employment with EA India, and not EA Group or EisnerAmper LLP.

EA India opened its first office in Mumbai in 2007. Over the years, our India footprint has expanded to include offices in Ahmedabad, Bangalore and Hyderabad. We are a culturally diverse pool of over 900 professionals supporting our global clientele from a range of startups to Fortune 500 entities.

Preferred Location:

Mumbai