Senior Data Engineer (IR-548)
Core
Spearhead 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
Domain
Data Engineering / Cloud Data Warehousing
Deliverable
production ML models
Required skills
dbt Core, AWS Redshift, SQL (T-SQL to Redshift), 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.
