Data Engineer

Synechron•Mississauga, ON

11d•Hybrid

About The Position

Synechron is a global consulting firm that leverages digital transformation to improve businesses. They combine creativity and innovative technology to deliver industry-leading digital solutions, specializing in Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering for financial services and technology firms. Through their FinLabs, they develop solutions for modernization, including AI, Blockchain, Data Science models, Digital Underwriting, and mobile-first applications. With over 20 years of experience, Synechron has received multiple employer awards and boasts a global workforce of 16,400+ across 60 offices in 20 countries. The company is seeking a skilled Data Engineer to join their dynamic team. The ideal candidate will have a strong background in data modeling, SQL, ETL processes, and practical experience with Azure cloud, particularly Databricks. This role is crucial for designing, developing, and maintaining scalable data pipelines, contributing to data strategy initiatives, and enabling insightful analytics.

Requirements

3 to 6 years of experience in data engineering with demonstrated expertise in data modeling and SQL.
Proven experience in developing ETL solutions and orchestrating data pipelines.
Hands-on experience working with Azure cloud platform, specifically Azure Data Factory, Data Lake, and Databricks.
Strong programming skills in Spark, Python, or Scala for data processing tasks.
Familiarity with data governance, security protocols, and regulatory compliance requirements.
Excellent problem-solving skills, keen attention to detail, and ability to troubleshoot complex data issues.
Ability to work independently and collaboratively within a team environment.
Bachelor’s degree in Computer Science, Information Technology, or related field.

Nice To Haves

Certifications in Azure Data Services or Databricks are a plus.
Experience working with BI tools and report generation frameworks.
Knowledge of other cloud platforms (AWS, GCP) is advantageous.
Experience with REST APIs integration.
Experience with GraphQL.

Responsibilities

Design, develop, and optimize data models and schemas to effectively support business requirements.
Build, implement, and maintain efficient ETL pipelines utilizing Spark, Databricks, and other relevant tools.
Develop complex SQL queries, stored procedures, and functions to extract, transform, and load data from multiple sources.
Collaborate with data analytics, data science, and business teams to gather requirements and deliver tailored data solutions.
Leverage Azure Data Services including Azure Data Lake, Azure Data Factory, and Azure Databricks to create scalable, reliable data architectures.
Ensure adherence to data quality, governance, security, and compliance standards across all data processes.
Continuously monitor, troubleshoot, and optimize data pipelines for performance, scalability, and robustness.
Document data architecture, workflows, and procedures; participate in code reviews and establish best practices.

Benefits

A multinational organization with 60 offices in 20 countries and the possibility to work abroad.
15 days (3 weeks) of paid annual leave plus an additional 10 days of personal leave (floating days and sick days).
A comprehensive insurance plan including medical, dental, vision, life insurance, and long-term disability.
Flexible hybrid policy.
RRSP with employer’s contribution up to 4%.
A higher education certification policy.
On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
A truly diverse, fun-loving and global work culture.