Data Engineering Specialist (ETL, SQL, Python) - Onsite Geneva

Randstad Digital Switzerland is seeking a highly skilled and motivated Data Engineering Specialist to join our team and work on an exciting project with a prestigious international organization. This role involves enhancing and developing security metrics within a large-scale IP Analytics Platform, utilizing cutting-edge cloud technologies and agile methodologies.

Responsibilities:

• Collaborate with the Information Security team to define and implement data quality assurance processes.
• Identify suitable data visualization tools and create detailed visualization and presentation layers (Tableau or Amazon QuickSight).
• Identify and document data structures for additional data sources and ensure ongoing data drift monitoring.
• Assist Information Security experts in defining and extracting relevant features for data analysis.
• Collaborate with business areas to improve the performance of central collation of big datasets.
• Develop data products, including pipelines, jobs, and transformations.
• Create use case diagrams, data, and process flow diagrams, and user guides.
• Design and implement Security Metrics presentation/visualization dashboards with drill-down capabilities.
• Ensure solution evolution in response to changing data sources and emerging technologies.

Requirements:

• A first-level university degree in information security, computer science, engineering, mathematics, business, or a related discipline.
• Expert knowledge and experience in developing and implementing ETL jobs for data warehouses using SQL and Python.
• Strong knowledge of software development languages and tools, including SQL, Python, and Spark.
• Good knowledge and experience with AWS or Azure Big Data tools (e.g., Glue, Athena, Redshift, Kinesis, Data bricks, Azure analytics, Data explorer) and cloud-based storage and functions (S3, Blob, Lambda, Azure Functions).
• Expert knowledge and experience with data engineering tools and methodologies (Data warehouse, data lake, star schema).
• Good knowledge and experience with AWS Cloud Formation or Terraform.
• Knowledge of CI/CD concepts, particularly AWS CodePipeline, CodeBuild, CodeDeploy.
• Knowledge of provisioning data APIs and information security concepts and terminology.
• Excellent written and verbal communication skills, with the ability to articulate complex technical ideas to non-technical stakeholders.
• Confident communicator and team player with strong organizational and interpersonal skills.
• Personal drive, ownership, and accountability to meet deadlines and achieve results.
• Proficient user of Git, with familiarity with Jira and Bitbucket.

Desirable:

• Additional certifications such as Certified Amazon Web Services (AWS) Solutions Architect and AWS Certified Data Analytics Specialty.
• Experience in the implementation of or demonstrable familiarity with the Gartner ODM framework.
• Experience of working with Tableau and Amazon QuickSight would be an advantage.

Ideally, you will be working from our client’s offices in Geneva, although a hybrid working arrangement (nearshore or Switzerland) is possible.