Remote Senior Snowflake Data Engineer & Power BI Expert

Delphi-US, LLC - Peacemakers in the Talent War; Madison (WI); Remote; USD 83,000 - 96,000; Full time

Job summary

Delphi-US, LLC - Peacemakers in the Talent War is seeking a Senior Snowflake Data Engineer to design and optimize BI solutions for finance, leveraging Snowflake, Power BI and SQL to support investment, risk, and performance analytics.

You will develop dashboards and semantic models, implement data quality controls, and collaborate with investment, risk and operations teams to translate complex requirements into scalable analytics. Requirements: 7+ years BI, 5+ years Power BI in production.

Qualifications

• 7+ years of enterprise BI or analytics development experience.
• 5+ years of hands-on Power BI experience in production environments.
• Expert knowledge of Power BI semantic modeling, DAX, Power BI Service, security, refresh strategies, and performance optimization.
• Advanced SQL skills with significant Snowflake experience.
• Strong understanding of dimensional modeling, including fact tables, dimensions, hierarchies, and slowly changing dimensions.

Responsibilities

• Designs, develops, and maintains enterprise Power BI dashboards, reports, and semantic models to deliver actionable insights.
• Partners with investment, risk, performance, and operations teams to translate complex business requirements into effective analytical solutions.
• Develops advanced DAX calculations, dimensional models, hierarchies, and reusable business logic to enhance reporting capabilities.
• Writes and optimizes Snowflake SQL queries for datasets related to portfolios, positions, transactions, securities, benchmarks, performance, and risk.
• Optimizes reporting solutions for performance, scalability, usability, and maintainability.
• Troubleshoots data, reporting, refresh, semantic model, and performance issues to ensure reliable data delivery.
• Implements testing, reconciliation, monitoring, and data quality controls to maintain data integrity.
• Supports source control, automated deployments, and CI/CD practices to streamline development workflows.
• Establishes BI development standards, visualization best practices, and technical documentation to ensure consistency and quality.

Skills

Stakeholder communication

Analytical thinking

Problem solving

Tools

Power BI

Snowflake

SQL

DAX

Dimensional modeling

Job description

Delphi-US, LLC - Peacemakers in the Talent War is seeking a Senior Snowflake Data Engineer to design and optimize BI solutions for finance, leveraging Snowflake, Power BI and SQL to support investment, risk, and performance analytics.

You will develop dashboards and semantic models, implement data quality controls, and collaborate with investment, risk and operations teams to translate complex requirements into scalable analytics. Requirements: 7+ years BI, 5+ years Power BI in production.