Sr. Data Engineering Architect for ERP Conversion as part of a master data management initiative

Job Type: Contract
Positions to fill: 1
Start Date: Jun 05, 2023
Job End Date: Nov 30, 2023
Pay Rate: Hourly: Negotiable
Job ID: 130041
Location: Calgary
Our Oil & Gas downtown Calgary client is seeking a Sr. Data Engineering Architect for ERP Conversion as part of a master data management initiative to start on contract ASAP for 6 months to start with strong possibility of extension.

  • 8+ years' experience within Master Data Management (MDM) with a Data engineering background
  • 3+ years' Data Transformation Logic experience for configuring logging/audit trails  (SQL/Python/Data Flows/Data Pipelines/etc.)
  • Financials and Supply Chain business knowledge
  • Working knowledge/ experience with CluedIn MDM
  • Azure experience for Data Factory and/or Synapse Pipelines
  • Purview experience for Azure Integration Services
  • Oil & Gas specific Financials and Supply Chain business knowledge
Responsibilities Overview:
  • Profile data structure from ERP conversion sources to understand entities, attributes, relationships – with a focus on data join criteria and normalization 
  • Configure inbound data pipelines to the MDM Platform for source data ingestion 
  • Map inbound data streams to MDM Platform Data Vocabularies for conversion outputs 
  • Formulate and implement data transformation, cleansing, enrichment, deduplication, and mapping rules from source to target – following established patterns defined by the Enterprise Architects 
  • Create data catalog Glossaries in MS Azure Purview based on inbound and outbound stream schemas, including scanning and/or maintaining critical metadata 
  • Configure MDM Platform streams to generate conversion data payloads for post-processing and loading - including Azure SQL tables for MDM Registry and Xref lookup 
  • Propose API definitions for approval by senior data and integration architects as needed to support MDM micro-services as required to enable Enterprise MDM Integration and Interaction models
Location: Must be willing to come into the office in Calgary 2 days/week. There is option for remote work currently, however this could change to 2 days at anytime.