Senior Data Engineer – Power BI / Snowflake (Investment Management)
Location: Remote
Duration: 6 Months (Extension Possible)
Experience: 7+ Years
Employment Type: Contract
Job Overview
We are seeking a highly experienced Senior Data Engineer / Power BI Developer with strong expertise in Power BI, Snowflake, SQL, and investment management data.
The ideal candidate will have extensive experience designing and developing enterprise-grade Power BI dashboards, reports, and semantic models, along with advanced DAX and SQL skills. Candidates must have direct experience working within asset management, institutional investment, or financial services environments.
The selected consultant will collaborate with investment, risk, performance, and operations teams to build scalable analytical solutions supporting critical business and investment decisions.
Key Responsibilities
- Design, develop, and maintain enterprise-level Power BI dashboards, reports, and semantic models.
- Develop advanced DAX calculations, measures, hierarchies, and reusable business logic.
- Build, optimize, and maintain complex SQL queries in Snowflake.
- Develop dimensional data models, including fact tables, dimensions, hierarchies, and slowly changing dimensions (SCD).
- Work with investment-related datasets, including portfolios, positions, transactions, securities, benchmarks, exposures, performance, and risk.
- Collaborate with portfolio managers, investment analysts, risk professionals, and business stakeholders to translate requirements into analytical solutions.
- Optimize Power BI reports, semantic models, and Snowflake queries for performance and scalability.
- Troubleshoot reporting, data refresh, semantic modeling, and performance-related issues.
- Implement data validation, reconciliation, testing, and data quality controls.
- Support source control, automated deployments, and CI/CD processes for BI solutions.
- Establish Power BI development standards, visualization best practices, and technical documentation.
Required Skills & Qualifications
- 7+ years of experience in Business Intelligence, Data Engineering, or Analytics.
- 5+ years of hands-on experience developing enterprise Power BI solutions.
- Expert-level knowledge of Power BI, including:
- Power BI Desktop and Power BI Service
- Advanced DAX and Power Query
- Semantic modeling and data modeling
- Performance optimization
- Row-Level Security (RLS)
- Data refresh strategies and workspace management
- Strong SQL development and query optimization skills.
- Significant hands-on experience with Snowflake.
- Strong understanding of dimensional modeling, star schemas, fact tables, dimensions, and slowly changing dimensions.
- Mandatory experience in Asset Management, Investment Management, Institutional Investment, or Financial Services.
- Strong understanding of investment data, including portfolios, positions, transactions, securities, benchmarks, exposures, performance, and risk.
- Experience working with portfolio managers, investment analysts, risk teams, or investment operations.
- Excellent analytical, problem-solving, communication, and stakeholder management skills.
Preferred Qualifications
- Experience with BI automation, automated testing, data reconciliation, and data quality frameworks.
- Experience with Git, source control, and CI/CD deployment practices.
- Microsoft PL-300 Power BI Data Analyst Associate Certification.
- CFA, CAIA, or other relevant investment industry certifications.
Additional Information
- Initial 6-month contract with potential extension.
- Candidates should have strong hands‑on development experience and the ability to work independently in an enterprise investment analytics environment.