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

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 Data • Calgary

Similar jobs

Data Engineer : Azure Pipelines & Hybrid Cloud

Squadric • Calgary

Full-time

A leading technology firm is seeking an Intermediate Data Engineer in Calgary, Alberta.This role provides an opportunity to design and maintain robust data pipelines across hybrid environments, col...Show more

Last updated: 10 days ago • Promoted

Senior Data Engineer, Integrations

Themis Solutions Inc. • Calgary, Toronto, Vancouver

Full-time

This role is for someone who is passionate about building innovative data solutions and being exposed to new challenges and technologies while making an impact. This role is available to candidates ...Show more

Last updated: 30+ days ago • Promoted

ETL Developer - DataStage, PL / SQL, Shell Scripting

Astra North Infoteck Inc. • Calgary, AB, ca

Full-time

Quick Apply

ETL tools (DataStage preferred).Control-M, StoneBranch, or similar to manage batch processes.Monitor ETL jobs, perform root-cause analysis, and resolve production issues. Collaborate with business a...Show more

Last updated: 17 hours ago • New!

Lead Data analyst

ADDSOURCE • Calgary

Full-time

Hybrid Onsite Calgary, Canada (3-4 days onsite expected) – Only local profiles.As part of a team focused on rationalizing different legacy hardware asset and configuration management solutions into...Show more

Last updated: 10 days ago • Promoted

SAP S / 4HANA Data Replication Framework (DRF) Consultant

freelance.ca • Calgary, Canada

Full-time

Our client is looking for an SAP S4HANA Data Replication Framework (DRF) Consultant.Duration : 6 months with possibility of extension. If DRF works for them they intend to use it for their entire S / 4...Show more

Last updated: 30+ days ago • Promoted

Lead Data Engineer

Sage Recruiting • Calgary, AB, Canada

Full-time

Our client is a well-established energy analytics company that has achieved product-market fit and is now in a growth phase. They are a data-first organization.Data is not a support function here; i...Show more

Last updated: 21 days ago • Promoted

Senior Data & Analytics Engineer

Wagepoint • Calgary

Full-time

Senior Data & Analytics Engineer.Job function : Information Technology.Industry : Software Development.At Wagepoint, we’re good people. But that’s only because Wagepointers bring the best versions of ...Show more

Last updated: 10 days ago • Promoted

Thermal Data Integration Engineer

Canadian Natural Resources Limited (CNRL) • Calgary

Full-time

At Canadian Natural, we are proud to be a leader in Canada’s energy industry.Join us and help drive innovation and long-term value through integrity, teamwork, and a passion for doing things right....Show more

Last updated: 10 days ago • Promoted

Data Platform Engineer – Cloud Pipelines (12m Contract)

ARC Resources Ltd. • Calgary

Full-time +1

A leading Canadian energy company is seeking a Data Platform Developer for a 12-month contract in Calgary.The ideal candidate will have a strong technical foundation in data engineering and will be...Show more

Last updated: 30+ days ago • Promoted

Tech Lead - Power BI Data Engineer : Drive Insights

Infosys • Calgary

Full-time

A leading IT consulting firm is seeking a Technology Lead - Senior Power BI, Data Engineer in Calgary, Alberta.This role involves building and optimizing Power BI dashboards, creating data models, ...Show more

Last updated: 11 days ago • Promoted

Data Analyst

InSync Systems • airdrie, ab, ca

Temporary

Must be legally entitled to work in Canada.This position is 100% onsite in downtown Calgary.The ideal candidate will focus on using data and automation to solve business problems and improve effici...Show more

Last updated: 2 hours ago • Promoted • New!

Business Data Analyst / Data Engineer (Guidewire)

Quality IT Resourcing • Calgary, Alberta, Canada

Full-time

Data Business Analyst – Senior Consultant.Duration : 12 months (Contract).We are seeking a Senior Data Business Analyst / Data Engineer with strong experience in regulatory reporting, Guidewire, and ...Show more

Last updated: 4 hours ago • Promoted • New!

Senior Data Engineer, Integrations - Data Pipelines Hybrid

Clio • Calgary

Full-time

A leading legal technology company is seeking a Senior Data Engineer to join its growing team in Calgary.The role involves implementing data ingestion techniques, designing data pipelines, and coll...Show more

Last updated: 10 days ago • Promoted

2 - Senior Data Engineer

Targeted Talent • Calgary, AB, Canada

Permanent

We are looking for an experienced.This is a permanent position that is remote to start with later relocation to.Our client is a global enterprise company with a product that you've likely used....Show more

Last updated: 30+ days ago • Promoted

Lead Data Analyst - Data Platform Migration & Analytics

Saransh Inc • Calgary

Full-time

A technology consulting firm is looking for a Lead Data Analyst to migrate data from legacy systems to a strategic platform using ServiceNow. The role requires strong experience with SQL and Python,...Show more

Last updated: 11 days ago • Promoted

Senior Power BI Developer — Data Modernization & Insights

Long View Systems • Calgary

Full-time

A leading IT services company in Canada is seeking a mid-senior level Power BI Developer to be part of their Data Modernization team. The role involves working with clients to design and implement d...Show more

Last updated: 10 days ago • Promoted

Data Scientist

Yochana • calgary, ab, ca

Full-time

Python, ML frameworks, Azure Machine Learning, MS Fabric, Power BI.Able to define, build and refine predictive ML Models,. Experience with MS Fabric and Azure Data services.An applied data scientist...Show more

Last updated: 2 days ago • Promoted

UT / UTCD Data Analyst [Level 3] - Calgary, Canada

Pipecare Group • Calgary, AB, Canada

Full-time

UT / UTCD Data Analyst [Level 3].By providing technology and service focused solutions to the international arena of the oil and gas industry, the PipeCare Group of companies has been helping our cus...Show more

Last updated: 30+ days ago • Promoted