Senior Snowflake Data Engineer — Investment Data & BI

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

Job summary

Robotics Technologies LLC in Madison, WI is seeking a Senior Snowflake Data Warehouse Engineer to design and optimize data architectures for investment data using Snowflake, Power BI, SQL, and DAX. You will develop semantic models and high-performance queries for large financial datasets and collaborate with portfolio managers, analysts, and risk teams.

The ideal candidate has 7+ years in BI/Data Engineering or Analytics, 5+ years of Power BI, and strong knowledge of investment data, including

Qualifications

• 7+ years of experience in Data Engineering, BI or Analytics.
• 5+ years of hands-on Power BI development.
• Strong Snowflake Data Warehouse and Snowflake SQL expertise.
• Advanced SQL skills and query optimization.
• Knowledge of investment data: portfolios, positions, transactions, risk and performance.

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 datasets, ensuring data accuracy and performance.
• Build advanced DAX calculations, measures, hierarchies, and reusable logic.
• Partner with investment, risk, performance, and operations teams to gather requirements.
• Optimize reports, data models, and refresh performance.
• Troubleshoot data, reporting, and performance issues.
• Implement data quality checks, reconciliation, testing, and monitoring.
• Support source control, automated deployments, and CI/CD processes.
• Document technical solutions, data models, and business logic.

Skills

Snowflake

Power BI

SQL

DAX

Investment data

Tools

Git

CI/CD pipelines

Job description

Robotics Technologies LLC in Madison, WI is seeking a Senior Snowflake Data Warehouse Engineer to design and optimize data architectures for investment data using Snowflake, Power BI, SQL, and DAX. You will develop semantic models and high-performance queries for large financial datasets and collaborate with portfolio managers, analysts, and risk teams.

The ideal candidate has 7+ years in BI/Data Engineering or Analytics, 5+ years of Power BI, and strong knowledge of investment data, including