Enterprise Data Lake & Financial Reporting Transfo

Venteon

Sherbrooke (Qu bec), MI

JOB DETAILS
LOCATION
Sherbrooke (Qu bec), MI
POSTED
30+ days ago

Project Overview:
The initiative focuses on consolidating data from Plex ERP and various external sources into a unified Data Lake architecture. This will enable the organization to move away from fragmented, manual processes and establish a single source of truth for finance and operations.

A primary focus will be improving financial data processes, including customer payment and invoice reconciliation, while also enabling broader use cases such as forecasting, cost analysis, and operational reporting.

Scope of Work:

  • Design and implementation of a Microsoft Fabric Data Lake (Lakehouse architecture)
  • Integration of Plex ERP data (customers, invoices, payments, production, costing, etc.)
  • Consolidation of data across multiple PCNs and business units
  • Integration of external data sources including bank data, remittance files, Excel inputs, and other systems
  • Development of scalable data pipelines (ETL/ELT) using Fabric and Azure-based tools
  • Implementation of Medallion architecture (Bronze, Silver, Gold layers) for data standardization and performance optimization
  • Design of data models to support financial and operational reporting
  • Enablement of reporting through Power BI, including support for finance-driven use cases (reconciliation, visibility, analysis)
  • Establishment of data governance, quality controls, and monitoring processes
  • Documentation of architecture, data models, and pipelines to support long-term scalability

Key Objectives:

  • Establish a centralized, reliable source of truth across Plex and non-Plex data
  • Improve data accuracy and eliminate manual consolidation and reconciliation processes
  • Increase visibility across plants, PCNs, and financial operations
  • Enable faster, more reliable reporting and decision-making
  • Empower internal users to leverage the data platform for ongoing analytics and reporting

Environment:

  • Plex ERP (multi-PCN, manufacturing environment)
  • Microsoft Fabric (Lakehouse, Data Factory, Notebooks, Power BI)
  • Azure ecosystem (Data Factory, storage, integration services)
  • External data sources (banking data, remittance files, Excel, third-party systems)

Ideal Experience:

  • Strong experience with Microsoft Fabric / Azure Data Lake / Synapse
  • Experience integrating ERP systems (Plex strongly preferred)
  • Background in building scalable data pipelines and data models
  • Exposure to financial data (AR, GL, reconciliation, costing)
  • Experience in manufacturing or automotive environments

About the Company

V

Venteon

At Venteon, we are experts in providing Executive Search and Staffing services in Accounting & Finance, Engineering, Technology, Sales & Marketing and Advertising with the following options:

Direct Placement / Executive Search

Contract

Contract-to-Direct

Project Based Solutions

We Deliver the Right Solutions:

Our recruiters are experienced in finding the right candidates for your position. Through active recruiting within our vast network (both locally and nationally), we source qualified candidates that have the exact experience necessary to make an immediate impact.

Our goal is to make the right placement the first time. We spend a great deal of time matching the right candidate with the right opportunity. Once a placement is made, we implement an ongoing quality control program to ensure the satisfaction of both parties. We believe that being proactive in this process enables us to provide a high level of success in our placement process.

We Build Long-Term Partnerships:

Our professional staff will learn about your business, culture, and work environment in order to understand the requirements and skills needed for your open position. We then tailor our search to these specific requirements and efficiently address your critical hiring needs. Our dedication to nurturing long-term, trust-based relationships with both clients and candidates is the reason for our success.

COMPANY SIZE
100 to 499 employees
INDUSTRY
Accounting and Auditing Services
WEBSITE
http://www.venteon.us.com/