Senior Data Engineer (IR-548)

Learn more at www.intellectsoft.net/

We need a Senior Data Engineer to spearhead migration from SQL Server to AWS Redshift. This role focuses on building production-grade models using dbt Core and mentoring the team through the implementation process. You will be responsible for defining a dbt project architecture and establishing best practices to ensure a scalable, high-performance reporting environment.

A technology and consulting company specializing in customer loyalty, personalization, data analytics, and AI-powered solutions for large enterprise brands across industries such as travel, hospitality, retail, and entertainment. The company combines consulting expertise with a SaaS loyalty platform, helping clients design, implement, and optimize loyalty programs, improve customer engagement, and use data and AI to deliver personalized experiences.

Requirements

• Strong expertise in dbt Core (experience establishing best practices, structuring models, and running dbt in production).
• Deep knowledge of AWS Redshift and columnar database optimization.
• Strong SQL proficiency: ability to read and understand legacy T-SQL (SQL Server) logic and rewrite it into modern Redshift SQL.
• At least Upper-Intermediate level of English

Nice to have skills

• Familiarity with SSRS (SQL Server Reporting Services) is a nice-to-have, as some of the client’s reporting layer still interacts with it.

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 using dbt.
• Architect the dbt project structure and provide technical guidance on data modeling strategies to the internal engineering team.
• Execute and optimize batch data transformation workflows within Redshift.

Benefits

• Udemy courses of your choice
• Team-buildings, events, marathons & charity activities to connect and recharge
• Workshops, trainings, expert knowledge-sharing that keep you growing
• Clear career path
• Absence days for work-life balance
• Flexible hours & work setup - work from any of listed locations and organize your day your way