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

Data Architect: Client‑Facing Cloud Analytics Leader

LanternCalgary, AB, CA
Full-time

A technology solutions company in Canada is seeking an experienced Data Architect to join their team.This role will involve designing and implementing solutions that drive business insights for cli...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

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

Lead Data Implementation Engineer

ODAIACalgary, AB, CA
Permanent

Lead Data Implementation Engineer.ODAIAns (what we call ourselves) are inspired to reinvent how the industry leverages data.We are passionate about solving complex commercial problems with human‑ce...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

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

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

Senior Python PySpark Data Engineer – Databricks

Compunnel, Inc.Calgary, AB, CA
Full-time

A tech solutions company is looking for an experienced Python/PySpark Developer to design and optimize data-driven applications.This role involves developing applications, utilizing Databricks, and...Show more

 • Promoted

Data Test Engineer with ETL and Business Intelligence Expertise

AffinityCalgary, AB, CA
Full-time

Ensure the highest data quality as a Data Test Engineer focused on ETL processes and Business Intelligence applications.Utilize automation and analytical skills while working remotely in this dynam...Show more

 • Promoted • New!

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