Data Engineer - Intermediate
North Vancouver, British Columbia, Canada
This is an Internal ICBC job posting for applicants within the bargaining unit. External applicants will not be considered.
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 Intermediate Data Engineer will join the Information Management team and focus on the development of big data reporting and analytics solutions, working closely with business partners and stakeholders to meet their decision-support requirements.
As the consolidation point for all business intelligence and business analytics functions across ICBC, the Information Management team's goal is to empower the organization to drive efficiencies and savings across all facets of the business. This is accomplished by providing internal and external customers with precision reporting, query and analysis, statistical, descriptive analysis, and performance measurement (dashboards, scorecards and indicators).
Accountabilities will include:
• Working in collaboration with customers across the organization (Strategic Analytics, Claims, Insurance, Finance, Driver Licensing, Road Safety, etc.) to plan, scope, execute and sustain data-based solutions.
• Responding to internal and external ad hoc requests, review and clarify data requirements, ensuring report content is acceptable within policy and privacy protocols.
• Providing subject matter expertise within the department and to clients on data sources, reporting workflows, business process, and the appropriate tools with which to analyze their data.
• Participating with corporate data user teams, developing data validation and test plans, performing user acceptance testing, and providing feedback to development and sustainment teams.
• Conducting analysis for moderate to complex requests, defining data fields and determining data availability, developing information layout, format and interactivity. Presenting findings and providing clarification.
Position Requirements:
To make an immediate contribution, the Intermediate Data Engineer will bring the following:
• Advanced skill in Object Oriented programming languages such as Scala, Python or Java.
• Working experience with Big Data platforms, with exposure to Hadoop ecosystem (Spark, HDFS, Hive, Kafka) and AWS big data technologies (AWS Glue, Lamba, and S3)
• Experience with CI/CD tools like Jenkins, Git, Fisheye, SVN
• Experience in developing efficient and robust data transformation & ingestion pipelines
• Working experience in building and deploying machine learning models.
• Advanced working SQL knowledge and experience working with Relational and NoSQL databases.
• Strong analytical skills related to working with unstructured datasets.
• Demonstrated ability to work with large and complex datasets, while managing priorities and responding to time pressures.
• Detail-oriented with demonstrated ability to meet deadlines, manage multiple priorities and work effectively under pressure.
• Strong data quality management process understanding, data analysis and data profiling.
• Ability to apply critical thinking skills to troubleshoot and perform root cause analysis on technical problems and solution design.
• Providing technical advice and guidance to staff in resolving complex data ingestion and transformation issues.
• Experience with performance tuning and code optimization.
• Design, develop and enforce best practices and standards around data engineering.
• Ability to work effectively with a team or independently, as well as lead small teams as needed.
• Demonstrating leadership qualities in coaching junior staff members and new hires.
• Understanding of Agile Methodologies.
• Excellent interpersonal, verbal and written communication skills to work with Managers, Directors and Executive level stakeholders.
• Experience with reporting and visualization tools, such as Tableau, user interface design, and iterative customer-driven design processes would be additional assets.
This is an Internal ICBC job posting for applicants within the bargaining unit. External applicants will not be considered.
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.
#IND1
Job Segment:
Database, User Experience, Business Intelligence, Java, SQL, Technology