Junior Data Engineer - Toronto

Mod Op Llc.; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A full-service advertising agency is seeking an experienced Data Engineer to design and implement robust data pipelines and optimize workflows. Candidates should have a minimum of 4 years in data engineering or machine learning, along with cloud service expertise (GCP or AWS). You'll work with SQL and NoSQL databases, utilize visualization tools like Power BI, Google Looker, and Tableau, and operate in a hybrid model requiring two days onsite each week. Our company offers a generous time-off package and high-quality healthcare options.

Benefits

Generous time-off package

High-quality healthcare options

Qualifications

• 4+ years of experience in data engineering or machine learning.
• Experience with cloud services for data engineering.
• Familiarity with reporting and dashboard tools.

Responsibilities

• Design and maintain scalable ETL/ELT pipelines.
• Develop and optimize SQL queries for databases.
• Build dashboards to provide business insights.

Skills

Cloud expertise in GCP or AWS

Proficiency in Python

Experience with SQL and NoSQL databases

Hands-on experience with Power BI

Machine-learning knowledge

Tools

Google Looker

Tableau

Alteryx

Job description

Mod Op Data Engineer

Mod Op is a full‑service advertising agency with offices across the United States, Panama City, Panama, and Canada. The Data Engineer role is located onsite in Canada. We offer a generous time‑off package, high‑quality healthcare options, and a collaborative team dedicated to career and personal development.

About You

As a Data Engineer with 4+ years of experience, you will design and implement robust data pipelines, optimize data workflows, and support analytics initiatives. You will work with AWS and GCP cloud services, integrate with CRM and marketing platforms, and enable data‑driven decision‑making through visualization tools like Google Looker and Tableau.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines in GCP and AWS using services such as Data Flow, Composer, and AWS Data Pipelines.
• Work with structured and unstructured data sources, including CRM and marketing data platforms.
• Develop and optimize queries for SQL and NoSQL databases (Teradata, BigQuery, Cassandra).
• Implement machine‑learning models using GCP Vertex AI and Python data science libraries (Pandas, NumPy, Scikit‑learn) for data analysis and model deployment.
• Build and manage dashboards using Power BI, Google Looker, and Tableau to provide business insights.
• Collaborate closely with data analysts, marketing teams, and other stakeholders to understand business needs and implement effective data solutions.
• Operate under a hybrid work model, requiring onsite presence two days per week with remaining days worked remotely.

Required Qualifications

• Cloud expertise in GCP or AWS with a data engineering or machine‑learning focus.
• Strong proficiency in Python and experience with its data science libraries.
• Experience with SQL (Teradata, BigQuery, etc.) and NoSQL databases.
• Hands‑on experience with Power BI, Google Looker, and Tableau for reporting and dashboards.
• Experience working with CRM, marketing platforms, and analytics tools.
• Machine‑learning knowledge with GCP/AWS services, model training, AI model deployment.
• Knowledge of Alteryx for workflow automation and data preparation.

Preferred Qualifications

• Experience with data warehousing solutions (Snowflake, Redshift, etc.).
• GCP Certified focused on Data Engineering.
• Exposure to Apache Spark, Airflow, or other data orchestration tools.
• Strong understanding of data governance, security, and compliance.

Mod Op, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.