
Data Engineering Advisor
Posted 3 days ago

Posted 3 days ago
This is a fully remote position, open to applicants in Canada.
• 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.
• 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.
• 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.
Trax Technologies
Fiserv
Ontrac Solutions
General Dynamics Information Technology
Get handpicked remote jobs straight to your inbox weekly.