Senior Data Engineer - ETL/SQL/Matillion

Position: Senior Data Engineer - ETL/SQL/Matillion Location: St. Louis, Missouri Duration: Contract Job ID: 177007 Job Overview: As a Senior Data Engineer, you will play a critical role in designing, building, and maintaining robust data pipelines and integration solutions to ensure seamless data flow across systems. You will work with a modern suite of cloud-based technologies, including Looker, Snowflake, Atlan, and Matillion, hosted in AWS. This position offers the opportunity to work fully remote from your home residence in one of the approved states. Join a team that fosters innovation, collaboration, and growth while driving smarter decision-making and scalable growth across the organization. Responsibilities: • Design, build, and maintain robust data pipelines and integration solutions. • Develop and optimize scalable ETL/ELT processes to drive innovation and business growth. • Create and maintain source-to-target mapping and detailed ELT documentation. • Analyze, map, and troubleshoot data across all stages of the ELT process. • Provide accurate estimates for ELT tasks and recommend process improvements. • Participate in production on-call support rotation for ETL processing. • Collaborate in a team-oriented environment and work independently as needed. • Incorporate security into all decisions and daily job responsibilities. Qualifications: • Must be authorized to work in the U.S. without sponsorship now or in the future. • 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. • Ability to work 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, and functions. • 3+ years of experience in full lifecycle development, end-to-end testing, and data validation. • 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. Preferred: • 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. About PTR Global: PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com At PTR Global, we understand the importance of your privacy and security. We NEVER ASK job applicants to: • Pay any fee to be considered for, submitted to, or selected for any opportunity. • Purchase any product, service, or gift cards from us or for us as part of an application, interview, or selection process. • Provide sensitive financial information such as credit card numbers or banking information. Successfully placed or hired candidates would only be asked for banking details after accepting an offer from us during our official onboarding processes as part of payroll setup. Pay Range: $60-65/Hr The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work. If you receive a suspicious message, email, or phone call claiming to be from PTR Global do not respond or click on any links. Instead, contact us directly at +1 214-740-2424. To report any concerns, please email us at legal@pinnacle1.com