Senior Data Engineer - ETL/SQL/Matillion

Enterprise Fleet Management is a privately held, full-service fleet management business. They are seeking a Senior Data Engineer to design, build, and maintain robust data pipelines and integration solutions that ensure seamless data flow across systems, driving innovation and pushing the business forward.

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

Requirements:

• Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our 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 and end-to-end testing and data validation
• Experience with 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
• 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