ETL Data Engineer
ComPsych
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $115,000 - $135,000 per year
Job Level
Mid-LevelSenior
Tech Stack
AzureETLNoSQLPythonSDLCSQL
About the role
- 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
Requirements
- Advanced SQL proficiency (query performance tuning, index maintenance, etc.)
- 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
Benefits
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLETLdata modelingAzure DatabricksPythonNoSQLBig Data technologiesquery performance tuningindex maintenancedatabase structures
Soft skills
attention to detailorganizational skillstime managementplanningproblem-solvingcollaborationcommunicationadaptabilitycritical thinkingrequirements gathering
Certifications
Bachelor's degree