Data Architect - Intermediate
Top Benefits
About the role
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 accessibility_services@icbc.com – 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. Of course, you’re welcome to apply for jobs at ICBC whether or not you join a talent community. We look forward to hearing from you! 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. #IND1
Not the right fit? Search for Data Architect jobs in North Vancouver, British Columbia, Canada
About ICBC (Insurance Corporation of British Columbia)
We're ICBC, your provincial Crown Corporation responsible for insurance, driver licensing and road safety. At ICBC, you'll have the opportunity to advance your career in a supportive environment, with benefits that support your health and wellness to help you thrive.
Why work with us? Competitive benefits to make the most of life in B.C. From health coverage to pensions, our benefits and perks provide peace of mind.
A collaborative work environment. We foster collaboration across all our teams, while valuing the unique contributions each of us can bring. Our welcoming workplace is designed to make you feel confident, comfortable and prepared to succeed.
Opportunities that advance your career. Learn new skills, take on new roles and move your career in the direction you want. At ICBC, your career is more than just your job title. We support you broadening your skill set, exploring new roles and developing a long-term plan for your professional advancement.
Rewarding work with a sense of purpose. Helping British Columbians is at the heart of everything we do. We contribute to communities across B.C. and help people get to where they need to go safely. If you thrive in a workplace that values work with a clear purpose, we invite you to join us.
Take a look at our openings on icbc.com/careers or the jobs tab on our Linkedin page.
Similar Jobs
Data Architect - Intermediate
Top Benefits
About the role
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 accessibility_services@icbc.com – 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. Of course, you’re welcome to apply for jobs at ICBC whether or not you join a talent community. We look forward to hearing from you! 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. #IND1
Not the right fit? Search for Data Architect jobs in North Vancouver, British Columbia, Canada
About ICBC (Insurance Corporation of British Columbia)
We're ICBC, your provincial Crown Corporation responsible for insurance, driver licensing and road safety. At ICBC, you'll have the opportunity to advance your career in a supportive environment, with benefits that support your health and wellness to help you thrive.
Why work with us? Competitive benefits to make the most of life in B.C. From health coverage to pensions, our benefits and perks provide peace of mind.
A collaborative work environment. We foster collaboration across all our teams, while valuing the unique contributions each of us can bring. Our welcoming workplace is designed to make you feel confident, comfortable and prepared to succeed.
Opportunities that advance your career. Learn new skills, take on new roles and move your career in the direction you want. At ICBC, your career is more than just your job title. We support you broadening your skill set, exploring new roles and developing a long-term plan for your professional advancement.
Rewarding work with a sense of purpose. Helping British Columbians is at the heart of everything we do. We contribute to communities across B.C. and help people get to where they need to go safely. If you thrive in a workplace that values work with a clear purpose, we invite you to join us.
Take a look at our openings on icbc.com/careers or the jobs tab on our Linkedin page.