Description

You will own the design and implementation of scalable data transformation pipelines.

This role is remote.

Responsibilities

• Design and build scalable data transformation pipelines using SQL, DBT, and Jinja templating.
• Develop and maintain data architecture and standards for Data Integration and Data Warehousing using DBT.
• Ensure data pipeline operation between OneTrust and external data platforms (ESPs, CRMs).
• Own the full stack of data modeling in DBT to serve analysts, data scientists, and BI engineers.
• Apply software engineering best practices, including version control, CI/CD, and code reviews.

Required Skills

• 5+ years of experience in data engineering and analytics on modern data platforms.
• 3+ years of extensive experience with DBT, building complex models and packages/macros.
• Deep familiarity with dimensional modeling and data warehousing concepts.
• Expertise in designing and operating enterprise dimensional models.
• Hands-on experience with AWS Services (Lambda, Step Functions, Glue, Redshift).
• Proficiency in SQL and experience optimizing queries for performance.
• Experience with AWS CDK, CodeCommit, and CodePipeline for CI/CD.
• Experience with Agile development and working with offshore teams.

Preferred Skills

• Familiarity with data integration tasks involving connectors and APIs.

Key Skills

Education

Bachelor's or Master's degrees