Data Engineering Advisor

Posted 3 days ago

This is a fully remote position, open to applicants in Canada.

📋 Description

• Define the targeted data model for the integrated Finance and Procurement sectors.

• Design the framework for master data repositories, including suppliers, items, and accounts, as well as governance rules for Master Data Management (MDM).

• Map data flows and trace lineage between source systems, Oracle Fusion, and analytics platforms.

• Establish the lifecycle for consolidated data, encompassing creation, updates, retention, and archiving.

• Create modeling and naming conventions for the project’s data structures.

• Assist in data conversion and matching workstreams by applying the target model.

• Prepare the data aspects of architecture dossiers for submission to review and approval committees.

• Evaluate the data governance and architectural elements during the architecture assessment.

• Offer the structural foundation for conversions, interfaces, and data enrichment across the network.

• Generate data architecture deliverables that align with the Enterprise Architecture Framework (AEG) and present them to decision-making entities.


⛳️ Requirements

• Proven experience in developing and operationalizing data flows within an implementation or integration project involving Oracle Fusion Cloud Financials or another ERP system.

• Understanding of 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 and source systems, including 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 necessary for cross-system reconciliation.

• Experience in collaborating technically with the ERP vendor, integration teams, and business stakeholders to validate data flows and address issues.

• Expertise in developing and automating ERP data extracts to a data lake, including initial and incremental loads, metadata management, quality controls, logging, and process recovery.

• Advanced proficiency with the Microsoft Fabric platform (Lakehouse, Data Warehouse, Direct Lake, Pipelines, and Notebooks).

• Practical experience in managing Fabric workspaces and Spark environments.

• Proficient in Fabric development environments, with advanced usage of Notebooks for ingestion, transformation, exploratory analysis, and prototyping analytical solutions.

• Completion of at least three Microsoft Applied Skills assessments related to Fabric, or possession of the Microsoft Fabric Data Engineer Associate certification (DP-700).

• Bachelor’s degree in Computer Science, Software Engineering, or a related discipline.

• MIFI equivalency is necessary for any degree obtained outside of Quebec.

• A minimum of 8 years of experience in data architecture or data modeling.

• Expertise in conceptual, logical, and physical data modeling techniques and proficiency in using data modeling tools.

• Experience with Master Data Management (MDM) repositories and multi-source consolidation environments.

• Only candidates who are legally permitted to work for any employer in Canada will be considered.


🏝️ Benefits

• A minimum of 3 weeks of vacation starting from the first year.

• Comprehensive group insurance with a substantial employer contribution.

• Employer contributions to a group RRSP.

• Full flexibility for remote work: Hybrid, Remote, or On-site.

• A warm, bright, and welcoming office environment that provides fresh fruit, coffee, beverages, and occasional meals.

• An 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 individuals’ needs and fosters a sense of belonging within a strong community.

People also viewed

Trax Technologies9 hours ago

Data Architect

US flagUnited States OnlyFull-timeData Engineer
ApplyView job
Fiserv10 hours ago

Senior Snowflake Data Platform and Artificial Intelligence Architect

US flagUnited States OnlyFull-timeData Engineer
ApplyView job
Ontrac Solutions10 hours ago

Staff Data Engineer

US flagUnited States OnlyFreelanceData Engineer
ApplyView job
General Dynamics Information Technology10 hours ago

ICAM Identity Data Management Engineer – Radiant Logic

US flagUnited States OnlyFull-timeData Engineer$170k – $230k/year
ApplyView job
General Dynamics Information Technology10 hours ago

Identity Data Management Engineer – Radiant Logic

US flagUnited States OnlyFull-timeData Engineer$170k – $230k/year
ApplyView job
General Dynamics Information Technology10 hours ago

Senior Data Engineer

US flagUnited States OnlyFull-timeData Engineer$102k – $138k/year
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers