Senior Data Engineer – AWS Redshift
Location: Remote with occasional site visits to Stockholm, Sweden
Contract Length: 12 Months
Start Date: ASAP
We are seeking an experienced Senior Data Engineer with strong expertise in AWS Redshift to join a leading IT consulting client on a 12-month contract. You will play a key role in designing, optimizing, and maintaining large-scale data warehouse environments, while working closely with cross-functional teams to deliver scalable, high-performance data solutions.
Key Responsibilities
- Design, build, and optimize large-scale cloud data warehouse solutions on AWS Redshift
- Perform query execution plan analysis, distribution/sort key strategy, WLM tuning, and other advanced Redshift optimization techniques
- Develop and maintain dbt models for data transformation and orchestration
- Apply advanced SQL skills for data extraction, transformation, and performance tuning
- Implement effective data modeling strategies, including dimensional modeling (Kimball), normalized, and hybrid approaches
- Monitor system performance and troubleshoot issues using CloudWatch and Redshift Console
- Contribute to CI/CD pipelines, data versioning, and collaborative workflows within dbt
- Partner with stakeholders to ensure reliable, scalable, and efficient data solutions
Required Skills & Experience
- 6+ years of data engineering experience, ideally within cloud-based data warehouse environments
- Proven expertise with AWS Redshift internals, including optimization and troubleshooting
- Strong SQL programming and query tuning skills
- Hands-on experience with dbt for data modeling and transformations
- Strong knowledge of data modeling techniques (Kimball dimensional modeling, normalized, hybrid)
- Experience with AWS monitoring tools such as CloudWatch and Redshift Console
- Exposure to CI/CD practices, data versioning, and collaborative development workflows
Nice to Have
- Experience with Airflow for workflow orchestration
- Familiarity with AWS Glue for ETL processes