Junior Data Engineer - Toronto

Data Engineer Job Description :

Mod Op is a full-service advertising agency with offices across several US locations, Panama City, Panama, and Canada. (THIS ROLE IS LOCATED ONSITE IN CANADA) With continued growth and a dynamic leadership team, we offer a generous time-off package, access to high-quality healthcare options, and a collaborative team dedicated to career and personal development. We believe in teamwork, client collaboration, storytelling, stunning design, and solving complex problems with innovative solutions. We are a 360° agency providing strategy, design, and production across all channels, with clients representing a variety of industries, offering diverse and exciting challenges. We are committed to working smart and enjoying the work we do.

About You :

As a Data Engineer with 4+ years of experience, you will be responsible for designing and implementing robust data pipelines, optimizing data workflows, and supporting 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 :

• Data Pipeline Development : Design, develop, and maintain scalable ETL / ELT pipelines in GCP & AWS using various services including Data Flow, Composer, AWS Data Pipelines and etc
• Data Integration : Work with structured and unstructured data sources, including CRM and marketing data platforms.
• Database Management : Develop and optimize queries for SQL & NoSQL databases (Teradata, BigQuery, Cassandra, etc.).
• Data Science & ML : Implementing Models using GCP Vertex ai and utilizing Python and its data science libraries (Pandas, NumPy, Scikit-learn, etc.) for data analysis and ML model deployment.
• Data Visualization : Build and manage dashboards using Power BI, Google Looker and Tableau to provide business insights.
• Collaboration : Work closely with data analysts, marketing teams, and other stakeholders to understand business needs and implement effective data solutions.
• The position operates under a hybrid work model, requiring in-office presence two days per week, with the remaining days worked remotely.

Requirements

Required Qualifications :

Preferred Qualifications :

Benefits

When asked what they love about working at Mod Op, we hear :

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.