Data Architect

Select how often (in days) to receive an alert: Hours of Work: 7.5 hours per day - 5 day week (M-F) Work Arrangement: Hybrid 8 Salary Range: $92729.00 - $100427.60 Annually 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 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 will join the Data Management IM Customer Team and focus on development Data and Analytics solutions, working closely with business partners and stakeholders to meet their decision-support requirements. This role will work with the Customer Experience Division to support data analysis and equip the business to make data-driven decisions. We use Scala and SQL to perform Data Preparation and Tableau to create self-service dashboards. The team uses the latest in Big Data technologies such as StreamSets, Hadoop and Spark. Accountabilities Develop big data solutions by designing data architectures, including business architecture definition, data storage, data analytics, data transformation, and data access Provide delivery leadership in the design, deployment and data conversion of complex enterprise data solutions Responsible for creation, comprehensive understanding, maintenance and communication of logical and physical data models and mapping documents Work closely with data engineers to design high performing and scalable data solutions Support advanced business analytics and statistically-based data analysis projects to drive business value Responsible for creation and communication of data architecture standards and best practices, and data movement and mapping design Establish and participate in data management processes including data lineage, data profiling, data quality management, data stewardship and governance Advise team members, business partners and customers from a strategic perspective Position Requirements To make an immediate contribution, the Data Architect Intermediate will bring the following skills: Several years’ experience in software development preferably in data & analytics solutions Understanding of traditional and modern data ingestion, data storage, data processing and data access processes Strong SQL and Analytic skills with experience in large and complex datasets Working knowledge in delivering business intelligence or large-scale data warehouses/data lakes using technologies such as Hadoop, Spark, ETL Tools of Oracle, IBM, Teradata and/or similar technology Experience with data profiling, data analysis and data quality framework Experience with Agile/Scrum development methodologies Excellent verbal and written communication skills Ability to constructively resolve conflict, manage expectations for competing priorities, and drive towards business goals Preferred Additional Skills Experience in Data Engineering (Spark SQL, Scala, Python), Unix Shell Script and Scheduling tools like Control‑M Experience with reporting solutions like Tableau, Microsoft Power BI or similar visualization tools Experience with Data Governance framework 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. 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. Resident – you will work at your primary in-office headquarters on all scheduled work days. 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. Hybrid 10 – you will work a minimum of 10 days in a 4‑week period at your primary office headquarters (typically one week in/one week out or up to 3 days per week). The remaining days will be remote within British Columbia. Mobile – you will work a significant amount of time in the field, in addition to working from an office and optionally working remotely within British Columbia. Remote – you will work remotely from within British Columbia, with one required visit to your primary office per month. #J-18808-Ljbffr