Lead Cloud Data Engineer

ZipRecruiter; Naperville (IL); Hybrid; USD 95,000 - 140,000; Full time

Job summary

An innovative organization is seeking a Lead Cloud Data Engineer to oversee their Enterprise Data Platform. This pivotal role involves designing and developing cloud-first data solutions, mentoring junior engineers, and collaborating with cross-functional teams to enhance data analytics capabilities. With a commitment to employee well-being and a vibrant company culture, this position offers competitive compensation and comprehensive benefits. Join a forward-thinking team that values technical expertise and fosters an inclusive environment where your contributions can make a significant impact.

Benefits

Healthcare

Life Insurance

Paid Time Off

Retirement Plans

Commuter Benefits

Education Reimbursement

Wellness Programs

Qualifications

• 10+ years of IT experience, focusing on data engineering.
• Expertise in Snowflake and cloud data solutions.
• Strong analytical skills and ability to mentor others.

Responsibilities

• Design cloud data ingestion processes using Python and SQL.
• Develop and maintain DBT workflows and data models.
• Collaborate with teams to ensure data quality and stability.

Skills

Python

SQL

Snowflake

DBT

Data Analysis

Agile Scrum

Education

Bachelor’s Degree in Computer Science

Tools

AWS

DBT Core

Airbyte

Prefect

S3

Job description

Job Description

Who we Are

Oncourse Home Solutions (OHS) is a people-centric, $450M organization owned by private equity firm Apax Partners, operating under the brands American Water Resources, Pivotal Home Solutions, and American Home Solutions. We prioritize our employees' well-being to enable them to serve our 1.7+ million customers across the U.S. Our mission is to create lasting value for our customers and partners by helping homeowners navigate the unexpected, reduce costs, and enjoy homeownership. Our vision is to become the most trusted and reliable home solutions organization, making our services accessible and fostering an inclusive environment where everyone feels valued, respected, and supported.

As a US-based warranty provider, we offer expertise in safety and homecare, providing integrated solutions both inside and outside the home. We partner mainly with water, gas, and electric utilities and municipalities, offering products that are often added to utility bills. Our team, the ‘Oncourse SUPERs,’ stands for Successful, United, Progressive, Empathetic, Reliable — and we are committed to excellence in homeownership support. We are an equal opportunity employer, committed to diversity and inclusion in our hiring and employment practices.

We offer a comprehensive rewards package including a competitive salary, healthcare, life insurance, paid time off, retirement plans, commuter benefits, and education reimbursement. Exact compensation varies based on skills, experience, and location, with opportunities for bonuses or commissions where applicable.

Location and Office Environment

Our office is located in Naperville, IL. We operate on a hybrid model, typically in-office T-TH and remote M-F, to foster a positive company culture and employee experience.

Position Summary

We are seeking a Lead Cloud Data Engineer to manage our Enterprise Data Platform (EDP). This role involves collaborating with cross-functional teams to gather requirements, design, develop, and maintain data solutions using Snowflake, DBT, Airbyte, and Prefect. The lead will also mentor junior engineers and contribute to the success of our data engineering team.

Responsibilities

• Design and develop cloud-first data ingestion processes using Python, SQL, Airbyte, S3, etc., into Snowflake.
• Develop and maintain DBT workflows with DBT Core.
• Assist in designing data models and infrastructure across various markets and datasets.
• Participate in code reviews and support operational alerting systems.
• Create tests to ensure data quality and platform stability.
• Analyze and resolve issues in data pipelines and conduct root cause analysis.
• Maintain existing data stores post-migration.
• Collaborate with BI and Data Science teams to utilize data for analytics and reporting.
• Define and estimate work for user stories with teammates.
• Stay updated on emerging technologies in enterprise data platforms.

Qualifications

• Over 10 years of IT experience, primarily in Data.
• Extensive experience as a Snowflake/cloud data engineer.
• Proven ability to develop data warehouse solutions with Snowflake.
• Strong skills in Python, DBT, Snowflake, AWS (Prefect/MWAA a plus).
• Passion for data analysis and strong analytical thinking.
• Experience with code versioning and participating in code reviews.
• Ability to work independently and collaboratively.
• Knowledge of SDLC and Agile Scrum methodologies.

Technical Skills

• Proficiency in Snowflake, DBT, Prefect, AWS services like Lambda, S3.

Education

• Bachelor’s Degree in Computer Science, IT, or equivalent experience.

Certifications

• Snowflake certification (Required).
• AWS, Data Engineering, or DBT certification (Preferred).

Compensation & Benefits

The base salary range is $95,000 - $140,000 USD annually, dependent on experience and qualifications. Additional performance-based bonuses or commissions may apply. Benefits include health coverage, retirement plans, paid time off, education assistance, and wellness programs.

Join Our Team

Enjoy a competitive compensation package, comprehensive health benefits, a vibrant company culture, and opportunities for professional growth. We value action orientation, problem-solving, technical expertise, collaboration, and a broad perspective. We are committed to continuous self-development and fostering an inclusive environment.

No external recruiter or agency communications will be accepted. Qualified candidates should apply online.