SAP BI Data Architect

2 weeks ago


Toronto, Ontario, Canada Spirit Omega Inc. Full time
Data Architect

Location :
Toronto, ON (100% Remote)
Contract Duration : 4 months

Language :
English

Lead the architecture, design, and oversee implementation of modular and scalable data ELT/ETL pipelines and data infrastructure leveraging the wide range of data sources across the organization.

Design curated common data models that offer an integrated, business-centric single source of truth for business intelligence, reporting, and downstream system use.

Work closely with infrastructure and cyber teams to ensure data is secure in transit and at rest.

Create, guide, and enforce code templates for delivery of data pipelines and transformations for structured, semi-structured and unstructured data sets.

Develop modeling guidelines that ensure model extensibility and reuse by employing industry standard disciplines for building facts, dimensions, bridge, aggregates, slowly changing dimensions, and other dimensional and fact optimizations.

Establish standards database system fields, including primary and natural key combinations that optimize join performance in a multi-domain, multiple subject area physical (structured zone) and semantic model (curated zone)

Ensure model extensibility by employing industry standard disciplines for building facts, dimensions, bridge, aggregates, slowly changing dimensions, and other dimensional and fact optimizations.

Transform data and map to more valuable and understandable semantic layer sets for consumption, transitioning from system centric language to business-centric language.

Collaborate with business analysts, data scientists, data engineers, data analysts and solution architects to develop data pipelines to feed our data marketplace.

Work with tools in the Microsoft Stack; Azure Data Factory, Azure Data Lake, Azure SQL Databases, Azure Data Warehouse, Azure Synapse Analytics Services, Azure Databricks, Microsoft Purview, and Power Bl

Work within the agile SCRUM work management framework in delivery of products and services, including contributing to feature & user story backlog item development, and utilizing related Kanban/SCRUM toolsets.

Design data solutions that enable batch, near-real-time, event-driven, and/or streaming approaches depending on business requirements

Design & advise on orchestration of data pipeline execution to ensure data products meet customer latency expectations, dependencies are managed, and datasets are as up to date as possible, with minimal disruption to end-customer use.

Ensure that designs are implemented with proper attention to data security, access management, and data cataloging requirements.
Approve pull requests related to production deployments.

Guide data modelers, business analysts and data scientists in the build of models optimized for KPI delivery, actionable feedback/writeback to operational systems and enhancing the predictability of machine learning models and experiments.

4 years year University education in computer science, software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.

~ Minimum experience of +6 years and up to and including 8 years of experience is required in data modeling, data warehouse design, and data solution architecture in a Big Data environment is considered necessary.
~ Experience guiding data lake ingestion and data modeling projects in a cloud environment, experience in modeling relational and in-memory models with star/snowflake schemas.
~ Experience with designing and implementing event-driven (pub/sub), near-real-time, or streaming data solutions, involving structured, semi-structured and unstructured data across various platforms.
~ Requires an extensive knowledge in designing a data model to solve a business problem, specifying a data pipeline design pattern to bring data into a data warehouse, optimizing data structures to achieve required performance, designing low-latency and/or event-driven patterns of data processing, creation of a common data model to support current and future business needs.

We welcome applications from anyone, including members of visible minorities, women, Indigenous peoples, persons with disabilities, persons of minority sexual orientations and gender identities, and others with the skills and knowledge to productively engage with diverse communities.

