Data Developer

Mod Op Llc.; Toronto; Hybrid; CAD 60,000 - 70,000; Full time

Job summary

A full-service advertising agency is looking for a Data Developer with over 2 years of experience. The role involves designing and implementing data pipelines, optimizing workflows, and supporting analytics. Candidates should have expertise in AWS/GCP, Python, and data visualization tools like Power BI and Tableau. The position operates under a hybrid model, requiring in-office presence two days a week. The salary range is competitive, between $60-70K depending on experience.

Benefits

Generous time-off package

High-quality healthcare options

Commitment to professional development

Group RRSP Matching program

Qualifications

• 2+ years of experience designing and implementing data pipelines.
• Proficiency in data workflows using AWS and GCP.
• Experience with Python and data science libraries for analysis.

Responsibilities

• Design and maintain scalable ETL/ELT pipelines in GCP & AWS.
• Integrate with structured and unstructured data sources.
• Collaborate with data analysts and marketing teams for effective solutions.

Skills

Cloud Expertise

Programming Skills in Python

Database Management

Data Visualization

CRM & Marketing Data Experience

Machine Learning Knowledge

Data Automation & Transformation

Tools

Power BI

Google Looker

Tableau

Alteryx

SQL Databases (Teradata, BigQuery)

NoSQL Databases (Cassandra)

Job description

Data Developer Job Description

Mod Op is a full-service advertising agency with offices across several US locations, Panama City, Panama, and 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 Developer with 2+ 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.

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.
• Flexible, hybrid work arrangements.
• Annual company shutdown during the holiday season.
• Frequent studio-wide social events.
• Budget and time allotted for professional development.
• Commitment to wellbeing and work life balance.
• Competitive health and dental benefits package.
• Group RRSP Matching program

Salary Range

$60-70K (subject to experience level)

What our teammates say

• “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

Diversity and Inclusion

Some of our best ideas emerge when different perspectives collide. That’s just one of the reasons we’re committed to building and retaining a team that reflects diverse backgrounds, identities, experiences, and abilities. Through our core values, we’re also fostering a culture where everyone feels heard, included and comfortable being themselves.