Senior Power BI Architect: Modernization & Migration Lead

BIP US; New York (NY); Hybrid; USD 160,000 - 190,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Discretionary bonus

401k matching

HSA

Job summary

BIP US is seeking an experienced Senior BI Engineer to drive a major BI modernization project, migrating legacy MicroStrategy reporting to Microsoft Power BI.

This hands-on role requires 10+ years in BI/Analytics, expert Power BI skills, and the ability to execute complex migrations end-to-end in a financial services environment. Hybrid/remote options offered with competitive compensation.

Qualifications

• 10+ years of BI/Analytics Engineering experience.
• Expert Power BI skills incl. semantic modeling, DAX, Power Query, RLS, deployment pipelines.
• Experience with Snowflake or similar cloud data platforms.
• Proven experience with enterprise BI migration or modernization programs.
• Strong understanding of data modeling, reconciliation, lineage, and reporting controls.
• Ability to work independently and drive complex initiatives to completion.

Responsibilities

• Lead migration of MicroStrategy reports, dossiers, metrics, attributes, and semantic models to Power BI.
• Design scalable Power BI architecture (workspaces, semantic models, RLS, datasets, deployment pipelines).
• Translate legacy BI logic into DAX and Power Query while preserving accuracy.
• Reconcile and validate migrated reports against legacy outputs and source data.
• Partner with Data Engineering and business teams across Portfolio Management, Trading, Risk, and Operations.
• Create reusable migration patterns, documentation, and Power BI training materials for end users.
• Track migration progress, dependencies, and stakeholder sign-off using Jira.
• Leverage AI-assisted tools to accelerate migration, testing, and documentation.

Skills

BI/Analytics experience

Power BI expertise

Semantic modeling

DAX

Power Query (M)

RLS (Row-Level Security)

Deployment pipelines

Snowflake cloud data platform

BI migration/modernization

Independent execution

Tools

Power BI

Jira

AI-assisted tools

Job description

BIP US is seeking an experienced Senior BI Engineer to drive a major BI modernization project, migrating legacy MicroStrategy reporting to Microsoft Power BI.

This hands-on role requires 10+ years in BI/Analytics, expert Power BI skills, and the ability to execute complex migrations end-to-end in a financial services environment. Hybrid/remote options offered with competitive compensation.