Apply on Employer Site

ComPsych · 1 month ago

ETL Data Engineer

United States

Full-time

Remote

Mid Level

$115K/yr - $135K/yr

3+ years exp

ComPsych is the worldwide leader in organizational mental health and well-being, and they are seeking a Data Engineer to help design and develop their new Data Platform. The role involves building and managing ETL pipelines to ingest data from various sources, collaborating with business stakeholders, and ensuring data architecture is scalable and maintainable.

Mental Health Care

H1B Sponsor Likely

Responsibilities

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

Qualification

Advanced SQLAzure DatabricksPythonData modelingETL pipelinesLearning new toolsAttention to detailOrganizational skillsProblem-solvingTime management

Required

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

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

Preferred

Bachelor's degree or equivalent preferred

Prior experience with Employee Assistance Programs or Leave Administration preferred

Benefits

Paid Time Off (PTO)

Medical

Dental

Vision

401(k) with match

Robust EAP

Wellness program

And much more

Company

ComPsych

Glassdoor3.5

ComPsych® is the world’s largest provider of mental health services and GuidanceResources® for life.

Founded in 1984

Chicago, Illinois, USA

1001-5000 employees

http://www.compsych.com

H1B Sponsorship

ComPsych has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2024 (1)

2021 (1)