Senior Data Engineer (548)
Core
Lead migration from SQL Server to AWS Redshift and build production-grade data models using dbt Core.
Role type
Senior Data Engineer (Data Migration & Modeling)
Builds
Production-grade data models and reporting environments on AWS Redshift
Domain
Cloud Data Engineering (AWS, SQL)
Deliverable
production ML models | product features
Required skills
dbt Core, AWS Redshift, SQL (T-SQL to Redshift migration), Data Modeling
Preferred skills
SSRS
Technologies
AWS Redshift, dbt Core, SQL Server
Responsibilities
Develop and maintain dbt models leveraging existing Redshift pipelines; Analyze, deconstruct, and migrate legacy T-SQL stored procedures into modular, optimized Redshift SQL models; Architect the dbt project structure and provide technical guidance on data modeling strategies; Execute and optimize batch data transformation workflows within Redshift.