Senior Snowflake DW Engineer | Power BI & Finance Data

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

Job summary

Robotic Technologies Automation in Madison, WI seeks a Senior Snowflake Data Warehouse Engineer / Data Engineer to own large-scale BI and data warehouse solutions. You will design Power BI reports, build complex Snowflake SQL, and model investment data for portfolio analysis.

Collaboration with investment professionals and risk teams is essential. The role requires 7+ years in BI/Analytics, strong Power BI and SQL skills, and experience with asset management data.

Qualifications

• 7+ years of experience in Data Engineering, BI, 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.

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.

Skills

Power BI

SQL

DAX

Snowflake

Semantic modeling

Data warehousing

Investment data

Communication

Tools

Git

CI/CD pipelines

Job description

Robotic Technologies Automation in Madison, WI seeks a Senior Snowflake Data Warehouse Engineer / Data Engineer to own large-scale BI and data warehouse solutions. You will design Power BI reports, build complex Snowflake SQL, and model investment data for portfolio analysis.

Collaboration with investment professionals and risk teams is essential. The role requires 7+ years in BI/Analytics, strong Power BI and SQL skills, and experience with asset management data.