Job Title: Senior Snowflake Data Warehouse Engineer / Data Engineer

Location: Madison, WI

Duration: 8 Months + Extension

Bill Rate: $78/hour (C2C)

Job Type: W-2, 1099, C2C

Client: To Be Discussed Later

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description:

• We are seeking an experienced Senior Snowflake Data Warehouse Engineer with strong expertise in Snowflake, Power BI, SQL, DAX, and investment management data.
• The ideal candidate will have 7+ years of experience in Business Intelligence, Data Engineering, or Analytics, with hands-on experience supporting large-scale financial, portfolio, or asset management datasets.
• The candidate must have strong Power BI development and semantic modeling skills, advanced SQL expertise, and a solid understanding of investment data, including portfolios, positions, transactions, securities, benchmarks, risk, and performance.
• Excellent communication skills are essential, as the candidate will work closely with investment professionals, portfolio managers, analysts, risk teams, and business stakeholders.

Key Responsibilities:

• Design, develop, and maintain enterprise-level Power BI reports, dashboards, and semantic models.
• Develop and optimize complex SQL queries and Snowflake data warehouse solutions.
• Work with high-volume financial and investment datasets, ensuring data accuracy and performance.
• Build advanced DAX calculations, measures, hierarchies, and reusable business logic.
• Develop dimensional data models, including fact tables, dimensions, and slowly changing dimensions.
• Partner with investment, risk, performance, and operations teams to understand business requirements.
• Optimize Power BI reports, dashboards, data models, and refresh performance.
• Troubleshoot data, reporting, refresh, and performance-related issues.
• Implement data quality checks, reconciliation, testing, and monitoring processes.
• Support source control, automated deployments, and CI/CD processes.
• Document technical solutions, data models, and business logic.

Required Skills & Qualifications:

• 7+ years of experience in Data Engineering, Business Intelligence, or Analytics.
• 5+ years of hands-on Power BI development experience.
• Strong expertise in Snowflake Data Warehouse and Snowflake SQL.
• Expert-level SQL skills and query optimization experience.
• Advanced Power BI, DAX, and semantic modeling experience.
• Experience with Power BI Service, security, refresh strategies, and performance tuning.
• Strong understanding of dimensional modeling and data warehousing concepts.
• Must have experience supporting high-volume financial, portfolio, or investment datasets.
• Direct experience in Asset Management, Investment Management, Institutional Investment, or Financial Services.
• Understanding of portfolios, positions, transactions, securities, benchmarks, exposures, performance, and risk.
• Experience working with portfolio managers, investment analysts, risk professionals, or investment operations teams.
• Excellent verbal and written communication skills.

Preferred Qualifications:

• Microsoft PL-300 Power BI Data Analyst Certification.
• CFA, CAIA, or other investment-related certifications.
• Experience with automated testing, data reconciliation, and data quality frameworks.
• Experience with Git, source control, and CI/CD pipelines.