Sr. Data Engineer, Snowflake
Location/HYBRID preferred: Chicago, downtown - 3 days per week
*Open to remote candidates as well
Duration: 6 months+
Role Overview
Design, build, test, and maintain software programs and data applications. Responsibilities include researching, designing, documenting, and updating software specifications throughout the development lifecycle, troubleshooting and resolving software issues promptly, and providing status updates as needed.
Responsibilities:
- Design and implement scalable ETL/ELT pipelines in cloud environments
- Develop and optimize data models and SQL queries for performance
- Orchestrate, schedule, and monitor data pipelines
- Build dashboards and reporting/BI solutions for self-service analytics
- Apply data warehousing and dimensional modeling best practices
- Support large-scale datasets and analytical reporting needs
- Collaborate with stakeholders, analysts, and engineering teams to deliver data-driven solutions
Requirements:
- Senior-level experience in data engineering, with working knowledge of reporting/analytics
- Strong, hands-on experience with Snowflake (mandatory)
- Solid experience with AWS services, particularly S3 (mandatory)
- Proficiency in Python for data engineering tasks within AWS
- Experience with Airflow for pipeline orchestration
- SQL proficiency required (minimum 8/10 skill level)
- Solid understanding of data warehousing concepts and ETL/ELT principles
- Strong communication skills and comfort engaging directly with business stakeholders
- Ability to manage projects independently and take full ownership end-to-end