Marketing Data Analyst (12 month contract)

Why you’ll love working here :

high-performance, people-focused culture

our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves

membership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement security

competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, and newly extended maternity / parental leave top of 26 weeks)

optional post-retirement health and dental benefits subsidized at 50%

yoga classes, meditation workshops, nutritional consultations, and wellness seminars

access to an annual wellness reimbursement program for health and wellness-related expenses for permanent and temporary employees

the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Job Summary

We are seeking a detail-oriented and versatile Data Analyst to join our Marketing Analytics function to enhance our data management and analytics capabilities.

In this position, you will be responsible for handling a variety of data processes including extraction, cleaning, preparation, and validation of complex data sets to support comprehensive reporting.

You will build data models and pipelines, advanced dashboards and visualizations, and SQL scripts to deliver meaningful insights, and assist IT in meeting the function’s short- and long-term data analytics needs.

If you are passionate about solving complex problems through analytical thinking and enjoy working with both technical and non-technical teams, we encourage you to apply for this role.

What you will do :

Assist in the collection, cleaning, and preparation of data from diverse sources for reporting purposes

Develop advanced dashboards and visualizations using data from different sources to provide meaningful insights

Create and maintain data models that ensures data consistency, accuracy, and accessibility

Provide ad-hoc reporting support to diverse stakeholders

Develop and maintain documentation for data infrastructure and data governance and actively monitor and execute data governance controls

Develop and document business processes and workflows for data preparation and marketing analytics processes

Collaborate with other departments and data vendors to coordinate data automation and data centralization initiatives

Design, develop, and deploy Power BI scripts and perform analysis that can help in decision-making

Create complex SQL queries, perform optimization of slow running queries incl. leveraging T-SQL data structures to complement report development

Trouble shoot and optimize Power BI and SQL Server report-based data solutions

Design, build, and maintain data pipelines and workflows that extract, transform, and load data from various sources into our data warehouse

Maintain, integrate, and update data sources to ensure data quality and accuracy

Develop and implement data integrity checks and processes, investigate, and resolve data quality issues

Structure the collected data into a well-organized format, creating metadata, and maintain a data catalog for easy access and discoverability

Implement and test new analytics tracking requirements for new elements and features on our digital properties

Maintain and optimize data analytics tools and platforms

Stay up-to-date with emerging trends and technologies in marketing analytics, machine learning and automation

Apply AI and machine learning concepts in relation to data and analytics initiatives

What you will bring :

Bachelor’s degree in computer science, mathematics, or a related field

Microsoft Data and / or BI certifications preferred

3-5 years of experience in data analytics preferred

Experience with data platforms such as GCP (as a BigQuery Viewer), Data Bricks and / or Snowflake

Experience with data Ingestion using Synapse Pipelines and / or Azure Data Factory

Intermediate level BI dashboarding and visualization experience with tools such as PowerBI, Tableau or similar; performance optimization tuning for Power BI

Strong experience with data manipulation and visualization languages such as T-SQL, DML, DDL, DAX, Python and / or R

Knowledge of data analysis, visualization principles, data modeling techniques and best practices

Experience developing data governance best practices, processes, and standards

Experience creating and documenting end-to-end reporting, data processes and ETL

Experience in managing digital marketing and web analytics platforms such as Google Analytics 4 (incl. building reports, dimensions, and calculated metrics) and Google Tag Manager

Empathetic, humble, and collaborative mindset with the ability to work well with both technical and non-technical teams

Ability to work closely with cross-functional teams, including developers, business analysts, and stakeholders

Strong communication skills, capable of presenting data insights to non-technical stakeholders in a clear and concise manner

Strong problem-solving and analytical skills

Ability to work independently and as part of a team