Senior Data Engineer (Chicago- Hybrid) - Hyatt Corporate Office

Hyatt seeks an experienced Senior Data Engineer to join its growing engineering team. This role will work closely with engineering, product managers, and data science teams to meet data requirements for various initiatives. The position is part of a highly visible, collaborative, and passionate data engineering team, focusing on design, development, and implementation of scalable and reliable data products and pipelines.

What You Will Do

Build data pipelines that enable engineers, analysts, and other stakeholders across the organization. Build data models to deliver insightful analytics while ensuring the highest standard of data integrity. Integrate different data sources, improve efficiency, reliability, and latency of the data system, help automate data pipelines, and improve data model and overall architecture. Lead multiple data projects with planned and coordinated execution and on-time delivery of quality products.

Why It Might Be a Fit

This role requires 8+ years of experience in data engineering or related technical work, including business intelligence and analytics. The ideal candidate is comfortable solving problems in an ambiguous, fast-paced environment and has experience designing and building scalable data pipelines. The position offers a salary range of $135,000 - $170,000, eligibility for an annual bonus, and corporate benefits including free hotel stays, flexible work schedule, and wellbeing initiatives.

Requirements

• 8+ years of experience within the field of data engineering or related technical work including business intelligence, analytics
• Experience designing and building scalable and robust data pipelines to enable data-driven decisions for the business
• Very good understanding of the full software development life cycle
• Very good understanding of Data warehousing concepts and approaches
• Experience in building Data pipelines and ETL approaches
• Experience in building high-volume data workflows in a cloud environment
• Experience in building Data warehouses and Business intelligence projects
• Experience in data cleansing, data validation, and data wrangling
• Hands-on experience in AWS cloud and AWS native technologies such as Glue, Lambda, Kinesis, Lake Formation, S3, DynamoDB, Step Functions, Athena
• Hands-on API development experience using AWS API Gateway, CloudWatch, Cognito, ECS, EKS, Fargate
• Experience with Business Intelligence tools like Tableau, Cognos, ThoughtSpot
• Experience with relational databases like Oracle, Snowflake, including advanced SQL, Tasks/Streams, stored procedures, and performance tuning
• Hands-on experience with Snowflake Cortex AI, AI SQL functions or an equivalent production LLM platform
• Proficient in SQL, PL/SQL, NoSQL, relational databases (RDBMS), database concepts, and dimensional modeling
• Hands-on experience with Python/shell scripting and SQL for building scalable data pipelines
• Experience with CI/CD tools such as GitHub Actions and/or Jenkins, and infrastructure as code with Terraform and/or CloudFormation
• Strong verbal and written communication skills
• Demonstrate analytical and problem-solving skills, particularly those that apply to Data Warehouse and Big Data environments
• Effective problem-solving and analytical skills
• Ability to manage multiple projects and report simultaneously across different stakeholders
• Rigorous attention to detail and accuracy

Benefits

• Annual allotment of free hotel stays at Hyatt hotels globally
• Flexible work schedule
• Work-life benefits including wellbeing initiatives such as a complimentary Headspace subscription, and a discount at the on-site fitness center
• A global family assistance policy with paid time off following the birth or adoption of a child as well as financial assistance for adoption
• Paid Time Off
• Medical insurance
• Dental insurance
• Vision insurance
• 401K with company match
• Eligibility to earn an annual bonus