Sr. Lead Developer

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.