Data Modeler

Kaizen Technologies; Toronto; On-site; CAD 90,000 - 140,000; Full time

Job summary

Kaizen Technologies seeks a Data Modeler to design and govern semantic and financial data models for an enterprise analytics platform. You will lead data architecture across Workday Financials, planning engines, AWS QuickSight, and downstream AI/LLM tools.

You will own end-to-end modeling for foundational setups, financial rollups, and variance reporting while establishing governance and reconciliation frameworks. Strong SQL/dbt skills and CI/CD discipline are required.

Qualifications

• 7+ years in data modeling and data warehousing with domain expertise in Corporate Finance, Accounting, or FP&A.
• Deep experience with SQL, dbt, dimensional modeling and modeling Workday Financials GL APIs and planning engines.
• Proven ability to model for AWS QuickSight and structure metadata for enterprise AI/LLM ingestion.
• Experience in audited environments with strict release management, access logging and reconciliation.

Responsibilities

• Design and govern semantic layer and core financial data models.
• Lead data architecture across Workday Financials, planning engines, AWS QuickSight, and AI/LLM tools.
• Build end-to-end modeling for foundational setups, financial rollups, and variance reporting.
• Enforce governance, reconciliation frameworks, and data dictionary standards.

Skills

Advanced SQL

dbt

Dimensional modeling

Workday Financials GL APIs

Planning engines

AWS QuickSight

AI/LLM data ingestion

Release management

Access logging

Trial-balance reconciliation

Tools

Python

Robot Framework

CI/CD tooling

Job description

We are seeking a Data Modeler to design and govern the semantic layer and core financial data models for our enterprise analytics platform.

This role involves leading data architecture across Workday Financials, planning engines, AWS QuickSight, and downstream AI/LLM tools.

The ideal candidate will own end-to-end modeling for foundational setups, financial rollups, and variance reporting while establishing strict governance and reconciliation frameworks.

Responsibilities:

Enforce semantic standards including naming conventions, keys, sign conventions, currency, and identity mastering. Maintain an enterprise data dictionary structured for AI/LLM readiness (Gemini Enterprise/MCP).Architect high-frequency, version-aware data models for Workday GL and planning data, enabling sub-15-minute refreshes.

Write transformation logic using dbt with strict CI/CD, access logging, and optimization for AWS QuickSight and Google Sheets integration.

Implement data structures supporting daily zero-tolerance trial-balance reconciliations, break management, audit sign-offs, and Workday-aligned RBAC.Build data models for Management P&L and Plan vs. Actuals, ensuring accurate financial reporting.

Mandatory Skills:

7+ years in data modeling and data warehousing with deep domain expertise in Corporate Finance, Accounting, or FP&A.Advanced SQL, dbt, dimensional modeling, and experience modeling Workday Financials GL APIs and planning engines. Hands-on experience modeling for AWS Quick Sight and structuring metadata for enterprise AI/LLM ingestion. Proven track record in audited environments with strict release management, access logging, and trial-balance reconciliation.

Preferred Skills:

Expertise in Python and Robot Framework. Regular experience with CI/CD processes.

Qualifications:

Proven experience in data modeling with a focus on financial data.

Strong analytical and problem-solving skills. Excellent communication and collaboration abilities.