Senior Data Engineer – ETL / SQL / MatillionTECHNOLOGY PARTNERS INC • United States
This job offer is no longer available
Senior Data Engineer – ETL / SQL / Matillion
TECHNOLOGY PARTNERS INC
- United States
- United States
About
Do you have experience building scalable ETL/ELT pipelines, writing complex SQL, and working with cloud-based data platforms like AWS and Matillion?
Let us help you make your next big career move a reality!
What You Will Be Doing: As a Senior Data Engineer, you will design, build, and optimize modern data pipelines within a cloud-based ecosystem. You will play a critical role in enabling data-driven decision-making by ensuring reliable, scalable, and high-performance data integration solutions. This role operates in a fully remote environment and collaborates across cross-functional teams to deliver impactful data solutions.
Key Responsibilities:
Design, develop, and maintain scalable ETL/ELT pipelines using modern data tools
Build and optimize complex SQL queries, stored procedures, triggers, and functions
Develop and maintain source-to-target mappings and detailed ELT documentation
Implement and manage Change Data Capture (CDC) processes
Troubleshoot and resolve data pipeline and integration issues across systems
Collaborate with data analysts, engineers, and business stakeholders to deliver data solutions
Work with cloud platforms (AWS) to orchestrate and manage data workflows
Contribute to CI/CD pipelines and DevOps practices for data engineering workflows
Perform data validation, testing, and quality assurance for pipeline outputs
Participate in on-call support rotation for production ETL processes
Provide accurate estimates for development efforts and recommend process improvements
Mentor junior engineers and contribute to best practices and standards
Required Skills & Experience:
3+ years of hands-on experience with ETL/ELT data integration and transformation
3+ years of experience writing and optimizing complex SQL (queries, stored procedures, triggers, functions)
Experience with Matillion ETL platform
Strong experience with AWS services (e.g., Lambda, data pipeline orchestration)
Proven experience implementing Change Data Capture (CDC) strategies
Experience with full lifecycle development, end-to-end testing, and data validation
Strong analytical and problem-solving skills
Experience working in Agile or fast-paced team environments
Knowledge of CI/CD pipelines and DevOps tools (e.g., GitHub Actions, Azure DevOps)
Strong communication skills and ability to work both independently and collaboratively
Desired Skills & Experience:
Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field
Experience with data warehousing platforms such as Snowflake
Familiarity with data governance and cataloging tools (e.g., Atlan)
Experience with BI/reporting tools such as Looker
Strong understanding of large-scale data optimization techniques
Experience with unit testing frameworks for data pipelines and data quality validation
Ability to mentor junior engineers and lead small-scale technical initiatives
Experience integrating ETL pipelines into CI/CD workflows
Exposure to Agile/Scrum methodologies and DevOps best practices
Pay: $98,000 - $140,000 /yr.
We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to provide sponsorship at this time or accept candidates who would require a corp-to-corp agreement.
If this position sounds like you, WE SHOULD TALK!
Your better future is ready, and we want to put the right tools in your hands to get you there. Let's go!
All offers of employment at Technology Partners are contingent upon clear results of a thorough background check and drug screening that meet corresponding laws and regulations at the city, state and federal level.
Pay ranges are influenced by candidate qualifications, experience, and role specifics, with the actual rate determined considering skills, market conditions, and are subject to change by the employer; pay negotiations follow all state and federal legal guidelines.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.