🇬🇧
The English-language job board for Spain
Overview
Job details
Fully remote
Per the ad.
Requirements
Have the right to work in Spain
Intellectsoft doesn't mention sponsorship in the ad.
Work in English
English is required, per the ad.
Have senior-level experience
Senior-level role.
Pay & benefits
What you'll get
- 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
Requirements
What we're looking for
- 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
- Familiarity with SSRS (SQL Server Reporting Services) is a nice-to-have, as some of the client's reporting layer still interacts with it.
The role
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 impact Together, 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.
What you'll do
- 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.
About Intellectsoft
Intellectsoft is a global digital transformation and IT consulting company that builds custom software solutions for enterprises. With a workforce of over 2,000 professionals, it operates across multiple industries, including fintech, healthcare, retail, and logistics, delivering services from strategy and design to engineering and managed services. The company has a strong presence in the US and Europe, with its headquarters in Palo Alto, California, and significant delivery centers in Eastern Europe and Latin America.
In Spain, Intellectsoft has an established office in Madrid, which serves as a hub for its operations in the region. The company is known for its international and multicultural work environment, often hiring engineers and architects from around the world. For international professionals, Intellectsoft offers a dynamic environment with opportunities to work on global projects, and the Madrid office provides a gateway to the Spanish tech scene, making it an attractive option for those looking to relocate.
- Founded
- 2007
- Employees
- 1,000–5,000
- Headquarters
- Palo Alto, USA
- In Spain
- Barcelona
- Website
- intellectsoft.net
Good to know if you are moving
- Intellectsoft has a global presence with delivery centers in Europe, including Spain, which can facilitate a smoother relocation process.
- The company's multicultural environment and English-speaking work culture make it accessible for international professionals.
- The Barcelona office is a key hub for the company's operations in Southern Europe, offering opportunities to work with a diverse, international client base.
- Intellectsoft provides a comprehensive relocation package for employees moving to Spain, including assistance with visas and work permits.
- The company is known for its flexible work arrangements, including remote work options, which can be beneficial during the relocation period.
In their own words
About the company & team
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.
More jobs like this
or browse Data engineering·Senior·Remote
🇬🇧
🇬🇧
🇬🇧
🇬🇧
🇬🇧
🇬🇧