This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

[smartslider3 slider=2]

Senior AWS Data Integration Developer


This is a Contract position in Kanata, ON posted November 13, 2023.

Senior AWS Data Integration Developer

Adecco is currently recruiting for a Senior AWS Data Integration Developer. It is a 9- Months hybrid contract opportunity (occasional visit on site) with a possibility of extension. This role is with our Crown corporation client in Ottawa, ON. The successful candidate must hold a valid Reliability Security Clearance.

The Senior AWS Data Integration Developer will have the following responsibilities:

  • ­Design, develop, and maintain robust and scalable data pipelines using Python Scripts.

  • Implement ETL processes to extract, transform, and load data from various sources into our data warehouse (Amazon RedShift).

  • ­Collaborate with Subject Matter Experts, data analysts, and business stakeholders to understand data requirements and ensure data accuracy and integrity.

  • ­Build and maintain data models and schemas for efficient data storage and retrieval.

  • ­Monitor and troubleshoot data pipelines and ETL processes to ensure smooth data flow and minimal downtime.

  • ­Utilize Python programming for scripting, automation, and data manipulation tasks.

  • ­Stay updated with the latest AWS services, data engineering best practices, and emerging technologies.

  • ­Meet with Data Architects and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.

  • ­Load target data bases using complex transformations that come from many systems.

  • ­ Monitor loads and troubleshoot any issues that arise.

    The Senior AWS Data Integration Developer must meet the following mandatory requirements:

  • ­4+ years of relevant experience in a similar role;

  • 4+ years of proven experience as a Data Engineer, with a strong focus on AWS technologies (S3, AWS Glue, Lambda, Athena) and developing ETL/ELT pipelines using these AWS services;

  • ­4+ years of hands On with AWS managed Apache Airflow / Apache Airflow;

  • ­4+ year of proficiency in establishing cost-effective data centered solutions in AWS;

  • ­Proficiency in SQL for data querying, manipulation, and optimization;

  • ­Familiarity with consuming data from SAP S/4 entities, models, and schemas;

  • ­Understanding of data integration, ETL processes, and data quality management;

  • ­Excellent problem-solving skills and ability to work collaboratively in a team environment;

The following skills/experience would be an asset:

  • Development experience using data programming languages such as Python, Pyspark;

  • ­Development with database technologies and experience with data warehousing methodologies and technologies.

  • Experience with Data Lakehouse and Delta Lakehouse.

  • ­Experience with real-time data processing and stream processing frameworks.

  • ­Understanding of BI tools such as Power BI and QuickSight.

  • ­Hands-on experience with Amazon RedShift or similar data warehousing solutions.

  • ­Strong programming skills in Python for scripting and automation.

  • ­Understanding of data integration, ETL processes, and data quality management.

  • ­Good to have AWS certifications (e.g., AWS Certified Data Analytics – Specialty).

If you are interested in applying to our Senior AWS Data Integration Developer role, please submit your resume as soon as possible by clicking on the ‘Apply with Adecco’ button.