Data Engineer, Infrastructure

BCAA; Eastern Ontario; Hybrid; CAD 97,000 - 122,000; Full time

Job summary

Join a forward-thinking organization as a Data Engineer – Infrastructure, where you will be at the forefront of modernizing databases and cloud environments. This hybrid role offers the chance to work with cutting-edge technologies in AWS and Azure, ensuring robust and scalable infrastructure. You will play a key role in implementing automation solutions and optimizing database performance, all while collaborating with cross-functional teams to align technical solutions with business goals. If you are passionate about innovation and eager to make a difference in the lives of British Columbians, this opportunity is perfect for you!

Benefits

Career Development

Flexible Benefits

Paid Time Off

Performance Bonus

Pension Plan

BCAA Membership

Wellness Dollars

Qualifications

• 3+ years in database administration or architecture, with 2+ years in an enterprise environment.
• Hands-on experience with AWS and cloud technologies.

Responsibilities

• Implement and support disaster recovery policies and data archiving.
• Design and configure database servers for optimal performance.

Skills

Database Architecture

AWS Cloud Infrastructure

Automation Solutions

Troubleshooting

Collaboration

Analytical Skills

Communication Skills

Education

Bachelor’s Degree in Computer Science

Bachelor’s Degree in Information Systems

Bachelor’s Degree in Computer Engineering

Tools

AWS

Azure

SQL Server

Amazon RDS

Oracle Databases

PowerShell

Job description

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 Data Engineer – Infrastructure based in our Head Office.

Please note that this is a hybrid role based out of our Burnaby, BC office (2 Days On Site / 3 Days Remote). 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.

As a Data Engineer – Infrastructure at BCAA, you will play a critical role in modernizing and managing our databases and cloud environments across AWS and Azure. Reporting to the Senior Manager, Infrastructure and Cloud Engineering, you will provide technical expertise in database architecture, automation, and cloud technologies. This position supports the design, implementation, and optimization of database solutions, ensuring robust, scalable, and secure infrastructure that meets the evolving needs of the organization.

This is an exciting opportunity for a technical professional passionate about innovation and cloud technology to contribute to BCAA’s infrastructure modernization efforts.

Who you are:

• You are a technically skilled professional with a strong understanding of database architecture and cloud technologies.

• You have hands-on experience with AWS cloud infrastructure and automation solutions.

• You are proactive and detail-oriented, with a strong ability to troubleshoot and resolve technical challenges.

• You are a collaborative team player who communicates effectively with both technical and non-technical stakeholders.

• You are motivated to continuously enhance processes, adopt emerging technologies, and contribute to operational excellence.

What you’ll do:

• Implement and support redundant systems, disaster recovery policies, and data archiving to ensure the protection and integrity of data assets.

• Analyze and resolve technical support incidents in BCAA’s AWS cloud infrastructure.

• Design, build, install, and configure database servers while ensuring optimal performance and security.

• Automate workloads in AWS, leveraging tools like PowerShell and scripting to streamline infrastructure services.

• Manage database operations, including strategic planning for production databases, data migrations, and system upgrades.

• Develop and implement IAM security solutions within AWS, ensuring secure access and identity management.

• Conduct research on database products and make recommendations to support procurement and development initiatives.

• Advocate for innovative designs and frameworks to enable value-driven automation and operational efficiency.

• Collaborate with cross-functional teams to align technical solutions with business needs and goals.

• Contribute to evolving CI/CD practices, ensuring effective integration and deployment of database solutions.

What you bring:

• Bachelor’s Degree in Computer Science, Information Systems, Computer Engineering, or a related field.

• 3+ years of experience in database administration, information technology, or database architecture, with 2+ years in an enterprise environment.

• Expertise in DBMS technologies, including SQL Server, Amazon RDS, Athena, and Oracle Databases.

• Proficiency with AWS cloud technologies such as EC2, EMR, S3, Lambda, SQS, SNS, and IAM.

• Solid experience in building ETL pipelines and maintaining database software.

• Exceptional analytical and troubleshooting skills, with a deep understanding of database performance and application relationships.

• Strong communication skills, with the ability to effectively engage technical and non-technical staff.

• Bonus Skills!

  • Amazon Web Services certifications.

  • Experience with networking, network security, and CI/CD practices.

Internal Applicants: Please note that the internal posting closes on January 15, 2025, and the role is a Grade 14 position.

The salary range for this position is $97,384.68 to $121,730.88 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 [e-mail].