Marketing Data Analyst (12 month contract)

Marketing Data Analyst (12 month contract) page is loaded

Marketing Data Analyst (12 month contract)

Apply locations Toronto, Ontario, Canada time type Full time posted on Posted 2 Days Ago job requisition id JR101599

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

• learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growth

• 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 (e.g., 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

About Us

About HOOPP

Established in 1960, the Healthcare of Ontario Pension Plan (HOOPP) is a multi-employer defined benefit pension plan for Ontario's hospital and community-based healthcare sector. We serve more than 460,000 members who provide valued healthcare services at more than 670 employers across the province. At HOOPP, we exist to provide a stable and reliable pension for our members that starts in retirement and is paid for life. As one of Canada's largest and most respected pension plans, HOOPP's net assets reached $112.6 billion at the end of 2023 and our funded status remained strong and stable at 115%.

HOOPP's core values - professional, accountable, collaborative, compassionate and trustworthy - guide our every interaction with our members, employers and employees. We've become one of Canada's leading pension plans by consistently challenging ourselves and embracing innovation. From our unique investment management approach to our innovative technology and thought-provoking research, we constantly seek to push the boundaries, and we do this by hiring passionate, forward-thinking people.

Our high-performance culture is founded on collaboration, respect and belonging. HOOPP is an equal opportunity employer and we're proud of our diversity. We select applicants for employment solely on the basis of their qualifications. Should you require accommodation because of a disability during the recruitment and selection process, please contact our Human Resources team. We will be happy to consult with you so that arrangements can be made for reasonable accommodation.

#J-18808-Ljbffr