Marketing Data Analyst (12 month contract)

Why You'll Love Working Here

At HOOPP, we pride ourselves on fostering a high-performance, people-focused culture. Our commitment to equity, diversity, and inclusion is fundamental to our work environment and business success. This helps our employees feel valued and empowered to be their authentic selves.

You'll benefit from:

• Comprehensive learning and development initiatives, including workshops, Speaker Series events, and access to LinkedIn Learning to support your career growth.
• Membership in HOOPP’s world-class defined benefit pension plan, offering crucial retirement security.
• Competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting diversity and mental health.
• Optional post-retirement health and dental benefits, subsidized at 50%.
• Wellness activities such as yoga classes, meditation workshops, nutritional consultations, and wellness seminars.
• Access to an annual wellness reimbursement program for health and wellness-related expenses for both permanent and temporary employees.
• The opportunity to make a difference by helping provide a financially secure retirement for Ontario healthcare workers.

Job Summary: Marketing Data Analyst (12 Month Contract)

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 role, you will handle various data processes, including extraction, cleaning, preparation, and validation of complex data sets to support comprehensive reporting. Additionally, you will build data models and pipelines, create advanced dashboards and visualizations, and develop SQL scripts to deliver meaningful insights. You will 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 to provide meaningful insights.
• Create and maintain data models to ensure data consistency, accuracy, and accessibility.
• Provide ad-hoc reporting support to diverse stakeholders.
• Develop and maintain documentation for data infrastructure, 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 centralization initiatives.
• Design, develop, and deploy Power BI scripts and perform analysis that aids decision-making.
• Create complex SQL queries and optimize slow-running queries, leveraging T-SQL data structures to complement report development.
• Troubleshoot 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 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.
• Preferred Microsoft Data and/or BI certifications.
• 3-5 years of experience in data analytics.
• 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 Power BI, Tableau, or similar; performance optimization tuning for Power BI.
• Strong experience with data manipulation and visualization languages such as T-S