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
Accountant (12-Month Contract)
We are seeking a detail-oriented and experienced Accountant to join our team on a 12-month contract basis, with the possibility of extension to 18 months. The Accountant will be responsible for managing month-end close procedures, reconciling accounts, overseeing accounts receivable and accounts pay...
Data Integrity Governance Coordinator (12-Month Contract)
The contract is anticipated to last 12-months with a possibility of extension. We are looking to have a Data Integrity Governance Coordinator join our team on contract. Proactively improve data quality (accuracy and integrity) in partnership with data owners and concerned parties. Develop and provid...
Analyst, Technology Support (12-Month Contract)
The IT Support Associate is responsible for providing first-rate technical support to our executives, stakeholders, and retail stores.This role is crucial in ensuring the seamless operation of daily technology needs and managing the onboarding and offboarding processes effectively.The associate will...
Quality Analyst, Risk Management (12 Months Contract)
Since CDS and CDCC were designated as systemically important by the Bank of Canada in 2012, the Post Trade risk management team’s role is to ensure the integrity and stability of the markets that it supports. Reporting to the Director - Financial Risk Management, the Risk Quality Analyst is an integ...
Accounting Assistant - 12-18 Month Contract
Process a high volume of accounts payable invoices on a daily basis.Maintain the general ledger with a high degree of accuracy .Follow up with customers on overdue payments.Match invoices to purchase orders.Assist with ad-hoc accounting tasks as needed.Accounts Payable/Receivable and General Account...
Servicing Administrator, Residential Services (12-month contract)
Servicing Administrator, Residential Services (12-month contract). ...
Business Analyst (14-month contract)
Business Analyst (14-month contract). You will work collaboratively with other analysts, developers, and leaders at all levels, supporting the product development process. Provide customer and product insights to internal data professionals, engineers, and developers responsible for designing, build...
Human Resources Assistant (Temporary Contract - 12 months)
HUMAN RESOURCES ASSISTANT Please note: This is a temporary contract 12 month contact position. ExperienceMinimum of 2 years experience with the following: customer service environment computer experience preferably with a Human Resource Information System (HRIS) working in administrative support pos...
Accounts Payable Specialist - 12 Month Contract
This is a contract position for 12 months. You will have the confidence to own these responsibilities and ensure that the full A/P cycle is completed each month. Accurate data entry and posting of high-volume invoices (i. Monthly general ledger and subledger reconciliation. ...
User Experience Designer (12 Month Contract)
Participate in user research activities, including, interviews, surveys, prototype testing and data analysis. Collaboration with Product Managers, Web and Mobile Developers and QA Analysts to deliver the planned user experience. ...