Sr. Lead Developer

Ness Digital Engineering; New Jersey; On-site; USD 120,000 - 160,000; Full time

Job summary

Ness Digital Engineering seeks a Senior Power BI Engineer to design, develop, and optimize enterprise BI solutions using Power BI and MicroStrategy. The role focuses on semantic modeling, SQL performance, and scalable data analytics to empower data-driven decisions.

This is a hands-on engineering role where you will own end-to-end BI delivery, collaborating with data engineers, analysts, and stakeholders to deliver production-grade analytics from requirements through deployment in New Jersey.

Qualifications

• Bachelor's degree in a related field.
• 7+ years of BI development experience.
• 5+ years hands-on experience with Microsoft Power BI.
• Experience supporting MicroStrategy (Strategy).
• Strong expertise in Power BI Desktop, Power BI Service, DAX, and semantic modeling.
• Expert-level SQL development and optimization.
• Experience with Oracle, PostgreSQL, Databricks, SQL Server, or other enterprise databases.
• Experience implementing RLS, deployment pipelines, and Power BI governance.

Responsibilities

• Design, develop, and maintain enterprise dashboards, reports, and analytics using Power BI.
• Support and maintain existing MicroStrategy reports, dashboards, and metadata objects.
• Develop interactive visualizations to enable informed business decisions.
• Build reusable semantic models, datasets, and reporting components.
• Translate business requirements into scalable BI solutions.
• Participate in the full SDLC from requirements to production support.

Skills

Power BI development

DAX

SQL

Data modeling

MicroStrategy

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI Desktop

Power BI Service

MicroStrategy (Strategy)

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.