Jr Client Data Engineer

Acosta Sales & Marketing; Toronto; On-site; CAD 93,000 - 105,000; Full time

Job summary

A leading marketing agency is seeking a Jr Client Data Engineer in Toronto, Ontario. This role involves developing and managing data ingestion, storage, and modeling for clients, working closely with senior engineers on data solutions and ensuring data quality for business decisions. Ideal candidates hold a bachelor's in a relevant field and have proficiency in SQL and programming, with a focus on continuous learning and optimization. This full-time position offers a salary range between $67,000.00 - $75,000.00.

Qualifications

• A bachelor’s degree in computer science, Engineering, Information Technology, or equivalent.
• Proficiency in SQL and familiarity with programming languages such as Python.
• Experience with software version control with Git and Git management platforms such as GitHub or GitLab.

Responsibilities

• Work with the broader team to implement solutions based on requirements.
• Help create datasets for analytics by designing data models.
• Support integration of data from disparate sources and systems.

Skills

Proficiency in SQL

Familiarity with Python

Excellent communication skills

Ability to handle data processing tasks

Education

Bachelor’s degree in computer science, Engineering, Information Technology, or equivalent

Tools

Git

Google Cloud Platform

Docker

Tableau

Job description

DESCRIPTION

The Jr Client Data Engineer position will assist in developing and managing the ingestion, storage, modeling, and consumption of data for Mosaic and our clients. This role involves transforming raw data into usable formats, ensuring efficient data storage and processing, and supporting the back end of our data environment. The Jr Client Data Engineer will work closely with senior engineers and other teams to create and monitor data solutions, resolve incidents, optimize workloads, and explore emerging technologies.

RESPONSIBILITIES

• Work with the broader team and Client Service to understand and implement solutions based on high level designs and requirements.
• Help create datasets for analytics by designing logical data models and turning them into physical data structures.
• Support the integration of data from disparate sources and systems, including databases, APIs, files, and streaming platforms.
• Assist in ensuring analytics-ready data is of sufficient quality to make critical operational, tactical, and business decisions.
• Participate in the software development lifecycle, including requirements gathering, design, development, testing, deployment, and maintenance of data solutions.
• Develop resources which aid data platform users such as data catalogues, lineage documentation, and user guides.
• Support the development and maintenance of infrastructure on Google Cloud Platform and/or Azure.
• Develop understanding of all areas of Mosaic business to find new opportunities for optimization.
• Stay current with technology trends to continually develop ingestion, ETL/ELT, and general data/software skills, and evangelize within the team.
• Ensure data security and compliance with company policies.

QUALIFICATIONS

Minimum Qualifications

• A bachelor’s degree in computer science, Engineering, Information Technology, or equivalent.
• Proficiency in SQL and familiarity with programming languages such as Python.
• Experience with software version control with Git and Git management platforms such as GitHub or GitLab.
• Basic understanding of Cloud Computing platforms such as GCP/AWS/Azure and their services.
• Understanding of data warehousing and data modeling concepts.
• Familiarity with data orchestration and workflow management tools such as Airflow.
• Ability to handle data processing tasks and the support the development of scalable data applications.

Preferred Qualifications

• Excellent communication skills, with the ability to interact comfortably with peers and leadership both internally and externally.
• Hands-on experience with data manipulation libraries and frameworks like Polars, Pandas, Spark, or similar tool.
• Familiarity with data warehousing concepts and technologies, such as Google BigQuery, Amazon Redshift, or Snowflake, and basic experience in writing and optimizing SQL queries for these platforms.
• Knowledge of ETL/ELT processes and tools, with basic understanding of how to build and manage data pipelines.
• Exposure to containerized tools like Docker or Kubernetes in a plus.
• Basic knowledge or experience with Infrastructure as Code (IaC) tools like Terraform or Pulumi.
• Some experience with data visualization tools such as Tableau, Power BI or Looker.
• Proven ability to manage and complete projects within deadlines, even in an ambiguous or rapidly changing environment.

ABOUT US

Mosaic is a part of Acosta Group – a collective of the industry’s most trusted retail, marketing and foodservice agencies reimagining the way people connect with brands at every point in their shopping journey.

As a leading North American integrated marketing agency, Mosaic specializes in everything from experiential marketing, commerce + retail media and field marketing, to design and production. With a 35+ year history, Mosaic has office hubs in Chicago, Dallas, and Toronto and full reach across North America.

We focus on creating brand experiences that connect brands with consumers in creative and relevant ways. Mosaic’s ultimate mission is to propel our client’s business, culture, and communities forward to make the human experience better. We are diverse, yet like-minded individuals, and we believe in taking risks and creating shared experiences, not just for our clients, but for each other. Every associate is given the keys to charter new ground as they collectively live in the moment of building memorable experiences together.

Acosta Group is an equal opportunity employer and will ensure that applicants with disabilities are provided with reasonable accommodations. If reasonable accommodation is needed, please contact [e-mail]. Be sure to include "Applicant Accommodation" in the subject of your email to expedite the request.

Acosta Group believes in good faith that the minimum and maximum annual salary or hourly compensation range for this opportunity is accurate and reasonable at the time of posting.

The Acosta Group utilizes E-Verify for validating the ability to work in the United States for all job candidates. If you want more information on what this entails and your rights as a job applicant, please use the link provided to access information on our use of E-Verify and your right to work. Employer Resources (e-verify.gov)

By applying, you agree to our Privacy Policy and Terms and Conditions of Use.
#DiscoverYourPath

Acosta, and its subsidiaries, is an Equal Opportunity Employer

Job Category: Administration

Position Type: Full time

Business Unit: Marketing

Salary Range: $67,000.00 - $75,000.00

Company: Mosaic Sales Solutions US Operating Co, LLC

Req ID: 17190

Employer Description: MOSAIC_EMP_DESC