Data Analyst

5 months ago


Ontario, Canada The Association of Faculties of Medicine of Canada Full time

**Position**: Data Analyst - One year term position with possibility of extension

**Reports to**: Manager, CAPER & Data Analysis

**Starting Salary**: $57,000 - $67,000

**Location**: Fully Remote within Canada

Come join the AFMC team, where innovation in medical education meets a flexible and supportive work environment We're proud to offer a remote work setting that not only allows you to contribute from the comfort of your home but also promotes work-life balance through a 35-hour workweek and flexible scheduling options. In addition to an empowering and collaborative culture, AFMC provides an excellent benefits package, ensuring your well-being is our priority. And let's not forget about the future: we offer a defined benefit pension program through HOOPP, setting you on the path towards financial security in your retirement years. Experience the unique blend of purposeful work and quality of life at AFMC

**Job Summary**:
As part of the AFMC Data and Analysis team, the Data Analyst is responsible for data collection and reporting of information on the Academic Medicine system in Canada.

**Your role as a Data Analyst will focus on one or more of**: Reporting, Collection, or Management and Analysis.

Reporting (Essential)
- Prepare (using SQL, Python, PowerBi or similar tools) and present research analyses, reports, and other communication materials in a clear manner adapted to the audience;
- Review results, query and resolve anomalies enter in database, prepare tables for publication;
- Prepare / type set annual publication for hard copy publication and electronic distribution, including:

- Biomedical & Health Care Research Revenue Survey;
- AFMC Annual Faculty of Medicine Survey;
- Admission Requirements of Canadian Faculties of Medicine;
- Annual Financial Questionnaire;
- Graduation Questionnaire; and
- Applicant Diversity Survey.

Data Administration and Analysis (recommended)
- Manage research databases, including writing and maintaining Azure SQL database objects and/or data manipulation scripts for:

- Extract, Transform and Load (ETL) processes;
- Data management;
- Cross database aggregation;
- Cross database linking and matching;
- Quality assurance;
- Respond to ad-hoc data requests from internal and external clients.

Data Collection
- Develop, implement, test and deploy complex online surveys;
- Create or modify new Data Collection Instruments (DCI) as needed;
- Prepare, distribute and collect annual data via online surveys, data collection instruments (DCI), or data exchange/interfaces; and
- Interact and work efficiently with committee members from all faculties of medicine across Canada.

Additional Duties
- Develop and monitor project timelines and deliverables on an ongoing basis;
- Ongoing development of AFMC data collection tools and systems;
- Participate in new data development initiatives;
- Contribute to team projects and meetings;
- Adhere to high standards of data privacy, confidentiality and quality; and
- Other duties as assigned.

**Direct Reports**:

- None

**Education/Certification/Experience**:

- Post-secondary degree in Data Science (essential)
- Demonstrated experience using Python (essential) with Pandas Library (recommended)
- Demonstrated experience with data visualization tools like PowerBI to generate reports (essential).
- Demonstrated experience in Reporting and at least one of the areas above (Data Collection or Data Management and Analysis) additional experience beyond to machine learning techniques, model development and feature engineering (asset)
- Demonstrated experience in creating Microsoft SQL/Azure views and stored procedures
- Demonstrated ability to explain technical issues to non-technical end users

**Language Skills**:

- Bilingual in English in French (Asset)
- Ability to respond effectively to the most sensitive inquiries or complaints in both languages.

**Physical Demands**:
While fulfilling job responsibilities, this role requires flexibility to work in different environments, including a remote home office setup, occasional travel, and participation in in-person meetings. Due to these demands, the employee will typically engage in the following activities:

- Extended periods of sitting, often at a computer workstation.
- Occasional walking or movement within the home office environment, at travel locations, or during in-person meetings.
- Occasional lifting and relocation of objects weighing up to 20 pounds, primarily when traveling or setting up for in-person events.
- Flexibility in work hours, including the potential for occasional overtime, to meet project deadlines, especially when coordinating with different time zones or during travel.

