Salary Range: $50.95 - $55.18 Hourly 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 [email protected] ICBC, we strive to build diverse teams which reflect the communities we serve. To support this, we’ve created two talent communities forIndigenous Peoples andPeople 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.

Of course, you’re welcome to apply for jobs at ICBC whether or not you join a talent community.

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.

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. 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 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 with reporting solutions like Tableau, Microsoft Power BI or similar visualization tools. At ICBC, it’s our job to make sure the car insurance system works for all British Columbians, today and in the future. 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 perks and a collaborative work environment. Our values guide how we interact with customers, partners, and each other. 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.

📌 Data Architect- Remote Contract (Vancouver)
🏢 ICBC
📍 Vancouver