Data Architect - Intermediate

ICBC (Insurance Corporation of British Columbia); North Vancouver; Hybrid; CAD 145,993,000 - 158,113,000; Full time

Job summary

ICBC is seeking an intermediate Data Architect for a temporary full-time role in North Vancouver. You will join the IM Data Management & Operations team to develop data and analytics solutions, collaborating with finance, actuarial, and audit to drive data-informed decisions.

You will lead a migration from on-prem MapR Hadoop to AWS big data technologies, shaping enterprise data standards and governance across the organization.

Qualifications

• Proficient SQL and analytical skills with large data sets.
• Experience with Python, Spark for data processing.
• Experience with cloud data platforms (AWS/Azure/Databricks/Snowflake).
• Knowledge of data governance, lineage and cataloging is a plus.
• Experience in Agile/Scrum development methodologies.
• Excellent verbal and written communication skills.

Responsibilities

• Design and maintain scalable data models using AWS services and Medallion Architecture.
• Implement Star/Snowflake schemas based on requirements for reporting.
• Develop fact and dimension tables and analytics-ready datasets.
• Lead data integration, governance, and data quality initiatives.
• Collaborate with stakeholders to deliver end-to-end data solutions from strategy to architecture.
• Create enterprise data architecture standards and data movement designs.
• Oversee data lineage, profiling and governance processes.

Skills

SQL

Python

Spark

Analytics

Agile/Scrum

Communication

Tools

AWS

Azure

Databricks

Snowflake

Tableau

Power BI

Job description

Reference Number: 5105

Posted Date: Sep 3, 2026

Employment Type: Temporary Full Time

Hours of Work: 7.5 hours per day - 5 day week (M-F)

Work Arrangement: Hybrid 8

Salary Range: $50.95 - $55.18 Hourly

Location: North Vancouver, British Columbia, Canada

We welcome applications from all qualified job seekers. Should you require any accommodations, including alternative interview formats, assistance with online assessments, or an ASL interpreter, throughout the application or hiring process, please email your request to [e-mail] – we are committed to ensuring an accessible experience for all candidates.

At ICBC, we strive to build diverse teams which reflect the communities we serve. To support this, we’ve created two talent communities for Indigenous Peoples and People with Disabilities. By joining one of these communities, you’ll connect with our recruitment team who will guide you through the application process and help you explore opportunities at ICBC.

The Data Architect Intermediate (Temporary Full Time) will join the IM Data Management & Operations team and focus on developing data and analytics solutions, working closely with business partners and stakeholders to meet their decision-support requirements.

This role will collaborate with the finance, actuarial and audit teams to support data analysis, enabling the business to make data-driven decisions. Additionally, the position requires deep technical expertise and leadership to drive complex data integration and optimization initiatives. This role will involve leading the migration from an on-premises MapR Hadoop to AWS big data technologies.

As a Data Architect Intermediate, You Will

• Design and maintain scalable data models using AWS services and Medallion Architecture.
• Design and implement Star or Snowflake schemas based on business requirements, data complexity, performance, and reporting needs.
• Develop and optimize fact tables, dimension tables, and analytics-ready reporting datasets to support dashboards and enterprise self-service analytics.
• Apply dimensional modeling best practices, including SCD Types 1,2, and 3, to support historical tracking and data governance.
• Leverage S3, Glue, Athena, and Redshift to architect reliable, scalable, and high-performance data solutions.
• Collaborate with data engineering, analytics, and business stakeholders to advise on end-to-end solutions from strategy to architecture.
• Create and communicate enterprise data architecture standards, best practices, and data movement/mapping designs.
• Establish and participate in data management processes including data lineage, profiling, data quality management, stewardship and governance.

Position Requirements

• Several years’ experience in data architecture or data engineering.
• Understanding of traditional and modern data ingestion, data storage, data processing and data access processes
• Strong SQL and analytical skills, with experience managing large, complex datasets using tools such as Python, Spark, and SQL.
• Experience with cloud data management technologies, such as AWS, Azure, Databricks, or Snowflake.
• Knowledge of data governance, lineage, cataloging, and compliance frameworks
• Build architecture diagrams, reference architectures, and implementation roadmaps
• Experience with Agile/Scrum development methodologies
• Excellent verbal and written communication skills
• You are known for being a team player, and your excellent analytical and critical thinking skills are complemented by strong communication and interpersonal abilities.

Preferred Additional Skills

• Experience evaluating how partitioning strategies, file sizing, and columnar formats like Parquet impact query performance and compute costs.
• Experience in data catalog architecture, with a deep understanding of how schema evolution impacts downstream systems.
• Experience understanding how specific design choices (grain, join patterns, and partition cardinality) translate into real-world compute costs and job reliability.
• Experience with reporting solutions like Tableau, Microsoft Power BI or similar visualization tools.

About Us

At ICBC, it’s our job to make sure the car insurance system works for all British Columbians, today and in the future. Check out our ICBC Year in Review 2025 to learn more about what we've accomplished! If you want to make the most of your skills and expertise while growing your career, we want you. A career at ICBC is an opportunity to be part of a talented, diverse and inclusive team that is driven to serve its customers and community. You can expect a competitive salary, comprehensive benefits and a collaborative work environment. If you are reliable and dependable, contact us today to be part of our talented and diverse team as we work together to create an insurance system we can all be proud of.

Our values guide how we interact with customers, partners, and each other. They shape our decisions and create a culture where employees feel inspired and empowered to do their best work.

• Collaborative: We include different perspectives to reach our common goals.
• Supportive: We seek to understand to meet diverse and evolving needs.
• Straightforward: We simplify the complex to make things easier.
• Knowledgeable: We gain knowledge through experience and learning to make informed decisions.

Work Arrangements Defined

• Hybrid 8 – you will work a minimum of 8 days in a 4-week period at your primary office headquarters (typically 2 days per week). The remaining days will be remote within British Columbia.

Only candidates legally entitled to work in Canada will be considered for this position.

Job Segment: Database, Developer, SQL, Technology