Data Engineer

Why BCAA?

Feel proud of what you do and help shape the future of BC at a BC Top Employer. We’re driven by purpose delivering peace of mind to one in three BC households with insurance, roadside assistance, auto repair, Evo Car Share and Evolve E-Bike Share.

With a long history of keeping roads safe and giving back in ways that build stronger communities, we offer a wide variety of meaningful, rewarding careers that move BC forward.

BCAA is hiring for a Regular Full-Time Data Engineer!

BCAA’s Data and Analytics Centre of Excellence (COE) is a growing team of data scientists, developers and analysts who deliver value across the organization by leading the development of data science, information governance and digital solutions through best practices, research, support, and training for the organization’s analytics community.

As a Senior Data Engineer within the DnA Centre of Excellence, you will provide hands-on leadership while working on a cross-functional team that is passionate about innovation and collaboratively solving complex problems.

You will work closely with stakeholders across the organization to address business problems and support insight-driven decision making, while working alongside team members within the Data Science and Information Governance practice.

Your ability to communicate with both technical and non-technical leaders and team members, and to support the implementation of solutions from self-serve analytics to advanced machine learning will be key to your success.

Who you are :

You’re an effective communicator with the ability to build strong relationships at all levels across the organization.

You are well verse in data engineering best-practices and industry standards.

You're proud of your analytical and critical thinking abilities.

You’re highly organized with strong attention to detail.

You enjoy solving problems through technical solutions.

You are a data engineering champion; you are an advocate for advancing core data engineering practices and engaging with the analytics community.

You’re eager to hop in and grow by learning new skills and knowledge.

Once you’re here, you’ll :

Design scalable solutions that are flexible and can evolve within an ever-changing environment.

Deploy data models and analysis for business processes, data usages (flow), process design and data design.

Develop solutions that strengthen data governance, security frameworks, data integrations and data integrity.

Work closely with DnA CoE data scientists, BI developers, information governance and business stakeholders to lead data processing solutions that deliver value throughout the enterprise.

Provide organizational engineering and data architecture expertise; consulting services to design, deploy and maintain systems to enable downstream analytics, ensuring standards and best practices are embedded.

Collaborate with stakeholders at all levels of the organization on a range of business problems, identifying and supporting the implementation of solutions to drive improved business results through advanced analytics.

Thoroughly document assumptions, requirements, methodology, test plans and facilitates knowledge sharing and insight on engineering and usage of new data engineering and data discovery tools.

Analyze both structured and unstructured data to identify patterns, trends / dependencies and communicate the results to the relevant stakeholders.

Coordinate model-driven process engineering and automation initiatives.

Assist with embedding the use of advanced analytical tools and techniques across analytics teams at BCAA.

Develop automated data and metadata processes for leverage organizational insight and action.

Support and enable collaboration across the business to democratize information and remove data silos’.

What you bring :

Degree in Computer Science, Information Systems, or Computer Engineering and related AWS / Azure certifications. Analytics, Statistics, Data Science a plus.

Four years’ experience as a data engineer or ETL developer : four years demonstrated experience building data warehouses, scalable data pipelines, provisioning self-serve

You have experience leading data projects from problem identification to production.

You have experience supporting ML and AI experiments, business intelligence, data science models and reporting.

You are proficient in handling large and complex data sets in all stages from extraction to modelling, structuring, filtering, discovery, and development of visualizations.

You have experience developing, optimizing, and implementing machine learning models in a production environment.

You have a solid understanding of foundational statistical concepts.

Ability to connect systems using API’s, Python code or Bash scripts.

Strong working knowledge of source and target data structures, ETL and CDC processes and products, analysis, troubleshooting, and code review.

You have demonstrated experience with quantitative data analysis and utilizing data to drive decision-making, specifically related to measuring and demonstrating effectiveness.

Working understanding of high-volume data processing and analysis, relational and NoSql Databases, and Machine Learning Tools / Frameworks.

Capability to learn and develop new engineering techniques as required.

Experience with the following tools / languages for data management and manipulation : Informatica, MapReduce, Rest APIs, Attunity Qlik-Replicate, Scala

Proficient in : Python, SQL, NoSQL

Python, SQL, NoSQL

AWS stack (certification preferred)

PowerBI, Tableau

The salary range for this position is $103,506.96 to $129,383.64 and is determined via job-related knowledge, skills, experience, certifications, market demand and internal equity.

In addition to base salary and BCAA benefits, this position is eligible for a performance bonus target of 9%, with the opportunity to earn up to 15%.