Data Engineer - Power BI / Snowflake

• Design, develop, and maintain enterprise-grade Power BI dashboards, reports, and semantic models.
• Translate complex business requirements into scalable analytical solutions.
• Develop advanced DAX calculations, business logic, hierarchies, and dimensional models.
• Create and optimize complex Snowflake SQL queries supporting large analytical datasets.
• Work extensively with investment-related data including portfolios, positions, transactions, benchmarks, performance, exposures, and risk metrics.
• Optimize reporting solutions for performance, scalability, maintainability, and usability.
• Troubleshoot reporting, refresh, data quality, and semantic model issues.
• Build testing, reconciliation, monitoring, and data quality controls.
• Support source control, CI/CD pipelines, and automated deployments.
• Establish Power BI development standards and reporting best practices.
• Create technical documentation, business logic documentation, and operational procedures.
• Partner with both technical teams and business stakeholders to deliver reporting solutions., * Microsoft Power BI
• DAX
• Snowflake
• Advanced SQL
• Power BI Service

Data Architecture

• Enterprise Semantic Models
• Dimensional Data Modeling
• Fact & Dimension Tables
• Slowly Changing Dimensions (SCD)
• Financial Data Reconciliation
• Data Quality Controls
• Large-Scale Analytical Datasets

DevOps & Best Practices

• CI/CD
• Source Control
• Automated Deployments
• Testing & Monitoring
• Performance Tuning

We are seeking a highly experienced Senior Data Engineer with deep expertise in Power BI, Snowflake, SQL, and enterprise business intelligence solutions. The ideal candidate will possess strong investment management domain knowledge and a proven track record of designing, developing, and optimizing scalable analytics and reporting solutions used by investment, risk, performance, and operations teams.

This role requires advanced Power BI development, semantic and dimensional modeling expertise, Snowflake data engineering experience, and the ability to collaborate directly with business stakeholders to deliver data-driven insights., * 7+ years of Business Intelligence, Data Engineering, or Analytics solution development experience.

• 5+ years of hands-on Power BI development in enterprise production environments.
• Extensive experience building reporting solutions using large and complex datasets.

Power BI Expertise

• Semantic Modeling
• Advanced DAX Development
• Performance Optimization
• Power BI Security
• Data Refresh Strategies
• Power BI Service Administration

Data Engineering & Database Skills

• Expert-level SQL development skills.
• Strong hands-on Snowflake experience.
• Experience building and supporting enterprise analytical solutions.

Data Modeling

• Fact & Dimension Modeling
• Dimensional Modeling
• Hierarchies
• Slowly Changing Dimensions (SCD)
• Reusable Business Calculations, * Strong verbal and written communication skills.
• Ability to explain technical concepts to non-technical stakeholders.

Preferred Qualifications

• Experience implementing automated testing frameworks.
• Data quality monitoring and reconciliation experience.
• Source control and CI/CD implementation experience.
• Microsoft PL-300 Certification.
• CFA, CAIA, or related investment industry certifications., * Advanced Power BI Development
• Complex DAX Calculations
• Snowflake Data Engineering
• SQL Performance Optimization
• Investment & Portfolio Analytics
• Enterprise Reporting Solutions
• Stakeholder-Facing Analytics

Domain Expertise

• Asset Management
• Investment Management
• Institutional Investing
• Financial Services Analytics

Investment Data Experience

• Portfolio & Position Reporting
• Investment Transactions
• Securities & Benchmarks
• Portfolio Exposures
• Performance Analytics
• Risk Analytics

Stakeholder Engagement

• Experience working directly with:

• Portfolio Managers
• Investment Analysts
• Risk Teams
• Performance Teams
• Investment Operations Teams