Talent.com
Data Modeler - Design and optimize ETL (Extract,Transform, Load) pipelines for scalable, high-performance data processing in Azure Databrick - 27313
Data Modeler - Design and optimize ETL (Extract,Transform, Load) pipelines for scalable, high-performance data processing in Azure Databrick - 27313S.i. Systems • Calgary
Data Modeler - Design and optimize ETL (Extract,Transform, Load) pipelines for scalable, high-performance data processing in Azure Databrick - 27313

Data Modeler - Design and optimize ETL (Extract,Transform, Load) pipelines for scalable, high-performance data processing in Azure Databrick - 27313

S.i. Systems • Calgary
30+ days ago
Job type
  • Full-time
Job description

Data Modeler

1 year

Hybrid - 3 days

SCM Enable & Innovate is seeking a Data Modeler II with a product-driven, start-up mindset to manage end-to-end development of innovative solutions that deliver measurable business value for Supply Chain.

Product Development

• Develop innovative data science solutions leveraging deep knowledge of oil & gas industry and Supply Chain processes and value drivers.

• Design and optimize ETL (Extract ,Transform, Load) pipelines for scalable, high-performance data processing in Azure Databricks, Microsoft Dataflow and Dataverse and/or Oracle Autonomous Data Warehouse (ADW).

• Utilize various ERP systems, including SAP and Oracle and their analytics tools to support product development and data-driven decision.

• Integrate solutions with enterprise data platforms and visualization tools for reporting.

• Develop master datasets to support procurement, spend, and market intelligence analytics

• Ensure data governance and compliance with company policies across development on Company systems.

Program Management

• Define and document project objectives, problem statement, business value, processes and requirements.

• Oversee project timelines, resources, and cross-functional team coordination, ensuring alignment with project goals.

• Facilitate project meetings and share progress updates to stakeholders.

• Maintain documentations, including idea assessments, requirements, design documents, and weekly status reports.

• Articulate technical knowledge, requirements, design and product details to internal business stakeholders in clear and plain language.

Must Haves:

• Experience: 5–7 years of relevant SCM or product development experience.

o Advanced proficiency in data science, including statistical analysis, predictive analysis, text-based sentiment analysis, machine learning, and data visualization.

o Advanced proficiency in analyzing unstructured data such as PO line descriptions, customer feedbacks to extract insights

o Advanced proficiency in Python and PySpark in conjunction with Databricks for large-scale data processing.

o Hands-on knowledge with prompt engineering

o Hands-on experience in developing solutions using Microsoft Power Platform (Copilot Studio, Dataflow, Dataverse, Power Automate, and Model-driven Apps) for workflow automation and low-code development.

o In-depth knowledge of SAP and Oracle Cloud (SCM, A/P, Projects, Finance).

o Proficiency in SQL for data transformation is an asset.

o Experience with Alteryx for data preparation and workflow automation is an asset

• Industry Knowledge: Oil and gas sector, SCM Procure-to-Pay / Source-to-Pay processes and value drivers.

• Project Management: Skilled in agile/waterfall methodologies, stakeholder engagement, Project documentation (Power Point, Excel, Visio, etc)

• Education: Bachelor’s degree in Commerce (SCM), Data Science, Engineering, or related field.



Create a job alert for this search

Data Modeler - Design and optimize ETL (Extract,Transform, Load) pipelines for scalable, high-performance data processing in Azure Databrick - 27313 • Calgary

Similar jobs

Remote Senior Data Engineer - Cloud Data & ML Pipelines

Clario Holdings Inc.Calgary, AB, CA
Remote
Full-time

A leading data solutions provider in Canada is seeking a Senior Data Engineer to design and build cloud-native data infrastructures.This role involves developing scalable ETL/ELT pipelines, optimiz...Show more

 • Promoted

Lead Data Modeling Manager for Core Metrics and Foundations

MuralCalgary, AB, CA
Full-time

Transform core data models into robust, reusable assets as a Data Modeling Manager.Focus on enhancing data quality, reliability, and availability while driving analytics and AI/ML initiatives.In th...Show more

 • Promoted

Senior Data Integration & ETL Engineer (Remote)

ODAIA Intelligence Inc.Calgary, AB, CA
Remote
Full-time

A leading AI commercial intelligence provider is seeking a Senior Data Implementation Engineer in Canada.This pivotal role involves overseeing complex customer implementations, building automated E...Show more

 • Promoted

