AWS Data Architect Senior Developer

2 months ago

Ottawa, Canada Nexus Systems Group Inc. Full time
AWS Data Architect Senior Developer

SCOPE: As an AWS Data Architect Senior Developer, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions. You will collaborate closely with our cross-functional teams to ensure efficient data extraction, transformation, loading (ETL), and reporting processes. Your expertise in AWS Analytics will be crucial in optimizing our data ecosystem and enabling data-driven decision-making.


DUTIES: As part of the Data Analytics team on Experience Transformation (XT) Program, the individual is responsible for delivering and maintaining a solution that best suits business requirements. The XT Program is focused on transforming and upgrading our SAP footprint to support Finance, HR, Procurement, Order to Cash, and CRM capabilities. The successful candidate will develop application code in accordance with application standards and best practices working on projects, change requests, and minor enhancements. This individual is responsible for analyzing, developing, and delivering the technical solution that satisfies the functional design documents and other useful requirements.


Key Responsibilities:
  1. Design, develop, and maintain robust and scalable data pipelines using Python Scripts.
  2. Implement ETL processes to extract, transform, and load data from various sources into our data warehouse (Amazon RedShift).
  3. Collaborate with Subject Matter Experts, data analysts, and business stakeholders to understand data requirements and ensure data accuracy and integrity.
  4. Build and maintain data models and schemas for efficient data storage and retrieval.
  5. Monitor and troubleshoot data pipelines and ETL processes to ensure smooth data flow and minimal downtime.
  6. Utilize Python programming for scripting, automation, and data manipulation tasks.
  7. Stay updated with the latest AWS services, data engineering best practices, and emerging technologies.
  8. Meet with Data Architects and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
  9. Load target databases using complex transformations that come from many systems.
  10. Monitor loads and troubleshoot any issues that arise.

SKILLS AND EXPERIENCES

Must Have:

  1. 4+ years of relevant experience in a similar role.
  2. 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.
  3. 4+ years of hands-on experience with AWS managed Apache Airflow / Apache Airflow.
  4. 4+ years of proficiency in establishing cost-effective data-centered solutions in AWS.
  5. Proficiency in SQL for data querying, manipulation, and optimization.
  6. Familiarity with consuming data from SAP S/4 entities, models, and schemas.
  7. Understanding of data integration, ETL processes, and data quality management.
  8. Excellent problem-solving skills and ability to work collaboratively in a team environment.

Nice to have:

  1. Development experience using data programming languages such as Python, Pyspark.
  2. Development with database technologies and experience with data warehousing methodologies and technologies.
  3. Experience with Data Lakehouse and Delta Lakehouse.
  4. Experience with real-time data processing and stream processing frameworks.
  5. Understanding of BI tools such as Power BI and QuickSight.
  6. Hands-on experience with Amazon RedShift or similar data warehousing solutions.
  7. Strong programming skills in Python for scripting and automation.
  8. Understanding of data integration, ETL processes, and data quality management.
  9. Good to have AWS certifications (e.g., AWS Certified Data Analytics - Specialty).
Competencies

Be Courageous
Innovate
Be Inclusive
Inspire
Be Curious
Technical Knowledge

