Data Analyst

2 months ago

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

About the Role

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 Analyst

    1 month ago

    Toronto, Ontario, Canada ECF Data, LLC Full time

    Job Title: Data AnalystCPA Ontario is seeking a highly skilled Data Analyst to join their Enterprise Architecture team. As a Data Analyst, you will collaborate with cross-functional departments to provide actionable insights and drive business decisions.Key Responsibilities:Work with IT, Business Intelligence, and Finance departments to translate business...

  • Data Analyst

    1 month ago

    Toronto, Ontario, Canada ECF Data, LLC Full time

    Job Title: Data AnalystCPA Ontario is seeking a highly skilled Data Analyst to join their Enterprise Architecture team. As a Data Analyst, you will collaborate with cross-functional departments to provide actionable insights and drive business decisions.Key Responsibilities:Work with IT, Business Intelligence, and Finance departments to translate business...

  • Data Analyst

    1 month ago

    Toronto, Ontario, Canada ECF Data, LLC Full time

    Unlock Your Potential as a Data AnalystAt ECF Data, LLC, we're committed to creating an inclusive and supportive work environment that empowers neurodivergent individuals to thrive. As a Data Analyst, you'll play a vital role in helping us achieve this goal.Key Responsibilities:Conduct ongoing process reviews to identify and resolve issues, ensuring seamless...

  • Data Analyst

    1 month ago

    Toronto, Ontario, Canada ECF Data, LLC Full time

    Unlock Your Potential as a Data AnalystAt ECF Data, LLC, we're committed to creating an inclusive and supportive work environment that empowers neurodivergent individuals to thrive. As a Data Analyst, you'll play a vital role in helping us achieve this goal.Key Responsibilities:Conduct ongoing process reviews to identify and resolve issues, ensuring seamless...

  • Data Analyst

    1 month 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

    1 month 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

    2 months ago

    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    About the RoleECF Data, LLC is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a critical role in providing actionable insights to support business decision-making.Key ResponsibilitiesData Extraction and Analysis: Extract, clean, and manipulate large datasets from various sources to identify trends and opportunities...

  • Data Analyst

    2 months ago

    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    About the RoleECF Data, LLC is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a critical role in providing actionable insights to support business decision-making.Key ResponsibilitiesData Extraction and Analysis: Extract, clean, and manipulate large datasets from various sources to identify trends and opportunities...

  • Data Analyst

    2 months ago

    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    Enterprise Architecture Team - Data AnalystCPA Ontario is seeking a highly skilled Data Analyst to join their Enterprise Architecture team. As a key member of the team, you will collaborate with cross-functional departments to provide actionable insights and drive business decisions.Key Responsibilities:Work closely with IT, Business Intelligence, and...

  • Data Analyst

    2 months ago

    Old Toronto, Ontario, Canada ECF Data, LLC Full time

    Enterprise Architecture Team - Data AnalystCPA Ontario is seeking a highly skilled Data Analyst to join their Enterprise Architecture team. As a key member of the team, you will collaborate with cross-functional departments to provide actionable insights and drive business decisions.Key Responsibilities:Work closely with IT, Business Intelligence, and...

  • Data Analyst

    4 weeks ago

    Toronto, Ontario, Canada Data Privacy Full time

    Unlock the Power of Data in Wholesale FinanceRBC's Wholesale Finance Data Strategy team is seeking a skilled Data Analyst to join their ranks. As a key member of the team, you will play a vital role in exploring and operationalizing big data sources to drive business insights and growth.Key Responsibilities:Develop predictive data models and quantitative...

  • Data Analyst

    3 weeks ago

    Toronto, Ontario, Canada ECF Data, LLC Full time

    Job Summary:As a Data Analyst at ECF Data, LLC, you will play a key role in supporting our business growth by providing actionable insights and recommendations. This is an exciting opportunity to work with a talented team and contribute to the success of our organization.Key Responsibilities:• Support ongoing process reviews to identify and resolve...

  • Salesforce Product Analyst

    3 weeks ago

    Toronto, Ontario, Canada NTT DATA Full time

    Job DescriptionReq ID: 286194 NTT DATA Services is seeking a skilled Salesforce Product Analyst to join our team. As a key member of our Agile team, you will play a crucial role in understanding and interpreting customer data to uncover needs and opportunities.This position involves working closely with Product Managers, Product Owners, and cross-functional...

  • Salesforce Product Analyst

    3 weeks ago

    Toronto, Ontario, Canada NTT DATA Full time

    Job DescriptionReq ID: NTT DATA Services is seeking a skilled Salesforce Product Analyst to join our team. As a key member of our product development team, you will play a crucial role in understanding and interpreting customer data to uncover needs and opportunities.This position involves working closely with Product Managers, Product Owners, and...

  • Data Analyst

    4 weeks ago

    Toronto, Ontario, Canada Randstad Canada Full time

    Job Title: Data AnalystWe are seeking a skilled Data Analyst to join our team at Randstad Canada. As a Data Analyst, you will play a key role in analyzing and interpreting complex data to inform business decisions.Responsibilities:Analyze and interpret large datasets to identify trends and insightsDevelop and maintain databases and data systemsCollaborate...

  • Data Analyst

    1 month ago

    Toronto, Ontario, Canada Randstad Full time

    Join Our Team as a Data AnalystWe are seeking a highly skilled Data Analyst to join our Data Service Delivery team. As a Data Analyst, you will play a crucial role in the daily collection, validation, and dissemination of data.Key Responsibilities:Collect and validate data from various sourcesDevelop and maintain data visualizations and reportsCollaborate...

  • Data Analyst

    1 month ago

    Toronto, Ontario, Canada Randstad Full time

    Join Our Team as a Data AnalystWe are seeking a highly skilled Data Analyst to join our Data Service Delivery team. As a Data Analyst, you will play a crucial role in the daily collection, validation, and dissemination of data.Key Responsibilities:Collect and validate data from various sourcesDevelop and maintain data visualizations and reportsCollaborate...

  • Data Analyst

    3 weeks ago

    Toronto, Ontario, Canada BGIS Full time

    Job Title: Data AnalystAt BGIS, we are seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will be responsible for collecting, analyzing, and interpreting complex data to support business decisions.Key Responsibilities:Collect and analyze data from various sources, including design drawings, emails, and Excel documents.Develop and...

  • Data Analyst

    4 weeks ago

    Toronto, Ontario, Canada BGIS Full time

    Job Title: Data AnalystAt BGIS, we are seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will be responsible for collecting, analyzing, and interpreting complex data to support business decisions.Key Responsibilities:Collect and analyze data from various sources, including design drawings, emails, and Excel documents.Develop and...

  • Data Analyst

    2 months ago

    Toronto, Ontario, Canada Microsoft Full time

    Job Title: Data AnalystMicrosoft is seeking a highly skilled Data Analyst to join our team. As a Data Analyst, you will play a critical role in helping us generate key insights on usage, quality, and performance of our experiences.About the RoleWe are looking for a talented individual who can help us empower external and internal developers, admins, business...