Sr Cloud Data Engineer

Who we Are

Oncourse Home Solutions (OHS) is a people-centric, $400M 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.6+ million customers across the U.S. Our mission is to help homeowners navigate the unexpected, reduce costs, and make homeownership enjoyable for all. Our vision is to make our products and services accessible to all by becoming the most forward-thinking and community-driven home solutions organization of the 21st century. 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 safeguard essential systems like plumbing, heating and cooling, appliances, power surge protection, hot water heaters, and interior electrical components. Outside the home, we ensure the protection of vital lines, including water, gas, wells, sewers, electric, and septic systems. 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 don t have to. We view every day as an opportunity to step up, step out, and remind others that we are in this together, to stay on course.

We are a proud equal opportunity employer, and our employment decisions are based on business needs, job requirements and individual qualifications without regard to of race, sex, gender identity, sexual orientation, color, pregnancy status, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state, or local law. Oncourse Home Solutions is committed to recruiting talented applicants and retaining top talent while providing an employment experience that is free from discrimination, retaliation, and/or harassment.

Located at our office in Naperville 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 Sr. Cloud Data Engineer, you will be part of the Data engineering team managing the Enterprise Data Platform (EDP) for Oncourse. You will be responsible for development tasks within our technology stack consisting of Snowflake, DBT, Airbyte, and Prefect. Also, you will be part of design meetings and provide guidance for data migration projects from external vendors.

Responsibilities include but not limited to:

• Develop cloud-first data ingestion processes using Python, SQL, Airbyte, S3 buckets, etc into Snowflake.
• 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.
• Support alerting systems to ensure smooth day-to-day operations.
• Author tests to validate data quality and the stability of the platform.
• Investigate and defuse time-sensitive data incidents.
• Assist with the maintenance of existing data stores after 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.

We're Excited if this is You

• Bachelor's Degree in Computer Science (or relevant experience)
• 5+ 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, Airbyte, 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

Certificates, Licenses, Registrations

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

Computer Skills Needed to Perform this Job

• Proficiency in Snowflake
• Proficiency in Airbyte, DBT, Prefect
• Proficiency in AWS services viz. Lambda, S3 etc.

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.
• Deferred Contribution Arrangement: 5.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

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.

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 after acting; tries to understand the people and the data after making judgments and acting; waits for others to catch up after acting; sensitive to due process and proper pacing; follows established process.

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.

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.

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