#J-18808-Ljbffr

  • AWS Data Architect Senior Developer

    4 weeks ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior Developer OpportunityNexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and...

  • AWS Data Architect Senior Developer

    1 month ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperNexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and develop...

  • AWS Data Architect Senior Developer

    1 month ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperNexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and develop...

  • AWS Data Architect Senior Developer

    2 months ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperJob Summary:Nexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and...

  • AWS Data Architect Senior Developer

    2 months ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperJob Summary:Nexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and...

  • AWS Data Architect Senior Developer: Designing Scalable Data Solutions

    2 days ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    Job Description:Nexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. This role requires a strong focus on designing, implementing, and maintaining scalable data pipelines, databases, and data warehousing solutions using AWS technologies.About the Role:The successful candidate will be responsible for...

  • AWS Data Architect

    2 months ago

    Ottawa, Ontario, Canada Assent Compliance Inc. Full time

    Job Title: AWS Data ArchitectAssent Compliance Inc. is seeking a highly skilled AWS Data Architect to join our team. As a key member of our engineering organization, you will play a critical role in implementing our product strategy and leading the design, management, and assessment of supply chain data.Key Responsibilities:Collaborate with stakeholders to...

  • AWS Data Architect

    2 months ago

    Ottawa, Ontario, Canada Assent Compliance Inc. Full time

    Job Title: AWS Data ArchitectAssent Compliance Inc. is seeking a highly skilled AWS Data Architect to join our team. As a key member of our engineering organization, you will play a critical role in implementing our product strategy and leading the design, management, and assessment of supply chain data.Key Responsibilities:Collaborate with stakeholders to...

  • AWS Data Architect

    1 month ago

    Ottawa, Ontario, Canada Assent Compliance Inc. Full time

    Job Title: AWS Data ArchitectAssent Compliance Inc. is seeking a highly skilled AWS Data Architect to join our team. As a key member of our engineering organization, you will play a critical role in implementing our product strategy and leading the design, management, and assessment of supply chain data.Key Responsibilities:Collaborate with stakeholders...

  • AWS Data Architect

    1 month ago

    Ottawa, Ontario, Canada Assent Compliance Inc. Full time

    Job Title: AWS Data ArchitectAssent Compliance Inc. is seeking a highly skilled AWS Data Architect to join our team. As a key member of our engineering organization, you will play a critical role in implementing our product strategy and leading the design, management, and assessment of supply chain data.Key Responsibilities:Collaborate with stakeholders...

  • AWS Data Architect Senior Developer: Designing Data-Driven Solutions

    2 months ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    About the RoleNexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key ResponsibilitiesData Pipeline Design and Development:...

  • AWS Data Architect Senior Developer: Designing Data-Driven Solutions

    2 months ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    About the RoleNexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key ResponsibilitiesData Pipeline Design and Development:...

  • Data Architect

    2 months ago

    Ottawa, Ontario, Canada Assent Compliance Inc. Full time

    About Assent Compliance Inc.Assent Compliance Inc. is a leading provider of supply chain sustainability solutions for top-tier manufacturers. Our mission is to empower companies to make informed decisions about their supply chains and reduce their environmental impact.Job Title: Data ArchitectWe are seeking an experienced Data Architect to join our team. As...

  • Data Architect

    2 months ago

    Ottawa, Ontario, Canada Assent Compliance Inc. Full time

    About Assent Compliance Inc.Assent Compliance Inc. is a leading provider of supply chain sustainability solutions for top-tier manufacturers. Our mission is to empower companies to make informed decisions about their supply chains and reduce their environmental impact.Job Title: Data ArchitectWe are seeking an experienced Data Architect to join our team. As...

  • Senior Data Architect

    3 days ago

    Ottawa, Ontario, Canada SHOEBOX Ltd. Full time

    We are seeking a skilled Senior Data Engineer to play a pivotal role in shaping data-driven decisions across our organization. The ideal candidate will have a passion for building robust, scalable data solutions, leveraging Power BI to drive our data strategy and enable intelligent business decisions, while working with AWS and Heroku and supporting the...

  • Data Architect

    3 days ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are looking for a talented Data Architect to join our team. The ideal candidate will have a strong background in database design and development, with experience in operating database management systems to analyze data. Key responsibilities include designing and developing databases, developing and implementing data administration policy,...

  • Data Solutions Architect

    1 month ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Solutions Architect Job DescriptionAdecco Canada is currently recruiting for a Solutions Architect to join our team. This is a 9-month contract opportunity with a possibility of extension. The successful candidate must be eligible for a Reliability Security Clearance.Job Responsibilities:Architecture Design: Develop end-to-end solution architecture in data...

  • Data Solutions Architect

    1 month ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Solutions Architect Job DescriptionAdecco Canada is currently recruiting for a Solutions Architect to join our team. This is a 9-month contract opportunity with a possibility of extension. The successful candidate must be eligible for a Reliability Security Clearance.Job Responsibilities:Architecture Design: Develop end-to-end solution architecture in data...

  • Solution Architect Data

    2 months ago

    Ottawa, Canada Adecco Canada Full time

    Adecco is currently recruiting for a Solutions Architect. This is a 9-month Hybrid contract opportunity with a possibility of extension. This role is with one of our crown corporation client based in Ottawa. The successful candidate must be eligible for a Reliability Security Clearance. The Solutions Architect will have the following responsibilities: -...

  • Senior Storage Architect

    4 weeks ago

    Ottawa, Ontario, Canada S I Systems Full time

    Senior Storage Architect Job DescriptionWe are seeking a highly skilled Senior Storage Architect to support our client’s Digital Hub under Air and Space Force development.The Resource will be responsible for developing new cloud-based data pipelines and ETLs from new sources using new and/or existing services, developing backend cloud-based databases for...