Marketing Data Analyst

2 months ago

Toronto, Ontario, Canada Healthcare of Ontario Pension Plan Full time

About Us

The Healthcare of Ontario Pension Plan (HOOPP) is a leading pension plan in Canada, dedicated to providing a 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.

Key Responsibilities

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

Requirements

  • 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

  • Data Support Analyst

    4 weeks ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Data Support AnalystWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing data support and analysis to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test...

  • Data Support Analyst

    4 weeks ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Data Support AnalystWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing data support and analysis to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Data Support AnalystWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing data support and analysis to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test...

  • Data Analyst

    3 weeks ago

    Toronto, Ontario, Canada Data Privacy Full time

    Finance Data Analyst RoleRBC's Wholesale Finance Data Strategy team is seeking a skilled Data Analyst to join their team. As a key member of the team, you will play a crucial role in exploring and operationalizing big data sources to provide valuable insights and contribute to the team's objectives.Key Responsibilities:Develop predictive data models and...

  • Data Analyst

    3 weeks ago

    Toronto, Ontario, Canada Data Privacy Full time

    Finance Data Analyst RoleRBC's Wholesale Finance Data Strategy team is seeking a skilled Data Analyst to join their team. As a key member of the team, you will play a crucial role in exploring and operationalizing big data sources to provide valuable insights and contribute to the team's objectives.Key Responsibilities:Develop predictive data models and...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    About the RoleWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a key member of our data operations team, you will play a critical role in providing exceptional support to our clients and driving business growth.Key ResponsibilitiesGenerate monthly reports and maintain data quality in MS Access and SQL ServerDevelop...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    About the RoleWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a key member of our data operations team, you will play a critical role in providing exceptional support to our clients and driving business growth.Key ResponsibilitiesGenerate monthly reports and maintain data quality in MS Access and SQL ServerDevelop...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job DescriptionWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing data analysis and support to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test routines, queries,...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job DescriptionWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing quality data service and support to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test routines,...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job DescriptionWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing data analysis and support to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test routines, queries,...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job DescriptionWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing quality data service and support to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test routines,...

  • Data Support Analyst

    3 weeks ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job DescriptionWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing quality data service and support to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test routines,...

  • Data Support Analyst

    3 weeks ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job DescriptionWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will play a critical role in providing quality data service and support to our clients.Key Responsibilities:Generate monthly reports and maintain report templatesCreate and modify process documentsDevelop and test routines,...

  • Data Support Analyst

    4 weeks ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Junior Data Support Analyst-1-Year ContractWe are seeking a highly skilled and motivated Junior Data Support Analyst to join our team at CMG Marketing. As a key member of our data support team, you will be responsible for providing exceptional data analysis and support services to our clients.Key Responsibilities:Generate monthly reports and...

  • Data Support Analyst

    4 weeks ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Junior Data Support Analyst-1-Year ContractWe are seeking a highly skilled and motivated Junior Data Support Analyst to join our team at CMG Marketing. As a key member of our data support team, you will be responsible for providing exceptional data analysis and support services to our clients.Key Responsibilities:Generate monthly reports and...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Junior Data Support AnalystWe are seeking a highly skilled and motivated Junior Data Support Analyst to join our team at CMG Marketing. As a key member of our data operations team, you will be responsible for providing support to our business analysis, records management, and data operations functions.Key Responsibilities:Generate monthly reports...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Junior Data Support AnalystWe are seeking a highly skilled and motivated Junior Data Support Analyst to join our team at CMG Marketing. As a key member of our data operations team, you will be responsible for providing support to our business analysis, records management, and data operations functions.Key Responsibilities:Generate monthly reports...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Data Support AnalystWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will be responsible for providing support to business analysis, records management, and data operations through queries, report, and application design and maintenance in MS products including Excel, CRM 2011,...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Data Support AnalystWe are seeking a highly skilled Data Support Analyst to join our team at CMG Marketing. As a Data Support Analyst, you will be responsible for providing support to business analysis, records management, and data operations through queries, report, and application design and maintenance in MS products including Excel, CRM 2011,...

  • Data Support Analyst

    1 month ago

    Toronto, Ontario, Canada CMG Marketing Full time

    Job Title: Junior Data Support Analyst-1-Year ContractWe are seeking a highly skilled and motivated Junior Data Support Analyst to join our team on a 1-year contract basis. As a key member of our data support team, you will be responsible for providing exceptional data analysis and support services to our clients.Key Responsibilities:Generate monthly reports...