Senior Power BI Engineer | Lead BI & Analytics

Ness Digital Engineering

Trenton (NJ)

On-site

USD 110,000 - 170,000

Full time

2 hours ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

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.