Senior Power Bi Lead: Enterprise Analytics & Data Modeling

Data ElephantCalgary, Canada
Full-time

A dynamic data solutions company in Canada is seeking a Senior Power BI Lead to provide technical leadership and mentoring to a team of developers.You will be responsible for guiding best practices...Show more

 • Promoted • New!

Lead Data Engineer - Medallion Architecture (Remote)

CorityCalgary, AB, CA
Remote
Full-time

A leading EHS+ solutions provider in Canada is seeking a Senior Analytics Engineer to own their data platform end-to-end.Responsibilities include leading the architecture of the Medallion data arch...Show more

 • Promoted

Data-Driven BI Engineer Focused on Advanced Analytics Solutions

NDT GlobalCalgary
Full-time

Elevate infrastructure management as a skilled BI Engineer.Develop database systems, generate insightful reports, and engage with stakeholders to transform data into actionable insights in a remote...Show more

 • Promoted

Data Platform Manager

Harnhamcalgary, AB, ca
Full-time

We are seeking a Data Platform Manager to oversee Data Modelling and Architecture.This person will inherit and existing team and continue to scale!Location: Canada (remote)Compensation: Up to 200KT...Show more

 • Promoted

Data Migration Engineer I: ETL, Python & SQL

SpryPointCalgary, AB, CA
Full-time

A leading software company in North America seeks a Data Conversion Engineer I to support data migration efforts for utility clients.The role includes managing ETL processes, developing Python and ...Show more

 • Promoted

Expert Data Pipeline Engineer with SQL and Visualization Skills

MercorCalgary, AB, CA
Full-time

Elevate data engineering as a Data Pipeline Engineer in a remote setup.Enjoy driving SQL-based data transformations and creating insightful dashboards to enhance data quality and platform performan...Show more

 • Promoted

Lead Data Engineer for Microsoft Fabric Implementation and Strategy

Info-Tech Research GroupCalgary, AB, CA
Full-time

Shape the future of data as a Senior Data Engineer.Drive the implementation of Microsoft Fabric, setting up pipelines and creating a unified data architecture for optimal analytics.This position in...Show more

 • Promoted

Sr Data Engineer(Abinitio Specialist)

Ampstekcalgary, ab, ca
Full-time

Role: Sr Data Engineer(Abinitio Specialist).Expertise as an Ab Initio Technical Expert.Strong problem-solving skills: Able to analyze issues, identify root causes, and implement timely, effective s...Show more

 • Promoted

Remote Data Engineer: ETL, Data Modeling & Governance

RAZORCalgary, AB, CA
Remote
Full-time

A leading technology firm is seeking a Data Engineer to develop scalable ETL/ELT pipelines and build data models for quality reporting.The ideal candidate will have over 3 years of experience in da...Show more

 • Promoted

Data Engineer – Remote-First ELT Pipelines & ML APIs

BorrowellCalgary, AB, CA
Remote
Full-time

A financial technology company in Toronto is seeking a Data Engineer to build and maintain data infrastructure.You will create ELT pipelines, design data models, and collaborate with teams to deliv...Show more

 • Promoted

Senior Data Engineer: Data Platform & ML Pipelines (Remote)

LaivlyCalgary, AB, CA
Remote
Full-time

A forward-thinking tech company in Winnipeg is seeking a Senior Data Engineer to design and build scalable data systems.The role requires 8-10 years in SQL environments and expertise in data integr...Show more

 • Promoted

Developer

Absorb SoftwareCalgary, AB, CA
Full-time

Absorb is seeking an intermediate-level Developer to take ownership of an internal ETL tool that supports billing, accounting, and operations.In this individual contributor role, you’ll help mainta...Show more

 • Promoted

Data Modeler

Tredence Inc.calgary, AB, ca
Full-time

We are looking for a detail-oriented Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support business processes and analytics.The ideal candidate wi...Show more

 • Promoted

IBM Planning& Analytics Data Modeler

Addmore GroupCalgary
Full-time

Our global client requires a IBM Planning & Analytics Data Modeler - TM1 to work on new development projects, and provide guidance and mentoring to support the solution for a Calgary based client.T...Show more

 • Promoted

Tech Lead - Azure Databricks Data Engineer

InfosysCalgary
Full-time

A leading global consulting firm is seeking a Technology Lead specializing in Azure Databricks and Data Engineering in Calgary, AB.The ideal candidate should have over 4 years of experience in IT, ...Show more