AED Data Analyst

Organization:
AED Foundation of Ontario

Location:
Hybrid, within Toronto, ON

Contract Type:
Short-term contract (3–6 months, renewable)

Reports To:
CEO (with day-to-day coordination by the Program/Data Lead)

Compensation:
Competitive; commensurate with experience

Start Date:
Immediate

Position Summary

The
AED Data Analyst & Salesforce Integration Specialist
is responsible for cleaning,

verifying, and consolidating AED registry data to support Salesforce implementation. The

contractor will analyze multiple datasets, identify and resolve missing information through web

research, email, and phone outreach, and prepare validated, structured files ready for Salesforce

ingestion.

This position combines
data management, research, and CRM integration expertise
to

ensure the AED Foundation of Ontario maintains a high-quality, complete, and reliable registry

of AED locations across the province.

Key Responsibilities

1.
Data Profiling & Planning

• Audit current AED datasets from spreadsheets, forms, and legacy systems.
• Create a 
  Data Profile Report
   summarizing data quality, duplicates, and missing fields.
• Define required vs. optional data fields for Salesforce import.

2.
Data Cleansing & Standardization

• Merge and standardize multiple datasets into one cohesive master file.
• Normalize facility names, addresses (Canada Post format), and phone numbers.
• Apply consistent data formats: dates (YYYY-MM-DD), postal codes, booleans, and picklists.
• Identify and remove duplicates using deterministic and fuzzy matching techniques.

3.
Data Enrichment & Verification

• Conduct web-based research and use phone/email outreach to confirm or complete missing information (e.g., AED model, serial number, cabinet location, contact person).
• Maintain an
   Outreach Log 
  documenting each contact attempt and outcome.
• Ensure all outreach complies with PIPEDA and CASL guidelines.

4.
Salesforce Preparation & Import

• Map data fields to the Salesforce ingestion template (Accounts, Contacts, Sites, Assets, Maintenance).
• Generate clean, validated CSVs with 
  External IDs
   and referential integrity.
• Conduct test imports (sandbox or validation tools) and resolve any data errors.
• Deliver a
   Data Dictionary
   and
   Import Runbook 
  for ongoing maintenance.

5.
Reporting, Documentation & Handover

• Maintain detailed documentation of all data sources, transformation logic, and field mappings.
• Conduct quality assurance (QA) checks and deliver a 
  Final QA Report 
  summarizing data completeness and accuracy.
• Provide a short 
  training session 
  and
   SOP documentation 
  for future internal data updates.

Required Skills & Qualifications

• Expert proficiency in Microsoft Excel
   (formulas, lookups, pivot tables, conditional formatting, macros).
• 2–5+ years of experience in 
  data cleansing, enrichment, or CRM migrations.
• Strong understanding of 
  Salesforce data import processes
   (Data Import Wizard or Data Loader).
• Excellent analytical and problem-solving skills; meticulous attention to detail.
• Professional communication skills for web/email/phone verification.
• Proven ability to meet tight deadlines while maintaining high data quality.
• Knowledge of 
  Canadian privacy and data protection standards 
  (PIPEDA, CASL).
• Bachelor's degree or diploma in 
  Data Management, Information Systems, or Business Analytics
   (or equivalent experience).

Preferred:

• Experience with EMS, public health, or nonprofit registry data.
• Familiarity with address geocoding and mapping tools.
• Working knowledge of SQL, Python (pandas), or Power Query.
• Bilingual (English/French) communication ability.

Contract Details

• Type:
   Independent Contractor (project-based)
• Duration:
   3–6 months (renewable based on project needs)
• Hours:
  Flexible; full-time or part-time depending on workload
• Compensation:
  Competitive; commensurate with experience
• Location:
   Hybrid, within Toronto, ON

AED Foundation Ontario is an equal opportunity employer.

Send a resume with cover letter to

Only applicants selected for an interview will be contacted.