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: 

• Cloud Expertise: GCP or AWS (Data Engineering or ML focus) experience. 

• Programming Skills: Strong proficiency in Python and experience with its data science libraries. 

• Database Management: Experience with SQL (Teradata, BigQuery, etc.) and NoSQL databases. 

• Data Visualization: Hands-on experience with Power BI, Google Looker and Tableau for reporting and dashboards. 

• CRM & Marketing Data: Experience working with CRM, marketing platforms, and analytics tools. 

• Machine Learning Knowledge: working GCP/AWS Services with ML workflows, model training, AI Models and deployment. 

• Data Automation & Transformation: Knowledge with 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. 

Benefits

• Health and Life Insurance for employees and family, access to Vision benefits, Telemedicine services, Psychology support and others.
• On the job training and career growth opportunities.
• Access to LinkedIn courses.
• Fully remote job.
• Talented team environment, collaborative offices, fun company culture with a great balance of work and play.
• Vacations are granted by day or weeks according to employee approved request.
• Salary with yearly review and competitive benefits.
• Competitive compensation based on experience and skill set.

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

• “I feel I can be myself at work and it’s fun!” -MV
• “The caliber of the clients/brands we work with, knowing your work is seen by thousands of people, in many cases across the world.” -JC

• “We actually create videogames!” -AC
• “We have an all-star team, and it’s like playing in the pro-bowl every day!” -MW
• “Opportunities to always learn from and work with the best and the brightest.” HW
• “Mentors and opportunities for growth.” -KB

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.