Senior Data Engineer (ETL/SQL/Matillion)

TL;DR

Senior Data Engineer (ETL/SQL/Matillion): Designing, building, and maintaining robust data pipelines and integration solutions with an accent on cloud-based technologies like Snowflake and Matillion in AWS. Focus on developing scalable ETL/ELT processes, optimizing complex SQL queries, and ensuring data integrity across the full development lifecycle.

Location: Must reside in one of the approved 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 available during U.S. Central Standard Time core business hours.

Salary: $60–$65/Hr

Company

hirify.global is a leading provider of information technology and workforce solutions with a vast network of professionals across the U.S. and Canada.

What you will do

• Design, build, and maintain robust data pipelines and integration solutions.
• Develop and optimize scalable ETL/ELT processes to drive innovation.
• Create and maintain source-to-target mapping and detailed ELT documentation.
• Analyze, map, and troubleshoot data across all stages of the ELT process.
• Participate in production on-call support rotation for ETL processing.
• Incorporate security into all decisions and daily job responsibilities.

Requirements

• Must be authorized to work in the U.S. without sponsorship.
• Must reside in one of the approved U.S. states listed in the location section.
• Must be available during 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, and functions.
• Experience with the Matillion platform and AWS services including Lambda.

Nice to have

• Bachelor’s degree in Computer Science, Engineering, or related field.
• Experience with unit testing for ETL/ELT pipelines and data quality frameworks.
• 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.

Culture & Benefits

• Access to medical, dental, and vision insurance.
• 401K contributions.
• Paid Time Off (PTO) and sick leave.
• Collaborative and innovation-focused team environment.