🕒 yesterday
Design, build, and optimize cloud-based data pipelines and models using GCP and dbt, while collaborating with cross-functional teams to enhance data environments.
Senior Data Engineer (IR-548)
🕒 25 days ago
Dbt CoreAWS RedshiftSQLT-SQL
📜 Description
- 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
🛠️ 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
- Familiarity with SSRS (SQL Server Reporting Services) is a nice-to-have, as some of the client’s reporting layer still interacts with it.
✨ 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
Full job description
Intellectsoft is a software development company delivering innovative solutions since 2007. We operate across North America, Latin America, the Nordic region, the UK, and Europe.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. Our clients include Jaguar Motors, Universal Pictures, Harley-Davidson, and many more where our teams are making daily impactTogether, our team delivers solutions that make a difference. 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
Similar jobs
Search more Data Engineer jobs
Senior Data Engineer (Cloud)
🕒 2 days ago
Social-Discovery-Ventures👥 501 - 1000 employees🏢 Computer Software
🕒 2 days ago
As a Senior Data Engineer, you will lead the migration of our MS SQL data warehouse to Google Cloud, build scalable data pipelines, and enhance our cloud data platform.
🕒 yesterday
As a Senior Data Engineer, you will build and operate large-scale data and machine learning pipelines, collaborating closely with Data Scientists and ML Engineers to enhance production workflows.
🕒 yesterday
As a Senior Data Engineer, you will build and operate large-scale data and machine learning pipelines, focusing on Python, AWS, and ETL processes to enhance data-driven solutions.
🕒 yesterday
As a Senior Data Engineer, you will build and operate large-scale data and machine learning pipelines, focusing on Python, AWS, and ETL processes to enhance data-driven decision-making.