Senior Data Engineer - ETL/SQL

Overview

As we continue to build our team in support of our vision to the be the world's best and most trusted mobility company, Enterprise Fleet Management, an affiliate of Enterprise Mobility is excited to announce the opening of a Senior Data Engineer.

The Information Technology (IT) department of Enterprise Fleet Management builds and implements powerful solutions that help to drive and support the operations of our business spread across the US and Canada. Here, you will be part of a team that creates and delivers leading-edge technologies and expansive systems that impact every aspect of our growing businesses. We provide the resources to enable and develop our innovative I.T. professionals in a variety of career paths.

Being a member of EFM IT offers all the advantages of a smaller shop including the opportunity to shape a more progressive architecture. Professionals who effectively navigate change and readily wear many hats will find this an opportunity to maximize skill diversity and build broad IT experience.

This position is eligible for a hybrid work schedule, which includes the ability to work from home, while also requiring to be in person as needed at our Lakeside and/or Clayton Corporate HQ campus locations in St. Louis, Missouri.

Enterprise Fleet Management offers a comprehensive healthcare package, 401k matching & profit sharing, paid time off, great discounts, and organizational growth potential.

Company Overview

Enterprise Fleet Management is a privately held, full-service fleet management business for companies, government agencies and organizations with medium-sized fleets. With more than 50 fully staffed offices nationwide, our team of experts can assemble a customized or full-service fleet management program that is just right for each business. With a North American fleet of 730,000 vehicles and growing at over 7 percent, the opportunity with Enterprise Fleet Management is tremendous. Our business continues to thrive, and we remain committed to the investment in and the development of our people. We do the right thing by our customers and employees every time and in every situation. Not only is that great for business (as seen in our global growth and success) it's also great for employees.

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.

Knowledge, Skills, & 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)

• 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 reside in St. Louis, Missouri, or immediate surrounding area
• 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