MicroStrategy BI Data Engineer – Front Office Investment Data

MicroStrategy BI Data 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

We are seeking a hands-on Senior MicroStrategy BI Data Engineer to design, build, and enhance enterprise data and business intelligence solutions supporting Portfolio Management, Trading, Risk Analytics, and other front-office investment teams .

This role sits at the intersection of data engineering, business intelligence, investment data, analytics, and enterprise reporting . The successful candidate will work across the data lifecycle—from source ingestion and transformation through Snowflake data models, curated datasets, semantic layers, MicroStrategy applications, dashboards, reporting, and analytics consumption.

The ideal candidate combines strong MicroStrategy development and architecture experience with advanced SQL, data engineering, Python, and investment-management domain knowledge .

This is a hands-on engineering role requiring an individual who can understand complex financial data, design scalable analytical data structures, build intuitive BI solutions, troubleshoot performance issues across multiple layers, and partner directly with Portfolio Managers, Traders, Risk professionals, and technology teams.

Key Responsibilities

• Design, develop, and support MicroStrategy-based BI and analytics solutions for Portfolio Management, Trading, Risk, Operations, and other investment-management users.
• Build dashboards, dossiers, reports, analytics applications, and self-service reporting capabilities using MicroStrategy.
• Design and maintain the MicroStrategy semantic layer , including attributes, facts, metrics, hierarchies, filters, prompts, transformations, and related metadata objects.
• Translate complex front-office business requirements into scalable BI, reporting, and data solutions.
• Work with investment datasets including: Positions and holdings, Transactions and investment activity, Security and instrument master data, Pricing and valuations, Market data, Reference data, Accounts and portfolios, Investment structures
• Understand how these investment-data domains relate to one another and design reporting models that provide users with consistent and trusted information.
• Develop and enhance scalable data pipelines supporting MicroStrategy and downstream analytical applications.
• Design source-aligned, dimensional, analytical, and curated data models optimized for BI and reporting consumption.
• Partner with Data Engineering teams to build ingestion, transformation, validation, reconciliation, and delivery processes.
• Develop advanced SQL used for data transformation, analytics, reconciliation, reporting, and performance optimization.
• Work extensively with Snowflake to design and optimize analytical datasets supporting MicroStrategy workloads.
• Use Python where appropriate for data processing, automation, validation, reconciliation, reporting support, and operational utilities.
• Optimize MicroStrategy reports, dashboards, cubes, SQL generation, database queries, and Snowflake workloads for performance and scalability.
• Investigate reporting discrepancies by tracing data from MicroStrategy through the semantic layer, database models, transformations, and upstream source systems.
• Develop and maintain data-quality and reconciliation controls to ensure BI outputs are complete, accurate, and consistent with source systems.
• Partner directly with Portfolio Managers, Traders, Risk professionals, Data teams, and business stakeholders to understand analytical workflows and reporting requirements.
• Support user acceptance testing, production validation, release activities, and ongoing production support.
• Develop reusable BI and data-engineering patterns that improve delivery consistency and maintainability.
• Establish standards around dashboard design, data modeling, SQL development, documentation, performance, security, and governance.
• Support entitlement and access-control requirements for sensitive investment and financial information.
• Document solution architecture, source-to-target mappings, data models, MicroStrategy objects, reporting logic, operational procedures, and support requirements.
• Identify opportunities to improve the user experience through analytics automation, AI-assisted development, and natural-language interaction with trusted investment data.
• Leverage AI-assisted engineering tools where appropriate to accelerate SQL development, testing, troubleshooting, documentation, and analytical solution design.

Required Skills and Experience

• 10+ years of professional experience across Business Intelligence, Data Engineering, Analytics Engineering, or enterprise data platforms.
• Strong hands-on experience developing enterprise solutions using MicroStrategy .
• Experience building and maintaining: Reports, Dashboards / Dossiers, Metrics, Attributes, Facts, Hierarchies, Filters, Prompts, Transformations, Semantic / Metadata layers.
• Strong understanding of MicroStrategy architecture and administration concepts , including how BI applications interact with databases, semantic models, caches, and reporting services.
• Advanced to expert-level SQL skills, including complex joins, aggregations, window functions, analytical queries, query optimization, and troubleshooting.
• Strong experience designing relational, dimensional, and analytical data models.
• Experience building and supporting ETL/ELT and data pipelines involving ingestion, transformation, validation, reconciliation, and delivery.
• Practical Python experience for data processing, automation, analysis, or reporting support.
• Experience troubleshooting complex reporting and data issues across: Source systems, Data pipelines, Databases, Semantic layers, MicroStrategy End-user reports and dashboards
• Strong understanding of data quality, reconciliation, data lineage, metadata, and reporting controls.
• Experience supporting enterprise-scale BI applications in production environments.
• Experience with cloud-based data environments; Azure and Snowflake experience is strongly preferred.
• Strong understanding of the complete data lifecycle from source ingestion through transformation, storage, semantic modeling, BI consumption, and end-user analytics.
• Strong experience within Asset Management, Investment Management, Capital Markets, or another complex financial-data environment.
• Strong knowledge of front-office investment data, including positions, transactions, security master, pricing, valuations, market data, reference data, accounts, portfolios, and risk/analytics data.
• Understanding of how investment data is consumed by Portfolio Managers, Traders, Risk professionals, and investment analytics teams.
• Strong communication skills with the ability to work effectively with both technical teams and front-office business stakeholders.

Compensation:

**The base salary range for this role is $160,000 - $220,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 https://www.bip-group.com/en-us/.

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 maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.