ETL Data Engineer

ComPsych^Ⓡ is the worldwide leader in organizational mental health, well-being, and absence management, dedicated to igniting human potential in workplaces across the globe. For over 40 years, we have combined the best in technology with unmatched human expertise to help individuals and their organizations thrive. Our GuidanceResources^Ⓡ and AbsenceResources^Ⓡ solutions deliver end-to-end mental health, well-being, work-life, health navigation, and absence support to more than 75,000 customers worldwide,  touching more than 160 million lives across 200 countries. Visit compsych.com to find out why 40% of the Fortune 500 choose ComPsych for their mental health and absence management needs.

We are seeking a Data Engineer to help design and develop our new Data Platform. You will assist in building, administering, and creating ETL pipelines to ingest data from various sources into the platform. Success in this role requires excellent business acumen and communication skills, along with the ability to collaborate with business owners to understand their data requirements and guide data-related decisions using your ETL expertise.

This role also requires the ability to quickly learn new tools and technologies. You should possess in-depth database knowledge and strong programming and scripting skills. You will help build efficient, stable data pipelines that are easily maintainable. Ideal candidates will have expertise in the design, creation, management, and business application of large datasets.

• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading (ETL) activities
• Gather requirements and business process knowledge to transform data in ways that meet end-user needs
• Create new SDLC processes as needed and maintain and improve existing processes
• Ensure data architecture is scalable and maintainable
• Collaborate with business stakeholders and colleagues to design and deliver accurate, high-quality data
• Investigate data to identify potential issues within ETL pipelines, notify end users, and propose effective solutions
• Prepare and maintain documentation for future reference
• Additional duties as assigned

• Advanced SQL proficiency (query performance tuning, index maintenance, etc.) and understanding of database structures
• Strong knowledge of data modeling principles
• Deep expertise in Azure Databricks (3+ years of experience required)
• Deep expertise in Python (3+ years of experience required)
• Knowledge of various SQL/NoSQL data storage mechanisms and Big Data technologies
• Bachelor’s degree or equivalent preferred
• High attention to detail
• Strong organizational skills, including time management and planning
• Passion for complex data structures and problem-solving
• Ability to quickly learn new data tools and concepts
• Prior experience with Employee Assistance Programs or Leave Administration preferred
• Target salary $115-$135K

• Full benefits package, including Paid Time Off (PTO), medical, dental, vision, 401(k) with match, robust EAP, wellness program, and much more
• Competitive pay with annual increases

EEO

ComPsych is an equal opportunity employer.  All applicants will be considered for employment regardless of race, color, age, genetics, religion, gender, sexual orientation, gender identity, national origin, disability or protected veteran status and any other characteristic protected by federal, state or local laws. ComPsych Corporation maintains a drug free workplace.