Sql jobs in Canada

Amazing Career Moments Happen Here

Transforming the insurance industry is ambitious, we know. That’s why at Applied, we’re building a team that shows up every day ready to learn, willing to try new things, and driven to deliver innovative software and services that make us indispensable to our customers – all within a culture built on values that make us indispensable to each other too. With 40+ years of experience in the insurtech game, we’re not just redefining what’s achievable, we’re creating a place where amazing career moments are made possible.

Position Overview

We’re searching for a Senior Data Engineer – DevOps with proven experience in DevOps in Google Cloud Platform (GCP) to join our team. We are on an exciting journey to scale our Data and Analytics capabilities to enable better data-driven decision making across the business. In this role, you will be responsible for the implementation of CI/CD pipelines that automate the deployments of data flows and DBT models, as well as designing, building scalable data pipelines, optimizing data processes, and ensuring the seamless integration of data from various sources. If you are passionate about data and excited to work on cutting-edge technologies, we want to hear from you!

What You’ll Do

• Build and maintain the CI/CD pipelines to improve developer productivity, agility and code quality
• Optimize data pipelines and data processing workflows for performance, scalability, and efficiency
• Optimize design efficiency to minimize data refresh lags, improve performance and enable data as a service through leveraging reusable components and automated data quality checks
• Design, develop, operationalize robust and scalable data pipelines to support business needs
• Code BigQuery procedures, functions, and other database objects by applying expert knowledge in BigQuery
• Optimize ETL processes and data workflows to ensure efficiency, performance and high scalability
• Monitor and manage application performance and service quality, including initial troubleshooting, identification of root cases and issue resolution. Implement and improve alerting and monitoring
• Lead in designing and building production data pipelines from data ingestion to consumption using GCP services, Python, BigQuery, DBT, SQL, Apache Airflow, Celigo
• Implement monitoring and alerting mechanisms to proactively identify and resolve issues. Conduct regular performance tuning and capacity
• Ensure data quality and consistency through rigorous testing and validation processes
• Troubleshoot and resolve data-related issues promptly
• Create, update, and maintain technical documentation of the data processes, pipelines, and models
• Stay updated with industry trends and technologies to continuously improve our data engineering practices

We’re Excited to Learn More About You

Your experience may include:

• 8+ years of experience in Data / ETL Engineering, as well as Data / ETL Architecture and pipeline development with a minimum of 2+ years of working experience as Google Cloud Platform (GCP) developer
• Proven experience in building and maintaining a scalable Data Warehouse in a cloud-based data platform, preferably in Google’s BigQuery
• 3+ years of advanced SQL development experience coupled with robust Python or Java programming capabilities
• Extensive experience building and optimizing ETL/ELT pipelines, data modeling and schema design in cloud Data Warehousing technologies (BigQuery is preferred, Snowflake, AWS, Azure)
• Solid experience with GCP services, such as Composer, Compute, GCS, Cloud Functions, BigQuery
• Proficiency in DevOps tools and practices, including CI/CD using Git and GitLab, automation, and monitoring
• Proficiency in one or more coding languages like Python, PySpark, Java
• Experience with integrating GCP with DevOps pipelines
• Strong automation scripting skills and practical experience with GCP, especially using Composer
• Knowledge of Data Lake and Data Warehousing concepts and Data Modelling techniques
• Knowledge in data modeling and familiarity with concepts like star schema, snowflake schema, and normalization
• Strong problem-solving skills and the ability to work independently as well as collaboratively
• Excellent communication skills and the ability to articulate technical concepts to non-technical stakeholders
• Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience

We know that talent comes from all backgrounds and experience levels. We encourage military members and their spouses as well as candidates without a degree or a background in tech to apply!

When You Join Team Applied, You Can Expect:

A culture that values who you are and recognizes that you aren’t just an employee; you are a teammate, and you matter. We thrive on the benefits of our different experiences and celebrate the uniqueness our teammates bring to work with them every day.

We flex our time together, collaborating remotely and in-person to empower our teams to work in the ways that work best for them.

A comprehensive benefits and compensation package that centers our teammates and helps them to bring their best to work every day:

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

Learn more about the people behind our products at https://www1.appliedsystems.com/en-us/about-us/jobs/

Your Security Matters: Our candidates’ personal information and online safety are top of mind for us. At Applied, we proactively protect your personal information and only communicate with candidates via a secure @appliedsystems.com email or through our official careers portal. Recruiters will never request payments, ask for financial account information or sensitive information like social security numbers.

EEO Statement

Applied Systems is proud to be an Equal Employment Opportunity Employer. Diversity and Inclusion is a business imperative and is a part of building our brand and reputation. At Applied, we don’t discriminate, and we are committed to recruit, develop, retain, and promote regardless of race, religion, color, national origin, sexual orientation, gender identity, disability, age, veteran status, and other protected status as required by applicable law.

#LI-Remote