Data Engineer

Lead II - Software Engineering

 

Who We Are:

Born digital, UST transforms lives through the power of technology. We walk alongside our clients and partners, embedding innovation and agility into everything they do. We help them create transformative experiences and human-centered solutions for a better world.

UST is a mission-driven group of 29,000+ practical problem solvers and creative thinkers in more than 30 countries. Our entrepreneurial teams are empowered to innovate, act nimbly, and create a lasting and sustainable impact for our clients, their customers, and the communities in which we live.

With us, you’ll create a boundless impact that transforms your career—and the lives of people across the world.

Visit us at UST.com.

 

You Are:

We are looking for an experienced Data Engineer with expertise in Apache Spark, PySpark, Python, and AWS services (particularly Glue) to join our team. The ideal candidate will have hands-on experience with ETL processes in the cloud, a deep understanding of data pipelines, and the ability to work with large datasets efficiently. This role will focus on designing, building, and optimizing data workflows on AWS Cloud using Spark-based frameworks and Python.

 

The opportunity:

·       Design and implement scalable data processing pipelines using Apache Spark and PySpark for large-scale data transformations.

·       Develop, maintain, and optimize ETL processes to efficiently extract, transform, and load data across various data sources and destinations.

·       Utilize AWS Glue for serverless ETL jobs, including creating, running, and monitoring Glue jobs for data transformations and integrations.

·       Write efficient and reusable Python code to support data manipulation, analysis, and transformation in Spark and Glue environments.

·       Ensure that data workflows are optimized for performance, scalability, and cost-efficiency on AWS Cloud.

·       Work closely with data analysts, data scientists, and other engineering teams to build reliable data solutions that support business analytics and decision-making.

·       Document processes, workflows, and code, while adhering to best practices in data engineering, cloud architecture, and ETL design.

 

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

 

What you need:

·       Proficient in using Apache Spark and PySpark for big data processing and transformation.

·       Hands-on experience with AWS Glue for building ETL workflows in the cloud.

·       Strong programming skills in Python, particularly for data manipulation, automation, and integration with Spark and Glue.

·       Solid understanding of ETL principles and data pipeline design, including optimization techniques.

·       Experience working with AWS services, particularly those related to data processing (e.g., S3, Glue, Lambda, Redshift).

·       Must have proficiency in writing optimized SQL with performance tuning aspects.

·       Ability to translate complex business requirements into technical solutions.

·       Experience with Apache Airflow for orchestrating data workflows.

·       Knowledge of data warehousing concepts and cloud-native analytics tools.

 

 

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below.

Role Location: Ontario

Compensation Range: $98,000-$120,000

 

 

 

Benefits

Full-time, regular employees accrue a minimum of 10 days of paid vacation per year, receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year), paid holidays, and are eligible for paid bereavement leave and jury duty. They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Full-time temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year). They and their dependents residing in Canada are eligible for Supplemental Healthcare coverage, as well as Company-paid Employee Only basic life insurance and accidental death and dismemberment coverage.

Part-time regular and temporary employees receive 6 days of paid sick leave each year (pro-rated for new hires throughout the year).

All Canadian employees who work in a province, territory or locality with more generous paid sick leave benefits than specified here will receive the benefit of those sick leave laws.

What we believe:

We proudly embrace the values that have shaped UST since day one. We build our culture of Humility, Humanity, and Integrity. These values inspire us to nurture a people-first, human centric culture that fosters diversity, prioritizes sustainable solutions, and keeps our people and clients at the forefront of all decisions.

Humility:

We will listen, learn, be empathetic and help selflessly in our interactions with everyone.

Humanity:

Through business, we will better the lives of those less fortunate than ourselves.

Integrity:

We honor our commitments and act with responsibility in all our relationships.

An Equal Opportunity Workplace, Free of Discrimination and Harassment

At UST, we strive to provide a work environment free of discrimination and harassment. We are an equal opportunity employer and employment decisions are based on merit and business needs. Our Human Rights Policy further illustrates our stand on this. We are committed to following fair employment practices that provide equal opportunities to all employees. We do not discriminate or allow harassment on the basis of race, color, religion, disability, gender, national origin, sexual orientation, gender identity, gender expression, age, genetic information, military status, or any other legally protected status. At UST, we value diversity and believe that a diverse workplace builds a competitive advantage.

Un lieu de travail à égalité des chances, sans Discrimination et harcèlement

Chez UST, nous nous efforçons de fournir un environnement de travail exempt de discrimination et harcèlement. Nous sommes un employeur garantissant l'égalité des chances et des décisions en matière d'emploi sont basés sur le mérite et les besoins de l'entreprise. Notre politique en matière de droits de l'homme illustre notre position à ce sujet. Nous nous engageons à respecter un emploi équitable des pratiques qui offrent des chances égales à tous les employés. Nous ne faisons pas discriminer ou permettre le harcèlement sur la base de la race, de la couleur, de la religion, du handicap, genre, origine nationale, orientation sexuelle, identité de genre, expression de genre, âge, informations génétiques, statut militaire ou tout autre statut légalement protégé. Chez UST, nous valorisons la diversité et pensons qu'un lieu de travail diversifié crée un avantage compétitif.

UST reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.

 

 

#UST

#LI-AP1