Senior Data Engineer - AWS Glue - Full Remote - Contractor in USD

For an international organization in Geneva, Switzerland, we are urgently looking for a Full Remote Senior Data Engineer. The Senior Data Engineer is responsible for the implementation of the set of automated ETL pipelines, implementation of the analytics of the platform operations and importing new data sources and its maintenance. The Analytics Data Platform is a cloud-native application deployed on AWS through CloudFormation templatesusing the following resources: Glue, S3, Lambda, Step Function, Airflow, Athena, RDS, Redshift, and Lake Formation.Candidates need to be willing to work normal office hours in Switzerland. This positions is long-term.Tasks and Responsibilities:Refactor, develop, maintain the web analytics ETL pipelineUse data pipeline jobs to extract data from various sources including on premise relational databases, APIs,Use data pipeline jobs to curate extracted raw dataUse data pipeline jobs to apply transformation based on reporting needsData source connectors to ingest the data from various data sourcesWrite the spark SQLs to produce the datasetsMonitor, troubleshoot and remediate the above jobsData ModellingMaintenance of the existing data models in the data lake and data warehouseDesign & Implement data models for new data sources as requiredRefactor, maintain the CloudFormation templates and CDK as per the CICD guidelines/requirementsOther ad hoc deliverables required by the projectProfile:University degree in computer science, engineering or other related discipline;+5 years of experience as Data Engineer;Hands-on experience writing code for AWS Glue in python with PySpark and Spark SQL;Relational databases such as PostgreSQL (preferably AWS Redshift) with expertise in SQL, query optimization;Serverless Query Service, preferably AWS Athena;Experience in implementing an end to end cloud native Data warehouse platform - data modelling;ETL, data integration and data migration, preferably related to AWS Redshift;Expertise in SQL, query optimization;Experience in implementing data integration from different sources;Experience with AWS IaC (CloudFormation & CDK) and CICD pipelines;Experience in Python programming and using PySpark for distributed computing in AWS Cloud;Experience in working with ERP applications such as PeopleSoft is an added advantage;Development of Reports/Dashboards using Tableau is an added advantage;Fluent in English;

Apply Now