Data Analytics Intern

Job Description

KEY RESPONSIBILITIES

• Clean, upload, and maintain data in Google Sheets and Salesforce on a weekly basis;
• Generate insightful data visualizations and/or an interactive dashboard from existing data to illustrate trends and key insights using Microsoft PowerBI and/or Google Sheets;
• Assist with diagnosing and maintaining Python data scraping algorithms using Github actions via Scrapy and/or BeautifulSoup;
• Conduct comprehensive data analysis of the provided dataset, extracting and identifying key patterns;
• Assisting with automation workflows where needed using Salesforce automation tools and Zapier;
• Develop ad-hoc data analytics reports in Google Sheets; and,
• Other duties as assigned.

SUCCESS MEASURES

• A strong ETL execution for Salesforce through an integration with Google Suite and/or Microsoft Office Suite;
• Analysis of trends in Ontario’s AI talent community with existing data and providing decision-making supports on engagement in AI talent community;
• Reports generated on high-level insights; and,
• Data visualizations/interactive dashboard created are accessible, with key outcomes highlighted, and integrated well with data inputs.

PROFILE OF THE IDEAL CANDIDATE

• You are a self-identified Black or Indigenous student or postdoc (Indigenous ancestry or heritage – First Nations (status or non-status), Métis or Inuit) or a recent graduate.
• You are in the second year or higher, studying at a Canadian university or college, or a recent graduate within 1 semester of graduation.
• You have experience using Google Suite (e.g., Google Sheets, Google Drive), Excel and its advanced functions, and data visualization tools such as Power BI or Tableau.
• You have experience managing CRM systems such as Salesforce and are able to perform Extract Transform Load (ETL) processes on large datasets.
• You have basic proficiency with programming languages, especially Python. Experience with Scrapy/BeautifulSoup is an asset.
• You have experience translating large datasets into actionable insights.
• You understand the limits and constraints associated with data usage (e.g., privacy concerns, challenges associated with unstructured data or unlabelled data).
• You are organized and efficient, with strong problem-solving skills.

NICE TO HAVE

• You have experience with automation tools such as Zapier and triggered workflows in Salesforce.
• You are motivated by continuous learning and the opportunity to make a real and meaningful contribution to the AI ecosystem.
• You are creative and enjoy collaborating within a small entrepreneurial environment that is results-driven.
• You possess integrity, a positive attitude, sense of humour, and can bring an optimistic energy and outlook to a not-for-profit corporate culture.

Please address applications (cover letter and resume) to Taylor Walker, Manager, AI Talent Initiatives, Early Talent, using the link provided. The deadline for submission is September 22, at 1:00PM ET. We thank all applicants for their interest in this exciting opportunity and will be in touch with those whose qualifications most closely match with our needs. Please note that all interviews are currently being held remotely.