Senior Power BI Engineer - Front Office Investment Data

Senior Power BI Engineer – Front Office Investment Data

Company Overview:

Business Integration Partners (BIP) is Europe's fastest growing digital consulting company and are on track to reach the Top 20 by 2030, with an expanding global footprint in the US (New York, Charlotte, Chicago, and Houston). Operating at the intersection of business and technology, we design, develop, and deliver sustainable solutions at pace and scale, creating greater value for our customers, employees, shareholders, and society.

BIP specializes in high-impact consulting services across multiple industries with 6,000 employees worldwide. Our Financial Services business serves Capital Markets, Insurance and Payments verticals, supplemented with Data & AI, Cybersecurity, Risk & Compliance, Change Management and Digital Transformation practices. We integrate deep industry expertise with business, technology, and quantitative disciplines to deliver high-impact results for our clients.

BIP is currently expanding its footprint in the United States, focusing on growing its Capital Markets and Financial Services lines. Our teams operate at the intersection of business strategy, technology, and data to help our clients drive smarter decisions, reduce risks, and stay ahead in a fast-evolving market environment.

About the Role

Senior BI Engineer – Power BI Migration

We are seeking an experienced Senior BI Engineer to support a strategic enterprise BI modernization initiative focused on migrating legacy MicroStrategy reporting and analytics capabilities to Microsoft Power BI.

This is a hands-on role for a senior engineer who can independently drive report conversion, semantic model design, validation, deployment, and user enablement in a complex financial-services environment.

Key Responsibilities

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

Required Qualifications

• 10+ years of BI / Analytics Engineering experience
• Expert-level Power BI skills, including semantic modeling, DAX, Power Query, RLS, and deployment pipelines
• Strong SQL skills
• 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

Preferred Qualifications

• Hands-on MicroStrategy experience, including reports, dossiers, metrics, attributes, semantic models, or REST APIs
• Experience migrating MicroStrategy to Power BI
• Asset Management, Investment Management, Capital Markets, or Financial Services background
• Familiarity with investment data such as positions, transactions, pricing, security master, portfolios, and risk data
• Experience with AI-assisted tools such as Claude, Copilot, or Cursor
• Experience delivering BI training or user enablement

Compensation:

The base salary range for this role is $160,000 - $190,000

Benefits:

• Choice of medical, dental, vision insurance.
• Voluntary benefits.
• Short- and long-term disability.
• HSA and FSAs.
• Matching 401k.
• Discretionary performance bonus.
• Employee referral bonus.
• Employee assistance program.
• 11 public holidays.
• 20 days PTO.
• 7 Sick Days.
• PTO buy and sell program.
• Volunteer days.
• Paid parental leave.
• Remote/hybrid work environment support.

For more information about BIP US, visit

Equal Employment Opportunity

It is BIP US Consulting policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship, or marital status, and to