Data Analyst (Senior Level)

Pay Rate: (flexible)

Location: Toronto ON

Contract Length:6 months

Work Type: Hybrid

Key Responsibilities

- Perform data profiling, mapping, transformation, cleansing, and validation.
- Conduct exploratory data analysis to identify trends, anomalies, and quality issues.
- Produce Data Profiling Reports and Legacy Landscape Reports.
- Collaborate with Business Systems Analysts to define data and reporting requirements.
- Develop conceptual data models and data flows.
- Design and execute ETL processes and data migration activities.
- Ensure data integrity and implement data quality controls.
- Support vendor fit-gap analysis activities.
- Perform root cause analysis and resolve data issues.
- Develop scripts and workflows for data automation and reconciliation.
- Validate migrated data for completeness and accuracy.
- Participate in Data Quality Assurance activities.
- Contribute to data architecture discussions.
- Create Entity Relationship Diagrams (ERDs) using UML/BPMN.
- Support procurement and implementation of COTS solutions.
- Perform additional project-related duties as required.

Required Qualifications

- University degree in Computer Science, Data Science, Information Systems, or related field.
- 7+ years of experience on large-scale IT projects.
- 7+ years of experience in data migration involving legacy systems transitioning to COTS platforms.
- Extensive experience in:
- Data profiling
- Data mapping
- Data transformation
- Data validation

- 5+ years of hands‑on SQL experience.




- 5+ years of ETL design and execution experience.
- Robust understanding of:

- Data Governance
- Data Quality
- Data Integrity

- Experience working on modernization projects within government or public sector organizations.
- Excellent communication and stakeholder management skills.

Technical Skills

- SQL
- ETL Development
- Data Migration
- Data Profiling
- Data Mapping
- Data Quality Management
- Data Validation
- Data Governance
- UML
- BPMN
- Entity Relationship Diagrams (ERD)
- Metadata Documentation
- Legacy System Modernization
- COTS Implementations

Nice to Have

Experience supporting:

- Accessibility for Ontarians with Disabilities Act (AODA)
- Security Threat Risk Assessment (STRA)
- Privacy Impact Assessment (PIA)

Deliverables

- Data Profiling Report
- Data Quality Assessment Report
- Data Mapping Documents
- Metadata Documentation
- ETL Specifications
- ETL Scripts
- Dashboards and Presentations
- Knowledge Transfer Documentation
- Data Migration Strategy

We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

We have a dedicated webpage for accommodations where you can learn more about what we offer, and request accommodation:

#J-18808-Ljbffr

📌 Data Analyst (Senior Level) (Toronto)
🏢 Raise
📍 Toronto