Data Engineer
- Hybrid
- Geneva
- Business Intelligence & Data
Data Engineer
Job description
We have an opening for a Data Engineer to strengthen our client's team based in Geneva. This position is for an exciting project involving the design, implementation and management of robust data pipelines using AWS and Snowflake services. You will contribute to the data strategy and work on innovative technical solutions to meet the company's data analysis needs.
Job responsibilities:
- Design, implement and maintain robust ETL pipelines with AWS (Glue, Lambda, Step Functions) and Snowflake, transforming and loading data from various sources.
- Develop and optimise complex SQL queries for data transformation and analysis in AWS Athena and Snowflake, focusing on star and snowflake schemas.
- Create and manage data models, ensuring proper implementation of fact tables and dimensions for reporting and business intelligence needs.
- Building and managing scalable data ingestion pipelines in AWS Data Lake, including setting up Lake Formation for data sharing between accounts. Implement data quality controls and alert mechanisms based on defined business rules, using AWS services and custom solutions.
- Use Infrastructure as Code (IaC) tools such as AWS CloudFormation or Terraform to provision and manage AWS resources. Implement and maintain CI/CD pipelines for automated testing, versioning and deployment of data solutions. Ensure data privacy, compliance and security throughout the solution lifecycle, including the correct configuration of AWS IAM and Lake Formation. Monitor data pipelines and infrastructure using AWS CloudWatch and other relevant tools.
Job requirements
- Bachelor's or Master's degree in a technical field.
- More than 5 years' experience in data engineering or a similar role.
- Solid knowledge of AWS services, particularly in the context of data processing (Lambda, Step Functions, S3, Athena, Glue, Lake Formation, CloudFormation).
- Advanced SQL skills, capable of writing complex queries for data transformation and analysis.
- Proficiency in Python.
- Experience with recognised data integration/ETL platforms. Experience with CI/CD tools and general DevOps practices. Excellent command of English.
- Preferred qualifications:
AWS or Snowflake certifications.
Details
- Geneva
or
Details
- Geneva
All done!
Your application has been successfully submitted!
What's on offer
Continous Training
Develop your knowledge and benefit from a large training catalog
25 days paid vacations (+1)
All of our employees are entitled to 25 days of paid vacation per year. And December 24th is offered
Regular social events
Monthly events to gather in small or large groups.
Great team members
Respect and kindness are key values in our workplace.
International contexts
Projects within international-scale groups.
Innovation
Contribute to impactful and innovative projects in various sectors of activity.
Little pleasures
Our employees benefit from a program of very interesting advantages and discounts.
About us
Sword has been a leading player in Switzerland for more than 20 years in consulting and IT services, software development, infrastructure management, and quality assurance. From our offices in Geneva, Nyon, Lausanne, Fribourg, and Sion, and in collaboration with the Group's centers worldwide, our nearly 400 employees accompany large organizations, private companies, and government agencies in their technological transformations.
