About the Role
We are looking for a highly experienced Senior Data Engineer / BI Engineer with 10+ years of experience in Business Intelligence and Analytics, specializing in Power BI, Snowflake, SQL, and Investment Management Data.
The ideal candidate will have strong hands-on expertise in enterprise Power BI development, advanced DAX, semantic modeling, Snowflake SQL optimization, and direct experience working with asset management or institutional investment organizations.
Key Responsibilities
- Design, develop, and maintain enterprise-grade Power BI dashboards, reports, and semantic models.
- Develop advanced DAX calculations, dimensional models, hierarchies, and reusable business logic.
- Build and optimize complex Snowflake SQL queries for investment and financial datasets.
- Partner with investment, risk, performance, and operational teams to deliver scalable analytical solutions.
- Optimize Power BI reports and semantic models for performance, scalability, and usability.
- Troubleshoot data, reporting, refresh, and performance-related issues.
- Implement data quality checks, testing, reconciliation, and monitoring controls.
- Support source control, automated deployments, and CI/CD practices.
- Establish BI development standards and document technical designs and business logic.
Required Skills & Experience
10+ years of overall BI / Analytics experience.
7+ years developing enterprise BI and analytical solutions.
5+ years of hands-on Power BI experience.
Expert-level Power BI, DAX, semantic modeling, and performance optimization.
Strong SQL and hands-on Snowflake experience.
Expertise in dimensional modeling (Fact Tables, Dimensions, Hierarchies, SCDs).
Direct Asset Management / Investment Management / Institutional Investment experience.
Strong understanding of investment data:
- Portfolios & Positions
- Transactions & Securities
- Benchmarks & Exposures
- Investment Performance & Risk
Nice to Have
- PL-300 Microsoft Power BI Data Analyst Certification.
- Experience with automated testing, data reconciliation, CI/CD, and source control.
- CFA, CAIA, or other investment-industry certifications.