Sr. Lead Developer

Ness Digital Engineering; Trenton (NJ); On-site; USD 110,000 - 170,000; Full time

Job summary

Ness Digital Engineering seeks a hands-on Senior Power BI Engineer with deep Power BI and MicroStrategy expertise to design, develop, and support enterprise BI solutions. You will build scalable semantic models, optimize SQL queries, and deliver analytics that enable data-driven decisions.

The role is highly hands-on, focusing on end-to-end BI delivery, data modeling, governance, and collaboration with Data Engineers, Analysts, and Business Stakeholders to ensure scalable, reliable reporting

Qualifications

• Bachelor's degree in CS, IS, Engineering, or related field.
• 7+ years of Business Intelligence development experience.
• 5+ years of hands-on experience with Microsoft Power BI.
• Experience supporting and developing solutions in MicroStrategy (Strategy).
• Strong expertise in Power BI Desktop, Power BI Service, DAX, Power Query, and semantic modeling.
• Expert-level SQL development and query optimization skills.
• Experience with Oracle, PostgreSQL, Databricks, SQL Server, or other enterprise databases.
• Strong understanding of dimensional modeling and data warehouse concepts.
• Experience implementing Row-Level Security (RLS), deployment pipelines, and Power BI governance.
• Experience with ETL/ELT, data integration, and cloud-based analytics platforms.
• Familiarity with source control, testing methodologies, and CI/CD practices.
• Experience working in Agile environments using Scrum or Kanban.

Responsibilities

• Design, develop, and maintain enterprise-grade dashboards, reports, and analytics solutions using Microsoft Power BI.
• Support and maintain existing MicroStrategy reports, dashboards, dossiers, and metadata objects.
• Develop interactive and intuitive visualizations that enable business users to make informed decisions.
• Build reusable semantic models, datasets, and reporting components to support enterprise analytics.
• Translate business requirements into scalable, maintainable BI solutions.
• Participate in the complete SDLC including requirements gathering, design, development, testing, deployment, and production support.
• Develop enterprise semantic models, datasets, dashboards, and reports using Power BI.
• Build advanced DAX calculations, KPIs, measures, calculated columns, and Power Query transformations.
• Implement Row-Level Security (RLS), workspace governance, deployment pipelines, and Power BI best practices.
• Optimize report performance, dataset refreshes, model scalability, and overall user experience.
• Publish and manage reports within the Power BI Service.
• Support existing MicroStrategy reporting solutions, metadata, and semantic layers.
• Modify and enhance reports, dossiers, metrics, filters, prompts, and Intelligent Cubes.
• Troubleshoot report performance, caching, and metadata-related issues.
• Collaborate on migration or modernization initiatives from MicroStrategy to Power BI when required.
• Develop, optimize, and maintain complex SQL queries, stored procedures, views, and data transformations.
• Integrate data from Oracle, PostgreSQL, Databricks, SQL Server, and other enterprise data platforms.
• Support ETL/ELT processes required for reporting and analytics.
• Analyze SQL execution plans and optimize queries for large-scale datasets.
• Troubleshoot data quality, integration, and performance issues.
• Design and maintain dimensional data models using Star and Snowflake schemas.
• Develop reusable business metrics, KPI frameworks, and semantic models.
• Apply best practices in data modeling, analytics engineering, and data governance.
• Collaborate with Data Engineers, Product Owners, Business Analysts, and business stakeholders to deliver enterprise BI solutions.
• Monitor and optimize report execution, refresh performance, and platform responsiveness.
• Diagnose and resolve report, dashboard, dataset, and database performance issues.
• Perform root cause analysis and production support activities.
• Ensure reporting solutions meet enterprise standards for scalability, reliability, and maintainability.

Skills

Power BI

MicroStrategy

SQL

DAX

Data Modeling

ETL/ELT

CI/CD

Agile

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Tools

Power BI Desktop

Power BI Service

Oracle

PostgreSQL

Databricks

SQL Server

Job description

Senior Power BI Engineer (Power BI | MicroStrategy)

