Data Engineer - ETL/SQL/Matillion @ St. Louis, MO - Permanent Role - Remote opportunity

Remote Role Virtual Interviews Position: Data Engineer - SQL/ETL/Matillion Location: St Louis, MODuration: Perm role Visa: ONLY US Citizens or Green Card holdersExperience: Minimum 15+ YearsMust 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, WIResponsibilities: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 AbilitiesAbility to create and maintain source-to-target mapping and detailed ELT documentationSkilled in data analysis, mapping, and troubleshooting across all stages of the ELT processAbility to provide accurate estimates for ELT tasks and recommend process improvementsStrong problem-solving skills and ability to work in a team-oriented, fast-paced environmentExcellent verbal and written communication skillsMust be able to both collaborate in a team-oriented environment and work independently with directionWillingness to participate in production on-call support rotation for ETL processingKnowledge 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 futureMust 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, WIMust 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 transformation3+ years of experience writing and tuning complex SQLs, stored procedures, triggers, functions, and error trapping3+ years of experience in full lifecycle development, end-to-end testing, and data validationExperience with the Matillion platformStrong experience with AWS services, including Lambda functions and data pipeline orchestrationProven experience implementing Change Data Capture (CDC) strategiesMust be committed to incorporating security into all decisions and daily job responsibilitiesPreferred:Bachelor's degree in computer science, Computer Information Systems, Management Information Systems, Engineering, or related fieldExperience with unit testing for ETL/ELT pipelines and data quality frameworksStrong ability to write complex queries and optimize for large-scale datasetsExperience with job optimization and integration with CI/CD pipelinesAbility to mentor junior engineers and lead small projectsExperience in Agile/Scrum environments and familiarity with DevOps principles