Analytics Consultant

Clarity Recruitment; Oakville; Hybrid; CAD 85,000 - 121,000; Part time

Job summary

Clarity Recruitment is seeking a hands-on data and systems consultant in Oakville, ON, to own the data platform and drive automated reporting across finance and operations. You will connect Odoo, PLC data and other sources into Snowflake, and build Power BI dashboards that reconcile to source data.

You will collaborate with external partners and internal stakeholders, translating requirements into designs, leading the build, testing and rollout, and identifying automation opportunities to reduce

Qualifications

• Hands-on experience owning a cloud data warehouse, pipelines and validation.
• Strong SQL and Power BI capabilities with data modelling experience.
• Experience integrating ERP data sources (e.g., Odoo, NetSuite, SAP) into a data layer.

Responsibilities

• Own end-to-end data flow from source systems into the warehouse and Snowflake.
• Build Power BI reports and Odoo dashboards aligned to source data.
• Lead requirements, design, build, testing and user acceptance with partners.
• Collaborate with finance and operations to drive automation and adoption.

Skills

SQL

Power BI

Data modelling

Stakeholder comms

Cloud data warehouse

Tools

Snowflake

Odoo

Power BI

Excel

Job description

Employment Type: Contract (ongoing, with potential to convert to permanent)

Location: Oakville, ON (Hybrid, 2 to 3 days on-site)

Rate: $75/hr

Industry: Manufacturing (Advanced Materials)

Position Type: New Role

About the Opportunity

Our 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 Responsibilities

Data Platform and Integration

• Own the end-to-end flow of data from Odoo, plant equipment (PLCs) and other sources into Snowflake
• Monitor and troubleshoot daily loads and pipelines; investigate and resolve discrepancies between source systems and the warehouse
• Coordinate the Snowflake integration partner and the Odoo implementation partner, translating business requirements into designs and testing what they deliver
• Learn the existing architecture quickly from partner documentation and become the internal point of knowledge for how the pieces fit together

Business Process and Reporting

• Sit with department leaders to map their processes and data, then systemize that data in Odoo so it can flow into Snowflake
• Build Power BI reports and Odoo dashboards that reconcile to source, including interim solutions for Excel-based workflows while the fully integrated version is built
• Lead system initiatives through requirements, design, build, testing and user acceptance, and drive adoption with end users
• Connect new systems and Odoo apps, such as maintenance, into Snowflake

AI and Automation

• Structure validated Snowflake data so AI agents can use it accurately and cost-effectively
• Identify and deliver automation opportunities that reduce manual effort across functions
• Present findings and outputs to executive and functional stakeholders

What You Bring

• Hands‑on experience owning a cloud data warehouse, ideally Snowflake, including pipelines, data models, validation and failure recovery
• Strong 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 One
• Proven track record taking a business process from discovery to automated, validated reporting
• Experience managing external integration or implementation partners
• Comfortable working at both levels: designing how data should flow, and building the spreadsheet or report yourself
• Clear communicator with finance, operations and technical audiences
• Available to work on-site in Oakville 2 to 3 days per week

Nice to Have

• Manufacturing, lab, quality or shop‑floor (PLC) data experience
• Direct Odoo experience
• Experience building AI agents or automated workflows on top of a data warehouse
• dbt, Python or Git
• Interest in converting to a permanent role

Next Steps

We 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.