Lead Cloud Data Engineer

Oncourse Home Solutions; Naperville (IL); Hybrid; USD 95,000 - 140,000; Full time

Job summary

An established industry player is seeking a Lead Cloud Data Engineer to join their dynamic team in Naperville. This role offers the opportunity to manage the Enterprise Data Platform, collaborate with cross-functional teams, and mentor junior engineers. You will design and develop cloud-first data ingestion processes, ensuring data quality and stability while utilizing cutting-edge technologies like Snowflake and DBT. With a commitment to fostering a diverse and inclusive environment, this company values its employees and offers a competitive rewards package, including comprehensive health coverage and generous paid time off. If you are passionate about data and eager to make a difference, this is the perfect opportunity for you.

Benefits

Healthcare

Life Insurance

Paid Time Off

401(k) Plan with Company Match

Education Assistance Program

Commuter Benefits

Employee Wellness Programs

Vibrant Company Culture

Qualifications

• 10+ years in IT, mostly in Data domain.
• Strong experience in Snowflake and cloud data engineering.
• Experience with Agile SDLC processes.

Responsibilities

• Design and develop cloud-first data ingestion processes.
• Collaborate with BI and Data Science teams for analytics.
• Mentor junior engineers and participate in code reviews.

Skills

Python

SQL

Snowflake

DBT

AWS

Data Analysis

Education

Bachelor’s Degree in Computer Science

Tools

Snowflake

DBT

AWS

Airbyte

Prefect

Job description

Join to apply for the Lead Cloud Data Engineer role at Oncourse Home Solutions

Join to apply for the Lead Cloud Data Engineer role at Oncourse Home Solutions

Who We Are

Oncourse Home Solutions (OHS) is a people-centric, $450M organization that is owned by private equity firm, Apax Partners operating under the brands American Water Resources, Pivotal Home Solutions and American Home Solutions. We do what is right for our people so they can do their best when serving our 1.7+ million customers across the U.S. Our mission is to create lasting value for our customers and our partners by helping homeowners navigate the unexpected, reduce costs, and make homeownership enjoyable for all. Our vision is to make our products and services accessible to our customers and our partners by becoming the most trusted and reliable home solutions organization in the market. We are committed to fostering an environment that embraces diversity in all forms, where our employees, customers and partners feel valued, respected, and supported.

Who We Are

Oncourse Home Solutions (OHS) is a people-centric, $450M organization that is owned by private equity firm, Apax Partners operating under the brands American Water Resources, Pivotal Home Solutions and American Home Solutions. We do what is right for our people so they can do their best when serving our 1.7+ million customers across the U.S. Our mission is to create lasting value for our customers and our partners by helping homeowners navigate the unexpected, reduce costs, and make homeownership enjoyable for all. Our vision is to make our products and services accessible to our customers and our partners by becoming the most trusted and reliable home solutions organization in the market. We are committed to fostering an environment that embraces diversity in all forms, where our employees, customers and partners feel valued, respected, and supported.

As a US-based warranty provider, we provide expertise in safety and homecare to our customers. Our integrated solutions meet customer needs both inside and outside the home. Inside the home we protect critical aspects of home function such as plumbing, heating and cooling, appliances, power surges, hot water heater, and interior electrical. Outside the home we provide protection for critical lines (water, gas, wells, sewers, electric and septic). We primarily go to market B2B2C, partnering mostly with water/gas/electric utilities and municipalities to offer our product leveraging their brand for marketing and often adding our subscription fee to the water/gas/electric bill itself. When our customers need help with home maintenance, repair, or coverage, OHS is there. This is what it means to be an ‘Oncourse SUPER’—Successful, United, Progressive, Empathetic, Reliable. SUPERs get it done. We sweat homeownership so our customers and partners don’t have to. As an equal opportunity employer, our employment decisions are based on business needs, job requirements and individual qualifications without regard to race, color, religion, age, sex (including pregnancy), sexual orientation, gender identity, national origin, ancestry, marital status, parental status, mental or physical disability, military or veteran status, or any other basis protected by federal, state, or local law. Oncourse Home Solutions is committed to recruiting and retaining talented applicants and to providing all employees with a workplace free from discrimination and/or harassment.

We offer a compelling total rewards package that includes a competitive base salary and comprehensive benefits to support your total wellbeing. Our benefits include but are not limited to: healthcare, life insurance, paid time off, retirement, commuter benefits, and education reimbursement. Exact compensation may vary based on skills, experience, and location. Certain roles have the opportunity to earn generous commissions or performance-based bonuses, ensuring your hard work and success are recognized and rewarded.

Located at our office in Naperville, IL our office environment is a key driver of our company culture and employee experience, so a regular in-office Hybrid model is required (generally in-office T-TH and remote M&F).

Position Summary

As a Lead Cloud Data Engineer, you will be part of the Data engineering team managing the Enterprise Data Platform (EDP) for Oncourse. This role involves close collaboration with cross-functional teams to gather requirements, design, develop & maintain within our technology stack consisting of Snowflake, DBT, Airbyte, and Prefect. Additionally, the Lead Cloud Data Engineer will mentor junior engineers and play a key role in the success of our development team.

Responsibilities Include But Are Not Limited To