Position Summary

We are seeking a highly skilled, hands-on Senior Power BI Engineer with strong experience in Microsoft Power BI and working knowledge of MicroStrategy (Strategy). The ideal candidate will have expertise in designing, developing, and supporting enterprise Business Intelligence solutions, building scalable semantic models, optimizing SQL queries, and delivering high-quality analytics that enable data-driven decision making.

This is a hands-on engineering role, where the majority of the time will be spent designing, developing, optimizing, deploying, and supporting enterprise BI solutions.

Key Responsibilities

Business Intelligence Development

• Design, develop, and maintain enterprise-grade dashboards, reports, and analytics solutions using Microsoft Power BI.
• Support and maintain existing MicroStrategy reports, dashboards, dossiers, and metadata objects.
• Develop interactive and intuitive visualizations that enable business users to make informed decisions.
• Build reusable semantic models, datasets, and reporting components to support enterprise analytics.
• Translate business requirements into scalable, maintainable BI solutions.
• Participate in the complete SDLC including requirements gathering, design, development, testing, deployment, and production support.

Power BI Development

• Develop enterprise semantic models, datasets, dashboards, and reports using Power BI.
• Build advanced DAX calculations, KPIs, measures, calculated columns, and Power Query transformations.
• Implement Row-Level Security (RLS), workspace governance, deployment pipelines, and Power BI best practices.
• Optimize report performance, dataset refreshes, model scalability, and overall user experience.
• Publish and manage reports within the Power BI Service.

MicroStrategy Support

• Support existing MicroStrategy reporting solutions, metadata, and semantic layers.
• Modify and enhance reports, dossiers, metrics, filters, prompts, and Intelligent Cubes.
• Troubleshoot report performance, caching, and metadata-related issues.
• Collaborate on migration or modernization initiatives from MicroStrategy to Power BI when required.

Data Engineering & SQL

• Develop, optimize, and maintain complex SQL queries, stored procedures, views, and data transformations.
• Integrate data from Oracle, PostgreSQL, Databricks, SQL Server, and other enterprise data platforms.
• Support ETL/ELT processes required for reporting and analytics.
• Analyze SQL execution plans and optimize queries for large-scale datasets.
• Troubleshoot data quality, integration, and performance issues.

Data Modeling & Analytics

• Design and maintain dimensional data models using Star and Snowflake schemas.
• Develop reusable business metrics, KPI frameworks, and semantic models.
• Apply best practices in data modeling, analytics engineering, and data governance.
• Collaborate with Data Engineers, Product Owners, Business Analysts, and business stakeholders to deliver enterprise BI solutions.

Performance & Production Support

• Monitor and optimize report execution, refresh performance, and platform responsiveness.
• Diagnose and resolve report, dashboard, dataset, and database performance issues.
• Perform root cause analysis and production support activities.
• Ensure reporting solutions meet enterprise standards for scalability, reliability, and maintainability.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• 7+ years of Business Intelligence development experience.
• 5+ years of hands-on experience with Microsoft Power BI.
• Experience supporting and developing solutions in MicroStrategy (Strategy).
• Strong expertise in Power BI Desktop, Power BI Service, DAX, Power Query, and semantic modeling.
• Expert-level SQL development and query optimization skills.
• Experience with Oracle, PostgreSQL, Databricks, SQL Server, or other enterprise databases.
• Strong understanding of dimensional modeling and data warehouse concepts.
• Experience implementing Row-Level Security (RLS), deployment pipelines, and Power BI governance.
• Experience with ETL/ELT, data integration, and cloud-based analytics platforms.
• Familiarity with source control, testing methodologies, and CI/CD practices.
• Experience working in Agile environments using Scrum or Kanban.

Preferred Qualifications

• Experience with Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, or Azure Data Lake.
• Experience migrating BI solutions from MicroStrategy to Power BI.
• Experience in Financial Services, Capital Markets, Risk, Regulatory Reporting, FinTech, or Ratings domains.
• Microsoft Power BI certifications are a plus.