Senior Snowflake Data Warehouse Engineer / Data Engineer

Quantum Technologies LLC; Madison (WI); On-site; USD 89,000 - 126,000; Full time

Job summary

Quantum Technologies. LLC in Madison, Wisconsin seeks a Senior Snowflake Data Warehouse Engineer with strong Snowflake, Power BI, SQL, DAX, and investment-management data experience.

You will design and maintain enterprise Power BI reports and semantic models, optimize Snowflake queries, and work with high-volume financial datasets to deliver accurate insights. Collaboration with investment and risk teams, documenting solutions and supporting CI/CD deployments, with a focus on data quality and

Qualifications

• 7+ years in Data Engineering, BI, or Analytics.
• 5+ years of Power BI development experience.
• Expert Snowflake Data Warehouse and Snowflake SQL.
• Advanced SQL skills and query optimization.
• Power BI Service: security, refresh, performance.
• Experience with investment data domains (portfolios, transactions, risk, performance).
• Excellent communication with investment stakeholders.

Responsibilities

• Design, develop, and maintain enterprise 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.
• 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.

Skills

Power BI

Power BI development

Snowflake

SQL

DAX

Semantic modeling

Data engineering

Financial data

Tools

Git

CI/CD pipelines

Job description

Senior Snowflake Data Warehouse Engineer / Data Engineer

Location:

Madison, WI

Duration:

8Months+ Extension

Domain Exposure:

Manufacturing

Client:

To Be Discussed Later

Employment Type:

W-2, 1099, C2C

Work Authorization:

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

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

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

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.