Senior Data Engineer I, ETL Development

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.
 

We are currently hiring a Senior Data Engineer I – ETL Development based in our Burnaby Head Office (Hybrid). 

Please note that this is a hybrid role based out of our Burnaby, BC office (3 Remote / 2 On Site). Applicants who are not located within commuting distance of our Head Office or are not looking to relocate to the Greater Vancouver/Lower Mainland/Fraser Valley region will not be considered. 

Join the BCAA Data and Analytics Centre of Excellence (CoE), a collaborative team dedicated to driving innovation and advancing BCAA’s data capabilities. As a Senior Data Engineer I - ETL Developer, you will be instrumental in developing and optimizing BCAA’s Data Lake, which supports advanced analytics and machine learning initiatives across the organization. You will work closely with diverse business units—such as Roadside Assistance, Home Insurance, and Evo Car Share—to deliver data-driven insights and solutions that propel BCAA’s services forward. 

In this role, you’ll build and maintain complex data pipelines, design robust data integration frameworks, and ensure the quality, consistency, and security of BCAA’s data. This is an exciting opportunity for someone passionate about data engineering who wants to help democratize access to insights and foster a culture of data-driven decision-making. 

Who You Are: 

• You have a strong background in data engineering and ETL development, with a knack for solving complex technical challenges.

• You are skilled at managing large datasets, ensuring data integrity, and making data accessible for analysis. 

• You thrive in a collaborative environment, effectively communicating with both technical and non-technical stakeholders. 

• You are detail-oriented, with a focus on data quality and security. 

• You are eager to contribute to the growth and maturity of BCAA’s data infrastructure, pushing the boundaries of what is possible with data. 

Once You’re Here You’ll: 

• Design, construct, and maintain robust and scalable data architectures and ETL pipelines, ensuring they meet evolving organizational needs and industry best practices. 

• Oversee the integration of data from diverse sources, including structured and unstructured data, guaranteeing high-quality data consistency and reliability across BCAA’s platforms. 

• Collaborate with data scientists and business intelligence developers to design data processing solutions that support advanced analytics, machine learning, and reporting requirements. 

• Develop, optimize, and automate existing data workflows to enhance pipeline efficiency, minimize downtime, and increase the availability of critical business data. 

• Deploy and manage sophisticated data models, analyses, and dashboards that empower various business functions, helping departments make data-driven decisions with ease and accuracy.

• Implement engineering solutions that strengthen data governance, improve data security, and comply with regulatory standards, ensuring the organization’s data remains secure and reliable. 

• Actively troubleshoot and resolve data-related issues, collaborating with cross-functional teams to diagnose and address complex challenges in data workflows and integrations. 

• Create and maintain detailed documentation for data processes, including methodologies, test plans, and knowledge-sharing resources, to streamline collaboration and knowledge transfer within the team. 

• Stay updated on emerging tools, technologies, and best practices in data engineering, continuously enhancing BCAA’s data capabilities to foster innovation and operational excellence. 

• Play an instrumental role in data quality management, developing checks, balances, and data validation processes that maintain the integrity and accuracy of organizational data. 

What You Bring: 

• Bachelor’s Degree in Computer Science, Information Systems, or a related field; AWS or Azure certifications are a plus. 

• Minimum of 5 years of experience as a Data Engineer or ETL Developer, with expertise in building data warehouses, scalable data pipelines, and supporting advanced analytics in a cloud environment. 

• Proficiency in Python, SQL, and NoSQL, with experience using the AWS stack. 

• Experience with PowerBI, Tableau, and other data visualization tools. 

• Strong knowledge of ETL processes, Change Data Capture (CDC), and data management frameworks. 

• Familiarity with big data tools and technologies such as Informatica, MapReduce, Qlik-Replicate, and REST APIs. 

• Proven ability to deploy and optimize machine learning models in production. 

• Solid understanding of data governance, security practices, and data integration best practices. 

• Strong problem-solving and analytical skills, with experience managing complex data sets and deriving actionable insights. 

• Bonus Skills and Experience: 

• AWS or Azure certification. 

Internal Applicants: Please note that the internal posting closes on May 5th 2025, and the role is a Grade 16 position. 

The salary range for this position is $117,845.76 to $147,307.20 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%. 

What we offer:

• The chance to make a difference every day in the lives of British Columbians, BCAA Members and our communities.

• Career and personal development to help you grow and reach your goals.

• Incentives that recognize team and individual sales and performance.

• Flexible benefits to support your health and lifestyle, and wellness dollars* to keep your body, mind and soul thriving.

• A competitive rewards package including salary performance bonus programs, pension plan*, and more to help build your personal wealth.

• Paid time off including vacation, and days for wellness, volunteering, and cultural, spiritual or religious connection.

• BCAA membership, with valuable perks and Member savings on every day and special spending, from gas and coffee to clothes, sports and event tickets, and hotels.

• Meaningful, rewarding work for a BC Top Employer known for putting people first and constantly building a better workplace for all our team members.

*for permanent employees

We’re always looking for amazing people like you. Apply today!

BCAA is an Equal Opportunity Employer, committed to providing accessible, inclusive employment. We have a long-standing partnership with the Presidents Group which strives to increase employment opportunities for people living with disabilities, and champion accessible employment in BC. If you need personalized support through application and recruitment, please contact HRAccommodations@bcaa.com.