19 Nov
|
Clarity Recruitment
|
Oakville
19 Nov
Clarity Recruitment
Oakville
Employment Type: Contract (ongoing, with potential to convert to permanent)Location: Oakville, ON (Hybrid, 2 to 3 days in office)Rate: $75/hrIndustry: Manufacturing (Advanced Materials)Position Type: New RoleAbout the OpportunityOur client is a growing, private equity-backed advanced materials manufacturer in Oakville, producing specialty materials for the semiconductor, aerospace and energy storage supply chains. Over the past year, they have replaced spreadsheet-driven processes with a modern data stack: Odoo as the ERP and system of record, Snowflake as the data warehouse, Power BI for reporting, and an AI agent platform that sits on top of validated data.That model is already live in the quality and lab function, where complex lab and production data was migrated into Odoo, validated through Snowflake and turned into automated reporting. The next phase extends the same approach across the business, starting with finance and operations, inside a newly formed Enterprise Systems and Analytics function.Reporting directly to the CFO, you will connect the systems, the external integration partners and the business users. You will take a department's processes from first interview to automated, validated reporting, and build the reports yourself along the way. This is a strong fit for a hands‐on data and systems consultant who wants a real sandbox: a lean organization, a clean architecture already in place, executive sponsorship, and room to shape how a manufacturer uses data and AI.Key ResponsibilitiesData Platform and IntegrationOwn the end-to-end flow of data from Odoo,
plant equipment (PLCs) and other sources into SnowflakeMonitor and troubleshoot daily loads and pipelines; investigate and resolvediscrepancies between source systems and the warehouseCoordinate the Snowflake integration partner and the Odoo implementation partner, translating business requirements into designs and testing what they deliverLearn the existing architecture quickly from partner documentation and become the internal point of knowledge for how the pieces fit togetherBusiness Process and ReportingSit with department leaders to map their processes and data, then systemize that data in Odoo so it can flow into SnowflakeBuild Power BI reports and Odoo dashboards that reconcile to source, including interim solutions for Excel-based workflows while the fully integrated version is builtLead system initiatives through requirements, design, build, testing and user acceptance, and drive adoption with end usersConnect new systems and Odoo apps, such as maintenance,
into SnowflakeAI and AutomationStructure validated Snowflake data so AI agents can use it accurately and cost-effectivelyIdentify and deliver automation opportunities that reduce manual effort across functionsPresent findings and outputs to executive and functional stakeholdersWhat You BringHands‐on experience owning a cloud data warehouse, ideally Snowflake, including pipelines, data models, validation and failure recoveryStrong SQL and Power BI skills (Power Query, DAX, semantic modelling)Experience extracting and modelling data from a mid-market ERP such as Odoo, NetSuite, Dynamics or SAP Business OneProven track record taking a business process from discovery to automated, validated reportingExperience managing external integration or implementation partnersComfortable working at both levels: designing how data should flow, and building the spreadsheet or report yourselfClear communicator with finance, operations and technical audiencesAvailable to work on-site in Oakville 2 to 3 days per weekNice to HaveManufacturing, lab, quality or shop‐floor (PLC) data experienceDirect Odoo experienceExperience building AI agents or automated workflows on top of a data warehousedbt, Python or GitInterest in converting to a permanent roleNext StepsWe do appreciate all interest; however, only those selected for an interview will be contacted. Clarity Recruitment is an equal opportunity employer committed to fostering an inclusive and accessible recruitment process and workplace. If you require accommodation, please let us know in advance and we will work with you to meet your needs.Please note: We use AI‐assisted tools for notetaking during the screening process.
📌 Analytics Consultant (Oakville)
🏢 Clarity Recruitment
📍 Oakville