
Data Engineering Consultant
Posted 3 days ago

Posted 3 days ago
This is a fully remote position, open to applicants in Canada.
• Establish the target data model for the unified Finance and Procurement areas.
• Design the framework for master data repositories and the business rules for Master Data Management (MDM).
• Outline data flows and lineage between source systems, Oracle Fusion, and analytics platforms.
• Define the lifecycle of consolidated data, including its creation, updates, retention, and archiving procedures.
• Set modeling and naming conventions for the project's data structures.
• Assist in conversion and matching workstreams by implementing the target model.
• Prepare the data section of architecture documents for submission to review and approval committees.
• Evaluate the data governance and architectural elements during the architecture review process.
• Proven experience in developing and operationalizing data flows within an implementation or integration project that involves Oracle Fusion Cloud Financials or another ERP system.
• Familiarity with Finance and Procurement processes, such as general ledger, accounts payable, accounts receivable, fixed assets, purchasing, and inventory management.
• Experience in creating integration flows between an ERP system and source systems, which includes implementing source-to-target mappings, integrating master data repositories, and reconciling data.
• Background in data conversion and historical data migration, including data quality controls and maintaining identifiers required for cross-system reconciliation.
• Experience in technical collaboration with ERP vendors, integration teams, and business stakeholders to test data flows and resolve issues.
• Skill in developing and automating ERP data extractions to a data lake, covering both initial and incremental loads, metadata management, quality controls, logging, and process recovery.
• Advanced expertise in the Microsoft Fabric platform (Lakehouse, Data Warehouse, Direct Lake, Pipelines, and Notebooks), hands-on experience with managing Fabric workspaces and Spark environments, and proficiency in Fabric development environments, particularly using Notebooks for ingestion, transformation, exploratory analysis, and analytical solution prototyping.
• Successfully completed at least three Microsoft Applied Skills assessments relevant to Fabric or possess the Microsoft Fabric Data Engineer Associate certification (DP-700).
• Bachelor’s degree in Computer Science, Software Engineering, or a related field; MIFI equivalency is necessary for degrees obtained outside Quebec.
• A minimum of 8 years of experience in data architecture or data modeling.
• Competence in conceptual, logical, and physical data modeling techniques and experience with a modeling tool.
• Familiarity with Master Data Management (MDM) repositories and multi-source consolidation environments.
• Only candidates legally authorized to work for any employer in Canada will be considered.
• At least 3 weeks of vacation beginning in the first year.
• Comprehensive group insurance with a substantial employer contribution.
• Employer contribution to a group RRSP.
• Full remote work flexibility: Hybrid, Remote, or On-site.
• A friendly, bright, and inviting office that offers fresh fruit, coffee, beverages, and occasional meals.
• Annual IT equipment budget.
• A balanced work environment with flexible working hours.
• Opportunities for career development, including training and certifications, online or in-person learning, and Wepoint Academy.
• An international community of experts eager to share their knowledge.
• A company culture that prioritizes individual needs and fosters a strong sense of community.
Trax Technologies
Fiserv
Ontrac Solutions
General Dynamics Information Technology
Get handpicked remote jobs straight to your inbox weekly.