Senior Data Engineer - ETL​/Matillion

Need candidates in the following 20 locations

AL, AZ, FL, GA, , 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

• 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 organization.?
• As an Engineer 2 (Data), candidate will design, build, and maintain robust data pipelines and integration solutions that ensure seamless data flow across systems.
• Candidates will develop and optimize scalable ETL/ELT processes—driving innovation and pushing the business forward.
• Passionate about data? Join client’s team to collaborate, innovate, and deliver high-quality, reliable solutions that power smarter decisions.

• 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 Dev Ops tools (e.g., Git Hub Actions, Azure Dev Ops)

• Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by client’s company for this position now or in the future
• Must currently reside in one of the following states: AL, AZ, FL, GA, , 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 and end-to-end testing and data validation
• Experience with Matillion platform
• Strong experience with AWS services, including Lambda functions and data pipeline orchestration
• Must be committed to incorporating security into all decisions and daily job responsibilities

• 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 Dev Ops principles