onsite
Senior Data Warehouse Developer - University of Rochester
Software Engineer
Lead the design, development, and optimization of enterprise data warehouse solutions using Snowflake, Azure Data Factory, and SQL, while leveraging Python for data transformation and automation.
About the role
Key Responsibilities
- Design, develop, and maintain scalable data warehouse solutions on Snowflake, ensuring high performance and data integrity.
- Build and orchestrate complex ETL pipelines using Azure Data Factory, integrating diverse data sources into a unified analytics platform.
- Write efficient SQL queries and scripts for data extraction, transformation, and loading, optimizing for speed and resource usage.
- Collaborate with data analysts and business stakeholders to translate business requirements into technical specifications and data models.
- Implement data quality checks, monitoring, and troubleshooting to maintain data accuracy and reliability.
- Document architecture, processes, and best practices for future maintenance and knowledge transfer.
Requirements
- 5+ years of experience in data warehouse development and ETL design.
- Proficiency in SQL and experience with Snowflake or similar cloud data platforms.
- Hands‑on experience with Azure Data Factory or equivalent orchestration tools.
- Strong programming skills in Python for data manipulation and automation.
- Excellent problem‑solving abilities and a collaborative mindset.