Data ETL PRD Support Engineer

• Design, develop, implement, and support new and existing ETL and ELT processes.
• Serve in a production support role, investigating and resolving data pipeline issues.
• Trace data inaccuracies reported via API or reporting tools back to the source system to fix the root cause.
• Develop, test, and maintain the code required to move data.
• Participate in a production on-call support rotation schedule.
• Maintain documentation on ELT processes and procedures.
• Assist with the creation and maintenance of ELT specifications, such as source-to-target maps.
• Conduct project-specific data analysis, including analyzing and mapping required data.

The ETL Developer is responsible for the design, development, implementation, and support of new and existing ETL and ELT processes. This individual will apply communication skills, problem-solving skills, and knowledge of best practices related to Data Warehouse and Business Intelligence solutions. The ideal candidate will be a self-motivated individual with experience in AWS and cloud-based development, tasked with transforming enterprise data architecture., * Advanced command of SQL and PL/SQL.

• Familiarity with ETL processes and the ability to investigate data pipeline issues.
• 3+ years of experience working with Matillion.
• 2+ years of experience with a scripting or programming language such as Python.
• Experience with AWS Lambda functions and data pipelines.
• Experience implementing Change Data Capture (CDC).
• Demonstrated proficiency with Kimball dimensional modeling concepts.
• Must be committed to incorporating security into all decisions and daily job responsibilities.
• Must currently reside in one of the following states: AL, AZ, FL, GA, ID, IL (Saint Louis Metropolitan Area Only), IN, KS, KY, LA, MO, NC, NV, OH, OK, PA, SC, TN, TX, UT, VA, or WI., * Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, Engineering, or a related field.
• 5+ years in an ETL/ELT development role.
• 5+ years of experience developing and supporting a data warehouse.
• Experience with Oracle Database, AWS Postgres, MySQL, and SQL Server.
• Knowledge of calling APIs, handling JSON responses, and Looker reporting.
• Experience with Oracle Data Integrator.
• Experience building self-service reporting solutions using business intelligence software (e.g., OBIEE, Looker, Power BI).

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 ClearlyRateds 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. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at