Job Description
Remote Role Virtual Interviews 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. • 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