Manager Data Architecture
About The Position
Optiom is a Canadian specialty insurance Managing General Agency (MGA), backed by Aviva Canada, delivering vehicle protection through a national network of dealers and brokers. We're investing in a modern, governed data platform — one where our customers and partners are understood in one place, and every policy, claim, call and service event connects back to them. We're looking for a hands-on Manager, Data Architecture to lead our data analytics and data management functions and build that foundation with us. Reporting to the Director, Execution Office, you'll own the data model, the governed cloud data platform, and the analytics and reporting the whole business relies on — across all three of our brands. This is a build-and-scale role for someone who wants to shape a data function from the model outward: establish the governance and quality that make the numbers reconcile, and turn a fragmented data landscape into a single, trusted source of truth.
Requirements
- 6+ years in data architecture, data engineering, or analytics leadership, including hands-on data modelling (dimensional and semantic) — not solely dashboard production.
- Ownership of a modern cloud data platform (Snowflake strongly preferred; Azure or AWS equivalents considered) and current ELT / transformation practices.
- Proven delivery of enterprise business intelligence (Power BI preferred) to senior leadership.
- Experience establishing data governance, MDM and data quality controls in a regulated environment.
- Strong SQL; Python an asset.
- Bachelor's degree in Computer Science, Data / Information Management, Engineering, Statistics or a related field — or equivalent demonstrable experience.
- A clear communicator who can translate between technical and business audiences.
Nice To Haves
- Insurance, financial services, MGA, warranty or premium-financing data experience.
- Snowflake with dbt, Microsoft Fabric, or Azure Data Services.
- Certifications such as DP-600, PL-300, SnowPro, CDMP (DAMA) or TOGAF.
- Familiarity with API-gateway integration, canonical data contracts, and contact-centre data (e.g., Amazon Connect).
- Privacy and AML data-handling exposure (PIPEDA, FINTRAC).
Responsibilities
- Design and maintain our target data architecture — a governed cloud data platform (Snowflake) and curated data products such as Customer 360 and Partner 360.
- Lead the data management function — master data management, data quality, governance, lineage and retention — so the numbers leadership reviews agree across sales, claims, finance and service.
- Lead the analytics and BI function — deliver trusted, self-serve Power BI reporting for Sales, Claims, Operations, Finance and Service.
- Define the data models and integration patterns that connect our core insurance, CRM and contact-centre systems through consistent, governed data contracts.
- Partner across the business to translate questions into governed data products, and enable forecasting, retention analytics and AI-ready data.
- Provide technical leadership and mentorship, and build internal data capability.
Benefits
- Comprehensive group benefits — medical, dental, vision, and EAP
- Three weeks' vacation to start, increasing with tenure
- Employer-supported professional development and certifications
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Manager
