Intellectsoft is a software development company delivering innovative solutions since ****. We specialize in industries like Fintech, Healthcare, EdTech, Construction, Hospitality, and more, partnering with startups, mid-sized businesses, and Fortune 500 companies to drive innovation and scalability. We need a Senior Data Engineer to spearhead migration from SQL Server to AWS Redshift. 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. 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 Familiarity with SSRS (SQL Server Reporting Services) is a nice-to-have, as some of the client's reporting layer still interacts with it 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 Workshops, trainings, expert knowledge-sharing that keep you growing Adaptable hours & work setup
- work from any of listed locations and organize your day your way #

📌 Senior Data Engineer (Álava)
🏢 Intellectsoft
📍 Álava