Senior Power BI & Snowflake Engineer — Investment Data

Stockell Consulting is recruiting for an unnamed institutional investment organization. The Senior Power BI & Snowflake Engineer will build and support enterprise analytics for investment, risk, performance and operations teams, using Power BI and Snowflake.

Responsibilities:

• Design, develop and maintain Power BI reports, dashboards and semantic models that support investment and business decisions
• Partner with investment, risk, performance and operations teams to turn complex requirements into scalable analytical solutions
• Build advanced DAX, dimensional models, calculations, hierarchies and reusable business logic
• Write and optimize Snowflake SQL across portfolio, position, transaction, security, benchmark, performance and risk datasets
• Tune Power BI solutions for performance, scalability, usability and maintainability
• Troubleshoot complex reporting, data, semantic-model, refresh and performance issues
• Build testing, reconciliation, monitoring and data-quality controls that keep reporting accurate
• Support source control, automated deployment and CI/CD for BI solutions
• Set and promote Power BI development, visualization and reporting standards
• Document business logic, data models, technical designs and operating procedures

Requirements:

• This role requires the ability to work in the United States without sponsorship, now or in the future
• 7+ years developing enterprise business intelligence or analytical solutions
• 5+ years of advanced, hands-on Power BI in production environments
• Expert-level Power BI semantic modeling, DAX, performance optimization, security, refresh strategies and Power BI Service
• Expert-level SQL and significant hands-on Snowflake experience on analytical workloads
• Strong dimensional modeling — fact tables, dimensions, hierarchies and slowly changing dimensions
• Direct experience in asset management, investment management, institutional investment or closely related financial services
• Strong understanding of investment data: portfolios, positions, transactions, securities, benchmarks, exposures, performance and risk
• Experience working directly with portfolio managers, analysts, risk, performance or investment operations staff
• Clear written and verbal communication across technical and investment audiences
• Automated testing, reconciliation, data quality, source control and CI/CD practices
• PL-300 Microsoft Power BI Data Analyst Associate certification
• CFA, CAIA or another investment-industry designation