Job#: 3030381 Job Description: Full-Time Senior Data Engineer
Location: St. Louis, Missouri (Remote)
Employment Type: Permanent
Role Overview
Our organization is seeking a Senior Data Engineer to join our Information Technology department. In this role, you will design, build, and maintain robust data pipelines and integration solutions. You will be part of a team that creates and delivers leading-edge technologies and expansive systems that impact every aspect of our growing business, developing and optimizing scalable ETL/ELT processes to drive innovation.
Key Responsibilities
- Design, build, and maintain robust data pipelines and integration solutions.
- Develop and optimize scalable ETL/ELT processes.
- Create and maintain source-to-target mapping and detailed ELT documentation.
- Perform data analysis, mapping, and troubleshooting across all stages of the ELT process.
- Provide accurate estimates for ELT tasks and recommend process improvements.
- Collaborate in a team-oriented environment and work independently with direction.
- Participate in the production on-call support rotation for ETL processing.
- Incorporate security into all decisions and daily job responsibilities.
Required Qualifications
Experience:- 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.
Technical Skills:- 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.
- Knowledge of CI/CD pipelines and DevOps tools (e.g., GitHub Actions, Azure DevOps).
Preferred Qualifications
- Bachelor's degree in computer science, Computer Information Systems, Management Information Systems, Engineering, or a 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.
Compensation & Benefits
The anticipated salary range for this position is $110,000.00 to $125,000.00 annually. The company offers a comprehensive healthcare package, 401k matching & profit sharing, paid time off, and other benefits.
Company Overview
Our client is a full-service fleet management business for companies, government agencies, and organizations with medium-sized fleets. 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 the data ecosystem, enabling smarter decision-making and scalable growth across the organization.
This employer is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.
Apex uses a virtual recruiter as part of the application process. Click for more details.
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at or .
Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details.
Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Everforth Apex team member can provide.
Never miss an opportunity! Create an alert based on the job you applied for.