Developer – Data analytics and engineer

About this job

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

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,…