AWS Data Architect Senior Developer: Designing Data-Driven Solutions

2 months ago


Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time
About the Role

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
  1. Data Pipeline Design and Development: Design, develop, and maintain robust and scalable data pipelines using Python Scripts.
  2. ETL Process Implementation: Implement ETL processes to extract, transform, and load data from various sources into our data warehouse (Amazon RedShift).
  3. Collaboration and Communication: Collaborate with Subject Matter Experts, data analysts, and business stakeholders to understand data requirements and ensure data accuracy and integrity.
  4. Data Modeling and Schema Development: Build and maintain data models and schemas for efficient data storage and retrieval.
  5. Monitoring and Troubleshooting: Monitor and troubleshoot data pipelines and ETL processes to ensure smooth data flow and minimal downtime.
  6. Python Scripting and Automation: Utilize Python programming for scripting, automation, and data manipulation tasks.
  7. Staying Up-to-Date: Stay updated with the latest AWS services, data engineering best practices, and emerging technologies.
  8. Business Requirements and Systems Goals: Meet with Data Architects and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.
  9. Complex Data Transformations: Load target databases using complex transformations that come from many systems.
  10. Issue Resolution: Monitor loads and troubleshoot any issues that arise.
Requirements
  1. Relevant Experience: 4+ years of relevant experience in a similar role.
  2. AWS Technologies: 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. AWS Managed Apache Airflow: 4+ years of hands-on experience with AWS managed Apache Airflow / Apache Airflow.
  4. Cost-Effective Data Solutions: 4+ years of proficiency in establishing cost-effective data-centered solutions in AWS.
  5. SQL Proficiency: Proficiency in SQL for data querying, manipulation, and optimization.
  6. SAP S/4 Experience: Familiarity with consuming data from SAP S/4 entities, models, and schemas.
  7. Data Integration and ETL: Understanding of data integration, ETL processes, and data quality management.
  8. Problem-Solving and Teamwork: Excellent problem-solving skills and ability to work collaboratively in a team environment.
Preferred Qualifications
  1. Data Programming Languages: Development experience using data programming languages such as Python, Pyspark.
  2. Database Technologies: Development with database technologies and experience with data warehousing methodologies and technologies.
  3. Data Lakehouse and Delta Lakehouse: Experience with Data Lakehouse and Delta Lakehouse.
  4. Real-Time Data Processing: Experience with real-time data processing and stream processing frameworks.
  5. BI Tools: Understanding of BI tools such as Power BI and QuickSight.
  6. Amazon RedShift: Hands-on experience with Amazon RedShift or similar data warehousing solutions.
  7. Python Programming: Strong programming skills in Python for scripting and automation.
  8. Data Integration and ETL: Understanding of data integration, ETL processes, and data quality management.
  9. AWS Certifications: Good to have AWS certifications (e.g., AWS Certified Data Analytics - Specialty).


  • 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...


  • 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...


  • 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...


  • 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...


  • 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...


  • 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

    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...


  • Ottawa, Ontario, Canada Black Pen Recruitment Full time

    Job Title: Data Solution ArchitectWe are seeking an experienced Data Solution Architect to join our team. As a Data Solution Architect, you will be responsible for designing and implementing large-scale data platforms, business intelligence, and analytics solutions for our clients.Key Responsibilities:Architect and design end-to-end data platforms, including...


  • Ottawa, Ontario, Canada Black Pen Recruitment Full time

    Job Title: Data Solution ArchitectWe are seeking an experienced Data Solution Architect to join our team. As a Data Solution Architect, you will be responsible for designing and implementing large-scale data platforms, business intelligence, and analytics solutions for our clients.Key Responsibilities:Architect and design end-to-end data platforms, including...

  • 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,...


  • 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...


  • 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...


  • Ottawa, Ontario, Canada Data Sentinel Full time

    About the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...


  • Ottawa, Ontario, Canada Data Sentinel Full time

    About the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...


  • Ottawa, Ontario, Canada Black Pen Recruitment Full time

    Job Title: Senior Data Solutions ArchitectWe are seeking an experienced Senior Data Solutions Architect to join our team at Black Pen Recruitment. As a Senior Data Solutions Architect, you will be responsible for designing, implementing, and delivering large-scale data platforms, data lakes, data warehouses, and data analytics solutions using Azure cloud...


  • 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

    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...