• Design & Develop cloud-first data ingestion processes using Python, SQL, Airbyte, S3 buckets, etc into Snowflake.
• Design & Develop and Maintain DBT flows utilizing DBT Core self-managed.
• Assist with design tasks for data models and infrastructure within a wide variety of markets and alternative datasets.
• Participate in code reviews to ensure best practices are followed
• Support alerting systems to ensure smooth day-to-day operations.
• Author tests to validate data quality and the stability of the platform.
• Provide data ingestion & transformation pipeline support by analyzing & fixing issues and conducting root cause analysis
• Assist with the maintenance of existing data stores before migration.
• Collaborate with BI and Data Science team to consume data from EDP to generate analytics and BI reports.
• Collaboration amongst teammates to clearly define and estimate work for user stories.
• Stay updated with new emerging technologies in the space of Enterprise Data Platform
  
  

We're excited if this is you

Experience And Qualifications Of The Role

• Over 10 years of experience in IT and majority in Data domain
• Majority of experience as a snowflake/cloud data engineer
• Demonstrate experience in developing data warehouse solutions using Snowflake
• Has strong experience in Python, DBT, Snowflake, AWS (Prefect/MWAA nice to have)
• Has a passion for data analysis and is able to think analytically.
• Has implemented code versioning standards and been part of code review meetings
• Ability to work both independently & collaboratively in a team-oriented environment
• Working knowledge of SDLC processes using Agile scrum environment
  
  

Computer Skills Needed To Perform This Job

• Proficiency in Snowflake (Required)
• Proficiency in DBT, Prefect
• Proficiency in AWS services viz. Lambda, S3 etc.
  
  

Education

• Bachelor’s Degree in computer science, information technology, or a equivalent work experience required.
  
  

Certificates, Licenses, Registrations

• Certification in Snowflake (Required)
• Certification in AWS cloud tools, Data Engineering, OR DBT (preferred)
  
  

We offer a compelling total rewards package that includes a competitive base salary and comprehensive benefits to support your total wellbeing. The base pay range for this position is $95,000 - $140,000 USD Annual. The specific pay offered will depend on qualifications, experience, education and skill set. The compensation offered may also include an annual performance-based bonus, sales incentive plan or commission target.

Our benefits include but are not limited to: healthcare, life insurance, paid time off, retirement, commuter benefits, and education reimbursement. Exact compensation may vary based on skills, experience, and location.

Join our SUPER Team and Enjoy Amazing Benefits!

• Competitive Compensation: We value your hard work and are proud of our competitive pay for performance philosophy.
• Comprehensive Health Coverage: Medical, dental, and vision insurance options, plus paid short-term and long-term disability coverage.
• 401(k) Plan with 4% Company Match: Secure your future with our robust retirement plan.
• Defined Contribution Arrangement:25% of employee annual income contributed to your retirement plan, yearly up to 7,875 dollars.
• Generous Paid Time Off: Take the time you need to recharge and relax.
• Education Assistance Program: Invest in your growth and development with our support.
• FSA/HSA Options: Flexible spending and health savings accounts to manage your transportation and dependent care expenses.
• Employee Wellness: Access to EAP, health, legal, and financial resources to support your overall well-being.
• Vibrant Company Culture: Monthly Townhalls, employee recognition programs, and Employee Business Resource Groups (EBRGs) to keep you engaged and connected.
  
  

Competencies

Action Oriented - Enjoys working hard; is action oriented and full of energy for the things that he/she sees as challenging; not fearful of acting with a minimum of planning; seizes more opportunities than others.

Problem Solving- Is tolerant with people and processes; listens and checks before acting; tries to understand the people and the data before making judgments and acting; waits for others to catch up before acting; is sensitive to due process and proper pacing; follows established process.

Functional / Technical Skills - Has the functional and technical knowledge and skills to do the job at a high level of accomplishment.

Peer Relationships - Can quickly find common ground and solve problems for the good of all; can represent his/her own interests and yet be fair to other groups; can solve problems with peers with a minimum of noise; is seen as a team player and is cooperative; easily gains trust and support of peers; encourages collaboration; can be candid with peers.

Perspective - Looks toward the broadest possible view of an issue/challenge; has broad-ranging personal and business interests and pursuits; can easily pose future scenarios; can think globally; can discuss multiple aspects and impacts of issues and project them into the future.

Self-Development - Is personally committed to and actively works to continuously improve him/herself; understands that different situations and levels may call for different skills and approaches; works to deploy strengths; works on compensating for weakness and limits.

No external recruiter or agency calls/communication will be accepted. Qualified candidates should apply online.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Consumer Services

Referrals increase your chances of interviewing at Oncourse Home Solutions by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

401(k)

Paid paternity leave

Paid maternity leave

Get notified when a new job is posted.

Sign in to set job alerts for “Data Engineer” roles.

Oak Brook, IL $100,000.00-$150,000.00 12 hours ago

Brookfield, IL $15,000.00-$180,000.00 2 days ago

Oak Brook, IL $111,000.00-$152,000.00 1 day ago

Elmhurst, IL $144,000.00-$166,000.00 1 day ago

Senior Data Engineer (Remote or Hybrid Available)

Palatine, IL $124,000.00-$139,000.00 1 week ago

Rosemont, IL $143,000.00-$194,000.00 1 week ago

Rosemont, IL $98,000.00-$132,000.00 4 days ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.