Job Details

Remote Role

Virtual Interviews

Please read the following job description thoroughly to ensure you are the right fit for this role before applying.

Position: Data Engineer - SQL/ETL/Matillion

Location: St Louis, MO

Duration: Perm role

Visa: ONLY US Citizens or Green Card holders

Experience: Minimum 15+ Years

Must currently reside in one of the following states: AL, AZ, FL, GA, ID, IL (excludes Cook County), IA, IN, KS, KY, LA, MD, MI, MO, NV, NM, NC, OH, OK, PA, SC, TN, TX, UT, VA, WV, WI

Responsibilities:

• The Data Services team supports a modern suite of cloud-based technologies—including Looker, Snowflake, Atlan, and Matillion—hosted in AWS.
• These tools form the foundation of EFM's data ecosystem, enabling smarter decision-making and scalable growth across the organisation.
• As an Engineer 2 (Data), the candidate will design, build, and maintain robust data pipelines and integration solutions that ensure seamless data flow across systems.
• Candidates will develop and optimise scalable ETL/ELT processes—driving innovation and pushing the business forward.
• Passionate about data? Join the client's team to collaborate, innovate, and deliver high-quality, reliable solutions that power smarter decisions.

Knowledge, Skills, and Abilities

• Ability to create and maintain source-to-target mapping and detailed ELT documentation
• Skilled in data analysis, mapping, and troubleshooting across all stages of the ELT process
• Ability to provide accurate estimates for ELT tasks and recommend process improvements
• Strong problem-solving skills and ability to work in a team-oriented, fast-paced environment
• Excellent verbal and written communication skills
• Must be able to both collaborate in a team-oriented environment and work independently with direction
• Willingness to participate in production on-call support rotation for ETL processing
• Knowledge of CI/CD pipelines and DevOps tools (e.g., GitHub Actions, Azure DevOps)

Qualifications:

Required:

• Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by the client's company for this position now or in the future
• Must currently reside in one of the following states: AL, AZ, FL, GA, ID, IL (excludes Cook County), IA, IN, KS, KY, LA, MD, MI, MO, NV, NM, NC, OH, OK, PA, SC, TN, TX, UT, VA, WV, WI
• Must be able to work a schedule within U.S. Central Standard Time core business hours. xywuqvp
• 3+ years of hands-on experience with ETL for data integration and transformation
• 3+ years of experience writing and tuning complex SQLs, stored procedures, triggers, functions, and error trapping
• 3+ years of experience in full lifecycle development, end-to-end testing, and data validation
• Experience with the Matillion platform
• Strong experience with AWS services, including Lambda functions and data pipeline orchestration
• Proven experience implementing Change Data Capture (CDC) strategies
• Must be committed to incorporating security into all decisions and daily job responsibilities

Preferred:

• Bachelor's degree in computer science, Computer Information Systems, Management Information Systems, Engineering, or related field
• Experience with unit testing for ETL/ELT pipelines and data quality frameworks
• Strong ability to write complex queries and optimize for large-scale datasets
• Experience with job optimization and integration with CI/CD pipelines
• Ability to mentor junior engineers and lead small projects
• Experience in Agile/Scrum environments and familiarity with DevOps principles

Remote working/work at home options are available for this role.