#
  • SAP BI Data Architect

    2 weeks ago


    Toronto, Ontario, Canada Kainos Group plc Full time

    When you join Kainos, you get to think beyond limitations to make an immediate and positive impact – like transforming digital services for millions of citizens or helping Fortune 500 companies get live and thrive on Workday. We're a creative, committed, and diverse group of individuals who succeed as a team. As a Data Architect (Manager) in Kainos,...


  • Toronto, Ontario, Canada CGI Full time

    SAP Cross Functional Enterprise ArchitectCGI is seeking a high-potential S/4HANA Cross Functional Enterprise Architect (Finance & Controlling & Supply Chain) with strong SAP experience to support SAP practice initiatives, pre-sales activities, client demos, RFP'S responses and to support Business Units on delivering S/4HANA migration projects.The successful...


  • Toronto, Ontario, Canada CGI Full time

    SAP Cross Functional Enterprise ArchitectCGI is seeking a high-potential S/4HANA Cross Functional Enterprise Architect (Finance & Controlling & Supply Chain) with strong SAP experience to support SAP practice initiatives, pre-sales activities, client demos, RFP'S responses and to support Business Units on delivering S/4HANA migration projects.The successful...


  • Toronto, Ontario, Canada CGI Full time

    SAP Cross Functional Enterprise ArchitectCGI is seeking a high-potential S/4HANA Cross Functional Enterprise Architect (Finance & Controlling & Supply Chain) with strong SAP experience to support SAP practice initiatives, pre-sales activities, client demos, RFP'S responses and to support Business Units on delivering S/4HANA migration projects.The successful...


  • Toronto, Ontario, Canada CGI Full time

    SAP Cross Functional Enterprise ArchitectCGI is seeking a high-potential S/4HANA Cross Functional Enterprise Architect (Finance & Controlling & Supply Chain) with strong SAP experience to support SAP practice initiatives, pre-sales activities, client demos, RFP'S responses and to support Business Units on delivering S/4HANA migration projects.The successful...


  • Toronto, Ontario, Canada CGI Full time

    SAP Cross Functional Enterprise ArchitectCGI is seeking a high-potential S/4HANA Cross Functional Enterprise Architect (Finance & Controlling & Supply Chain) with strong SAP experience to support SAP practice initiatives, pre-sales activities, client demos, RFP'S responses and to support Business Units on delivering S/4HANA migration projects.The successful...


  • Old Toronto, Ontario, Canada SAP SE Full time

    Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly collaborative, caring team...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run betterOur company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada SAP SE Full time $125,300 - $213,000

    Our company culture is focused on helping our employees enable innovation by building breakthroughs together. We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. The Senior Data Management (MDG) consultant is...

  • Data Architect

    2 weeks ago


    Toronto, Ontario, Canada Ward Technology Talent Full time

    Data Architect Contract | REMOTE / CANADA, ON | March 29, 2023 We need a Data Architect for a Contract Opportunity . The required skills are below. Must Have SkillsExpert data modeling for complex operational transactional solutions with more 100+ entitiesExpert dimensional data modeling for data warehouse or data lake solutions with 20+...

  • Senior SAP Architect

    2 weeks ago


    Old Toronto, Ontario, Canada Atlantis IT group Full time

    Senior SAP Architect - Senior SAP Architect Senior SAP ArchitectToronto, ONLong Term ContractResponsibilities:Development of solution architecture artifacts to address stakeholder concerns.Interface with the business community and provide ongoing status reports.Monitor compliance and related guidance (such as data retention and audit requirements) to...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company focuses on fostering innovation among employees by collaborating to create groundbreaking solutions. We are committed to building the groundwork for the future and cultivating a diverse, flexible, and purpose-driven work environment. What You'll Do: As the BTS Enterprise Architect, you will play a pivotal role in...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada SAP Full time

    We help the world run better Our company culture is focused on helping our employees enable innovation by building breakthroughs together. How? We focus every day on building the foundation for tomorrow and creating a workplace that embraces differences, values flexibility, and is aligned to our purpose-driven and future-focused work. We offer a highly...


  • Toronto, Ontario, Canada High Cliff Partners Inc. Full time

    Our client is seeking a talented and experienced SAP Solution Architect to join their project starting immediately and will run for 12 months initially with a probable extension. Any software industry experience will be a huge asset. This will be a remote work setting with only 20% of the time needed to be on-site.The ideal candidate will have broad...