Senior Data Engineer – Migration to AWS Redshift

About the role

Intellectsoft is looking for a Senior Data Engineer to lead the migration of legacy SQL Server workloads to AWS Redshift. You will design and implement production‑grade dbt models and guide the team through best‑practice adoption.

Key responsibilities

• Develop and maintain dbt models on existing Redshift pipelines.
• Analyze, deconstruct, and rewrite legacy T‑SQL stored procedures into optimized Redshift SQL.
• Architect the dbt project structure and provide technical guidance on data modeling.
• Execute and optimise batch data transformation workflows within Redshift.

Required profile

• Strong expertise in dbt Core, including production deployment and best‑practice establishment.
• Deep knowledge of AWS Redshift and columnar database optimisation.
• Proficient in SQL with ability to read and translate T‑SQL logic.
• Upper‑Intermediate English communication skills.

Required skills

• dbt Core
• AWS Redshift
• SQL / T‑SQL
• Familiarity with SSRS (nice‑to‑have)

What we offer

• Udemy courses of your choice.
• Team‑building events, marathons and charity activities.
• Workshops, trainings and expert knowledge‑sharing.
• Clear career path and flexible hours with remote work options.