Oncourse Home Solutions (OHS) is a people-centric 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.4+ 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.
We partner with cities, utilities, insurance providers, retailers, financial service companies and member associations to help them maintain and protect their customers’ most important asset—their home. Our passion for empowering customers to confidently run their households is what drives us. 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 they’re 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 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. OHS is committed to recruiting and retaining talented applicants and to providing all employees with a workplace free from discrimination and/or harassment.
Located at our office in Naperville, IL or Mt. Laurel, NJ, our office environment is a key driver of our company culture and employee experience. A regular in-office HYBRID model is required (generally in office Tues/Wed/Thurs. and remote M & F).
Position Summary
As a Cloud Data Engineer, you will be part of the Data engineering team managing the Enterprise Data Platform (EDP) for Oncourse. You shall be driving innovation and supporting the platform to mature the organization to a data driven org.
Responsibilities
- Develop cloud-first data ingestion processes using Python, SQL, Spark, NodeJS, Airflow, etc into Snowflake.
- Develop and Maintain DBT flows
- Engineer data models and infrastructure for a wide variety of markets and alternative datasets.
- Design and build services and plugins to enhance our Data Acquisition Platform.
- Maintain 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 before migration.
- Collaborate with BI team to consume data from EDP to generate analytics and BI reports.
- Collaboration amongst teammates to clearly define and estimate user stories.
We’re Excited if This is You
Experience and Qualifications of the Role
- 3 to 5 years of experience in IT and majority in Data domain
- Strong experience as snowflake data engineer
- Has strong experience in DBT, Airbyte, Snowflake, AWS
- Has a passion for data analysis and is able to think analytically.
Computer Skills Needed to Perform this Job
- Proficiency in Snowflake
- Proficiency in Airbyte, DBT, Prefect
- Proficiency in AWS services viz. Lambda, S3 etc.
Certificates, Licenses, Registrations
- Certification in Snowflake (Preferred)
- Certification in AWS cloud tools (preferred)
Bachelor’s degree in Computer Science (Preferred) (or relevant experience)
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.
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.
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; 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.
Functional and Technical Skills – Has the functional and technical knowledge and skills to do the job at a high level of accomplishment.
#LI-MY1