Senior Data Engineer - Power BI / Snowflake

Location: Shorewood Hills, WI Salary: $75.00 USD Hourly - $80.00 USD Hourly Description:
Position Overview
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.
Key Responsibilities

• 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.

Required Qualifications
Experience

• 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

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

Communication

• 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.

Technical Environment
Primary Technologies

• 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

Ideal Candidate Profile
The ideal candidate will be a:

• Advanced Power BI Development
• Complex DAX Calculations
• Snowflake Data Engineering
• SQL Performance Optimization
• Investment & Portfolio Analytics
• Enterprise Reporting Solutions
• Stakeholder-Facing Analytics

Medical, dental, and vision insurance are available to qualified candidates who meet eligibility requirements.
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact:
This job and many more are available through The Judge Group. Please apply with us today!