**Application Process**:
The AFMC is committed to the principles of equity, diversity, inclusion and belongingness in our operations and throughout our work environments and seek to employ individuals who share a commitment to promote and practice these principles. We believe in and promote th


  • Business analyst

    2 days ago


    Ontario, Canada Business Analyst Computer Systems Full time

    Overview Languages: English Education: Bachelor's degree Experience: 1 year to less than 2 years On site Work must be completed at the physical location. There is no option to work remotely. Responsibilities:Design, develop and implement information systems business solutions.Assess physical and technical security risks to data, software and...

  • Data Analyst

    4 months ago


    Ontario, Canada MASS (Marketing Automation Service and Support) Full time

    *** As a Data Analyst, you become an essential player in meeting client data requirements. Utilizing cutting-edge analytics tools and methodologies, you'll be at the forefront of translating raw data into actionable insights. Your commitment to transforming complex data into clear, goal-oriented reports will drive continuous innovation and propel growth....

  • Data Analyst

    5 months ago


    Ontario, Canada Insticator Inc Full time

    **About Insticator** At Insticator, we believe that the future of social media is distributed, rather than siloed in walled gardens like Facebook, Instagram, and TikTok. Unlike most ad tech networks in the space, Insticator is built to optimize the publisher experience. We’re on a mission to create a smart and unified platform that will collect,...

  • Data Analyst

    1 month ago


    London, Ontario, Middlesex, Canada MacDonald Search Group Full time

    Our client, a fast-growing producer of spirit-based beverages is seeking a data analyst. This candidate will work with the executive team, regional management and sales representatives across Canada preparing detailed analysis of sales, inventory data and other reports as required. The primary focus of this position is collecting, inputting, and analyzing...


  • Toronto, Ontario, Ontario, Canada EQ Bank | Equitable Bank Full time

    We are seeking a detail-oriented Data Quality Analyst to join our team. The successful candidate will be responsible for investigating Excel data quality reports, writing basic SQL queries, and utilizing the PPLUS environment to ensure data integrity and accuracy. This role requires a strong analytical mindset, excellent problem-solving skills, and a keen...

  • Senior Data Analyst

    4 weeks ago


    Toronto, Ontario, Ontario, Canada TekRek Full time

    Company Background:TekRek is assisting our client partner to recruit an experienced Senior Data Analyst (6 - Month Contract) in Toronto. Our client is a growth stage Fintech business working with cutting edge technology. Job Description:As a data analyst you will be responsible for developing a clear and concise data analysis in partnership with various...

  • Senior Data Analyst

    1 month ago


    Eastern Ontario, Canada Zynga Full time

    Unlock the Power of Data with ZyngaAs a Senior Data Analyst at Zynga, you'll play a crucial role in driving business decisions with data-driven insights. Our iconic casual games have captivated millions of players worldwide, and we're looking for a talented individual to join our team and contribute to the success of our games.Main...

  • Senior Data Analyst

    1 month ago


    Eastern Ontario, Canada Zynga Full time

    Unlock the Power of Data with ZyngaAs a Senior Data Analyst at Zynga, you'll play a crucial role in driving business decisions with data-driven insights. Our iconic casual games have captivated millions of players worldwide, and we're looking for a talented individual to join our team and contribute to the success of our games.Main...


  • Toronto, Ontario, Ontario, Canada Apex Systems Full time

    Business Systems Analyst - Data Management About the Role:We are seeking a highly skilled Business Systems Analyst to join our team and play a pivotal role in driving data-driven decision-making. The ideal candidate will have a strong foundation in data mapping, access knowledge, and a proven track record in managing the full data...

  • Data Analyst

    1 month ago


    Markham, Ontario, York region, Canada EDAC Connectors Full time

    Overview:We are seeking a skilled and detail-oriented Data Analyst with additional responsibilities in dataintegration and product data syndication to join our team. This role will combine data analysis,business intelligence development, and data flow management to support our businessinitiatives and enhance decision-making processes.Key...

  • Senior Data Analyst

    1 month ago


    Eastern Ontario, Canada Zynga Full time

    Unlock the Power of Data with ZyngaAs a Senior Data Analyst at Zynga, you'll play a crucial role in driving business decisions with data-driven insights. Our iconic casual games have captivated millions of players worldwide, and we're looking for a talented individual to join our team and contribute to our success.Main ResponsibilitiesCollaborate with...

  • Senior Data Analyst

    1 month ago


    Eastern Ontario, Canada Zynga Full time

    Unlock the Power of Data with ZyngaAs a Senior Data Analyst at Zynga, you'll play a crucial role in driving business decisions with data-driven insights. Our iconic casual games have captivated millions of players worldwide, and we're looking for a talented individual to join our team and contribute to our success.Main ResponsibilitiesCollaborate with...

  • Data Analyst

    1 month ago


    Mississauga, Ontario, Peel region, Canada Tata Consultancy Services Full time

    About TCS:Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...

  • Data Analyst

    1 month ago


    Mississauga, Ontario, Peel region, Canada Tata Consultancy Services Full time

    About TCS:Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...

  • Data Analyst

    4 days ago


    Mississauga, Ontario, Peel region, Canada Tata Consultancy Services Full time

    About TCS:Tata Consultancy Services is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive powered portfolio of business, technology, and engineering services and solutions is delivered through...

  • Business Analyst

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Cititec Talent Full time

    Business Analyst – Compliance, Regulatory & Data | Circa $110k | Toronto (Fully remote, until early next year)Cititec Talent is partnering with a leading global commodities firm that is looking to hire a Business Analyst with expertise in compliance and regulatory reporting, specifically within the commodities trading sector. This role is crucial for...

  • Data System Analyst

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Agilus Work Solutions Full time

    Data System Analyst - IntermediateAgilus' client is a National Leader providing health and dental insurance for 1000's of Canadians. We are currently helping them add project support to their team for an ongoing project:In this role you will provide:Understanding of data governance principals.Metadata analysis and taggingMicrosoft products excel,...

  • Data Analyst

    4 days ago


    Toronto, Ontario, Ontario, Canada Astek Full time

    The Astek GroupFounded in France in 1988, Astek is a global player in engineering and technology consulting. With its expertise in various industrial and tertiary sectors, Astek supports its international clients in the intelligent deployment of their products and services, as well as in the implementation of their digital transformation.Since its inception,...


  • Toronto, Ontario, Ontario, Canada VLink Inc Full time

    Job Title: Business Analyst Location: Toronto, ON Employment Type: (Full-time or contract)Duration: FTE About VLink: Started in 2006 and headquartered in Connecticut, VLink is one of the fastest growing digital technology services and consulting companies. Since its inception, our innovative team members have been solving the most complex business, and IT...

  • Senior Data Analyst

    4 weeks ago


    Toronto, Ontario, Ontario, Canada Luxoft Full time

    Project descriptionReporting to the Director, Business Intelligence, Performance Systems and Analytics, this position will be responsible for a broad range of activities affecting all groups within the Investment Reporting, Data Governance & Valuations. This will require an understanding of Investment Products & Strategies, Investment Reporting, Processes,...