Analytics Engineer

Mars Advertising, Inc.; Toronto; On-site; CAD 72,000 - 91,000; Full time

Job summary

A leading global commerce company based in Toronto is seeking a Data Engineer to develop and maintain data pipelines, optimize data infrastructure, and implement ETL processes. The ideal candidate has 3-5 years of experience in data analytics with strong proficiency in SQL, Python, and Power BI. This role offers a comprehensive benefits package, a flexible work environment, and competitive compensation ranging from $72,390 to $90,440 annually.

Benefits

Comprehensive group health plans

Tuition support and assistance

Flexible paid time off

Qualifications

• 3-5 years of industry experience in a data analytics or related role.
• Experience with data warehousing solutions.
• Knowledge of machine learning frameworks like TensorFlow, PyTorch.

Responsibilities

• Develop and maintain data pipelines and ETL processes.
• Optimize data infrastructure for efficient data processing.
• Collaborate with cross-functional teams to address data needs.

Skills

SQL

Python

R

Data Warehousing

Azure Synapse

Power BI

ETL

Machine Learning

Apache Spark

Data Governance

Education

Bachelor’s/Master’s degree in data analytics or computer science

Tools

Databricks

AWS

Google Cloud

Job description

Mars United Commerce Powered by Marilyn is a global commerce company that delivers all the solutions clients need to grow their business today and tomorrow. Founded by the late Marilyn Barnett, we’ve become global leaders in four key commerce disciplines - Strategy & Analytics, Digital Commerce, Content & Experiences, and Retail Consultancy - that together form a United Commerce Ecosystem that provides all the expertise clients need to navigate the commerce marketing landscape. Our 800+ Martians across North America, Europe, Australia, New Zealand and Asia exist to drive growth for our people, our clients, and our communities across the globe.

Part of the overall Analytics Group, the Analytics Engineering team is responsible for data modeling automation and preparing data needed by the Data Science team for modeling and the Business Analytics team for data analysis. This will involve documenting the data cleaning and transformation processes, automating these processes, ensuring data governance practices are followed, and maintaining a data catalog. The team is also responsible for developing all PowerBI dashboards based on client needs or Data Science outputs.

• Core Responsibilities: Data Integration, Data Cleaning, Data Transformation, Data Warehousing, Dashboarding, MLOps, Charts & Visualizations, Reporting Automation, etc.
• Primary Tools: Databricks, Azure Synapse, Power BI

PRIMARY RESPONSIBILITIES:

• Develop and maintain data pipelines and ETL processes.
• Optimize data infrastructure for efficient data processing.
• Ensure data quality and accessibility for data scientists and analysts.
• Collaborate with cross-functional teams to address data needs and challenges.
• Implement data governance and security best practices.
• Support annual planning initiatives with clients.
• Work closely with cross-functional teams, including analysts, product managers and domain experts to understand business requirements, formulate problem statements, and deliver relevant data science solutions.
• Develop and optimize machine learning models by processing, analyzing and extracting data from varying internal and external data sources.
• Develop supervised, unsupervised, and semi‑supervised machine learning models using state‑of‑the‑art techniques to solve client problems.
• Show up - be accountable, take responsibility, and get back up when you are down.
• Make stuff.
• Share others can see what’s happening.

SKILLSETS REQUIRED:

• A bachelor’s/master’s degree in data analytics, computer science, or a directly related field.
• 3-5 years of industry experience in a data analytics or related role.
• Proficiency in SQL for data querying and manipulation.
• Experience with data warehousing solutions.
• Design, implement, and manage ETL workflows to ensure data is accurately and efficiently collected, transformed, and loaded into our data warehouse.
• Proficiency in programming languages such as Python and R.
• Experience cloud platforms such as AWS, Azure, and Google Cloud.
• Experience in developing and deploying machine learning models.
• Knowledge of machine learning engineering practices, including model versioning, deployment, and monitoring.
• Familiarity with machine learning frameworks and libraries (e.g., TensorFlow, PyTorch, Scikit-learn).
• Ability to design and develop scalable data pipelines for batch and real‑time data processing.
• Experience with big data technologies such as Apache Spark, Hadoop, or similar.
• Proficiency in working with structured and unstructured data sources.
• Knowledge of data governance and security best practices.
• Strong understanding of data techniques and best practices.
• Experience with DevOps or MLOps practices for continuous integration and deployment.
• Establish and create scalable and intuitive reporting methodologies through Power BI, suggesting the best representation and visualizations.
• Identify business intelligence needs recommending the best KPIs and customer valuation models and dashboards.
• Interpret data, analyze results, and identify trends or patterns in complex data sets.
• Filter and “clean” data and review computer reports, printouts, and performance indicators to locate and correct data corruption problems.
• Data collection, setting and leveraging DMP and CDP-based infrastructures, attribution modeling, A/B & multivariate testing, and dynamic creative.
• Develop, evaluate, test, and maintain architectures and data solutions such as ETL Pipelines, Data Warehouses, Data Marts, etc.
• Automate data pipelines and develop automation workflows.
• Develop scalable and intuitive ETL & ELT pipelines from a variety of marketing sources such as Salesforce, Adobe Analytics, etc.
• Identify data sources and create data pipelines using shell scripts or Python scripts.
• Create technical documentation.
• Plan data analysis work and develop execution estimates, continuously improving the accuracy of the estimates.
• Develop Customer View stitching 1P data from various data sources.

Mars United Commerce is an Equal Opportunity Employer and will recruit, hire, train and promote persons in all job classifications without regard to race, ancestry, creed, color, sexual orientation, gender identity, age, national origin, disability or handicap, HIV, veteran, marital or family status, or any other status or condition protected by applicable state and/or federal laws, except where a bonafide occupational qualification applies.

Mars United Commerce has developed a wide variety of inclusive benefit plans and policies that address and promote the needs of all employees and their family members, including comprehensive group health plans, a parental leave program that includes paid maternity and paternity benefits for pregnancy, adoption and surrogacy, flexible paid time off, a broad and confidential employee assistance program, ongoing wellness support initiatives, trusted financial health advice and guidance, promotion of education through tuition support and assistance, and a flexible and supportive work environment and culture.

Compensation Range: $72,390 - $90,440 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third‑party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be November 30, 2025.