Data Engineer (GCP, BigQuery)

Canada External Job Ad

Team: AI Engineering -– Reporting and AnalyticsSalary Range: CAD 70K- CAD 120K

Location: Remote

 

Opportunity for Impact

 

Applied is where insurance technology gets reinvented, and we build it fast. Our cloud software and AI-powered solutions reach thousands of agencies and brokers worldwide, setting the pace for what modern insurance can do.

 

We’re looking for a Data Engineer to join our AI Engineering – Reporting and Analytics team to build and enhance data solutions and AI initiatives for the business of insurance. 

In this role, you will work closely with the Principal Data Architect, Data Scientists, and Software Engineers to build, model, and maintain data solutions as we optimize data architecture and accessibility of large-scale datasets for our global teams. 

 

This position requires the employee to reside and work from one of the following provinces: Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Nova Scotia, Ontario, PEI, Saskatchewan.

 

 

What You’ll Do 

• Code BigQuery procedures, functions, and other database objects by applying expert knowledge in BigQuery SQL and ANSI SQL  
• Implement scalable and efficient data models within our data lake, with a focus on BigQuery 
• Manage and optimize data storage, partitioning, and clustering strategies to ensure high performance and reliability of our data infrastructure
• Develop and implement features and enhancements in BigQuery, levering your expertise in SQL and cloud-based data warehousing technologies 
• Collaborate with cross-functional teams to understand requirements and deliver solutions aligned with business objectives, security requirements, and guidelines for data governance
• Develop documentation for the team to support design discussions 
• Ensure data integrity and quality by implementing robust data validation and error-handling mechanisms. 
• Identify and implement improvements across the full lifecycle of data management, from ingestion to ETL processes and final reporting layers, to increase productivity on the team 
• Continuously build knowledge of industry trends and advancements in data engineering and big data technologies 

 

What We’re Looking For

• 3+ years of experience in modeling, building, and maintaining data solutions in cloud-based environments
• Proficiency in SQL and Python to manipulate, store, manage, or retrieve data assets
• Proven impact with BigQuery and cloud-based data warehousing solutions - Google BigQuery, Snowflake, Amazon Redshift, Microsoft Azure Synapse Analytics, Databricks Lakehouse
• Experience managing and optimizing BigQuery and Google Cloud Platform data services 
• Knowledge of Agile frameworks, ideally Scrum, and tools like Jira and Confluence 
• Demonstrated analytical and problem-solving skills and detail orientation
• Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience 

 

Talent shows up in a lot of different ways, and we mean that. We welcome candidates from all backgrounds and experience levels, including military members and their spouses and those without a traditional degree or tech background. If this role speaks to you, apply.

 

Why You’ll Like Working on Team AppliedThe best work happens when smart people move fast, together. For over 40+ years, Applied has built technology that solves real problems for insurance professionals - and we’re still pushing what’s possible.

 

You’ll be part of our people-first culture built on trust, inclusion, and growth - where you’re supported to deliver, collaborate with teammates who care, and grow with leaders invested in your success.

 

How We’ll Support You

We invest in the whole person, not just the role. Our benefits and resources are built to support your health, your time, and your life outside of work:

• Medical, Dental, and Vision Coverage 
• Holiday and Vacation Time 
• Health & Wellness Days 
• A Bonus Day for Your Birthday 

 

Compensation Transparency

 

The total anticipated annual compensation range for this newly created position in Canada includes starting base salary and, where applicable, variable or incentive pay.  To determine a new team member’s starting pay, we consider a variety of factors, including someone’s depth, breadth, and variety of experience, skills, and responsibilities.

 

Your Security Matters:  Our candidates’ personal inform