AWS Data Architect Senior Developer

1 week 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. 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:
  • 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.
SKILLS AND EXPERIENCES
Must Have:
  • 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.
Nice to have:
  • 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).
Competencies
Be Courageous
Innovate
Be Inclusive
Inspire
Be Curious
Technical Knowledge #J-18808-Ljbffr

  • AWS Data Architect Senior Developer

    Found in: Jooble CA O C2 - 1 week ago

    Ottawa, ON, 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...

  • Data Architect with AWS Data Lake

    Found in: Talent CA C2 - 1 week ago

    Ottawa, Canada Brainhunter Full time

    Data Architect - #61310About the Job: Mindwire is currently seeking a Senior Data Architect to work for our valued Federal Government client.The position is remote.Responsibilities: Increase clients data handling capacity by orders of magnitude (provide more data to consumers) Make data accessible, shareable and understandable (democratize data and...

  • Senior Data Solution Architect

    Found in: Jooble CA O C2 - 1 week ago

    Ottawa, ON, Canada S.i. Systems Full time

    Our valued Public Sector client is in need of a Senior Secret Cleared data solution architect to develop and implement a cloud data management and analytics platform The client requires expertise in data management and analytics services to provide assistance in designing, developing and operationalizing data management and analytics services and...

  • Manager, Data Architect

    Found in: Talent CA C2 - 1 day ago

    Ottawa, Canada Canada Post Full time

    Job Description Reporting to the Director, Enterprise Data Architect, the Manager, Data Architect is a skilled problem solver who can build and support data management frameworks and address data-related issues. This individual plays a crucial role in shaping the data landscape of Canada Post, ensuring that data assets are managed effectively,...

  • Senior Secret Cleared data solution architect to develop and implement a cloud data management

    1 week ago

    Ottawa, Canada S.i. Systems Full time

    Our valued Public Sector client is in need of a Senior Secret Cleared data solution architect to develop and implement a cloud data management and analytics platform The client requires expertise in data management and analytics services to provide assistance in designing, developing and operationalizing data management and analytics services and solutions...

  • Senior Secret Cleared data solution architect to develop and implement a cloud data management

    1 week ago

    Ottawa, Canada S.i. Systems Full time

    Our valued Public Sector client is in need of a Senior Secret Cleared data solution architect to develop and implement a cloud data management and analytics platform The client requires expertise in data management and analytics services to provide assistance in designing, developing and operationalizing data management and analytics services and solutions...

  • Senior Secret Cleared data solution architect to develop and implement a cloud data management

    1 week ago

    Ottawa, Canada S.i. Systems Full time

    Our valued Public Sector client is in need of a Senior Secret Cleared data solution architect to develop and implement a cloud data management and analytics platform The client requires expertise in data management and analytics services to provide assistance in designing, developing and operationalizing data management and analytics services and solutions...

  • CRA - Cloud Security Architect L3 - 1 yr - 2023-01

    Found in: Jooble CA O C2 - 1 week ago

    Ottawa, ON, Canada Dls Technology Corporation Full time

    Applications Services Ottawa Contract Jan 12, 2024 Senior Cloud Security Architect – long term contract Senior Cloud Security Architect – long term contract Company: DLS Technology Corporation Office Location: Ottawa, Ontario We are looking for a senior Cloud Security Architect who has a sound understanding of configuring and implementation...

  • Senior Secret Cleared data solution architect to develop and implement a cloud data management

    Found in: Jooble CA O C2 - 1 week ago

    Ottawa, ON, Canada S.i. Systems Full time

    Our valued Public Sector client is in need of a Senior Secret Cleared data solution architect to develop and implement a cloud data management and analytics platform The client requires expertise in data management and analytics services to provide assistance in designing, developing and operationalizing data management and analytics services and...

  • Cloud Solutions Architect

    Found in: Talent CA C2 - 1 week ago

    Ottawa, Canada TV2 Consulting Full time

    Google cloud (GCP), AWS and MicroStrategy  Participates in strategic and operational planning as it pertains to the development of Software / Cloud applications for digital media.    Leads other architects with minimal supervision and uses independent judgement frequently.  Responsible for architecting systems across a broad range of IT or Network...

  • Senior Digital Security Architect

    Found in: Jooble CA O C2 - 2 weeks ago

    Ottawa, ON, Canada nugget.ai Full time

    The lead security analyst is an advisor and subject matter expert representing technology with the responsibility of securing our applications and infrastructure. This is a key role shaping the strategy and implementation of technology projects and platforms across the Bank. You will provide expert security consultation to project, business, platform, and...

  • Data Engineer

    Found in: Talent CA C2 - 1 week ago

    Ottawa, Canada Tiger Analytics Full time

    Tiger Analytics is a fast-growing advanced analytics consulting firm. Our consultants bring deep expertise in Data Science, Machine Learning and AI. We are the trusted analytics partner for multiple Fortune 500 companies, enabling them to generate business value from data. Our business value and leadership has been recognized by various market research...

  • CRA - Cloud Security Architect L3 - 1 yr - 2023-01

    1 week ago

    Ottawa, Canada Dls Technology Corporation Full time

    CRA - Cloud Security Architect L3 - 1 yr - 2023-01 Applications Services Ottawa Contract Jan 12, 2024 Senior Cloud Security Architect – long term contract Senior Cloud Security Architect – long term contract Company: DLS Technology Corporation Office Location: Ottawa, Ontario Who You Are: We are looking for a...

  • CRA - Cloud Security Architect L3 - 1 yr - 2023-01

    1 week ago

    Ottawa, Canada Dls Technology Corporation Full time

    CRA - Cloud Security Architect L3 - 1 yr - 2023-01 Applications Services Ottawa Contract Jan 12, 2024 Senior Cloud Security Architect – long term contract Senior Cloud Security Architect – long term contract Company: DLS Technology Corporation Office Location: Ottawa, Ontario Who You Are: We are looking for a...

  • Architect - cloud USA Visa Sponsorship Jobs

    Found in: Talent CA C2 - 2 weeks ago

    Ottawa, Canada move2usajobs.com Inc Full time

    Job DescriptionSolution Architect with strong engagement experience who can provide Cloud initiative solutioning, leveraging best-in-class cloud-based technologies to replace legacy on-premises solutions to provide intelligent trend insights, actionable opportunities, decision support, and business-related activities Should be able to provide technology...

  • Architect - cloud USA Visa Sponsorship Jobs

    Found in: Talent CA C2 - 2 weeks ago

    Ottawa, Canada move2usajobs.com Inc Full time

    Solution Architect with strong engagement experience who can provide Cloud initiative solutioning, leveraging best-in-class cloud-based technologies to replace legacy on-premises solutions to provide intelligent trend insights, actionable opportunities, decision support, and business-related activities Should be able to provide technology evaluation and...

  • CRA - Cloud Security Architect L3 - 1 yr - 2023-01

    Found in: Jooble CA O C2 - 1 week ago

    Ottawa, ON, Canada Dls Technology Corporation Full time

    CRA - Cloud Security Architect L3 - 1 yr - 2023-01 Applications Services Ottawa Contract Jan 12, 2024 Senior Cloud Security Architect – long term contract Senior Cloud Security Architect – long term contract Company: DLS Technology Corporation Office Location: Ottawa, Ontario Who You Are: We are looking for a senior Cloud Security Architect...

  • Senior System Architect

    Found in: Talent CA C2 - 2 weeks ago

    Ottawa, Canada ADGA Group of Companies Full time

    Job Description ADGA Group Consultants is hiring a Senior System Architect to provide System Architecture guidance to Land Command Systems Program Management staff and coordinate System Architecture efforts of both the Canadian Deployable Mission Network (CDMN) and the Land C4ISR Support System (LCSS). Develop top level SoS System Views for the CDMN...

  • Application/Software Architect

    Found in: Jooble CA O C2 - 2 weeks ago

    Ottawa, ON, Canada NextPit GmbH Full time

    The IBM – Resource on Demand Team is seeking an Application / Software Architect Level 3 (L3) for a contract opportunity in the Ottawa area . This role is Remote Role description: As a L3 - Application / Software Architect your role could involve , but is not limited to: Analyze requirements and prepare appropriate specifications for the client. ...

  • Application Architect/Developers

    2 weeks ago

    Ottawa, Canada Lpsgcorp Full time

    Home | Job | Application Architect/Developers LP Services Group (LPSG Ottawa) has a requirement for One (1) Senior and One (1) Intermediate Application Architect/Developers with the Federal Government of Canada to provide Drupal expertise to assist in the decommissioning of current Corporate Website and implementation of Drupal WxT, including the...