Data Analyst/Project Leader
About the role
Overview
We are seeking a Data Analyst / Project Leader to support a housing system modernization initiative involving the migration of data from a legacy HCL Domino (Lotus Notes) system to Yardi / Rent Café. This is a hands-on delivery role, combining data analysis, ETL execution, and project coordination. The successful candidate will take ownership of data mapping, validation, and migration execution, while coordinating across vendors and internal teams. The role includes collaboration with a senior consultant providing project coaching, oversight, and escalation support.
Project Context
This initiative involves: Migration of complex, partially undocumented legacy data Coordination across multiple vendors and internal stakeholders Execution within a time-sensitive and resource-constrained environment Validation of data to ensure accuracy and readiness for system go-live
Key Responsibilities
Data Analysis & Transformation
Analyze extracted data from legacy systems, including complex and undocumented structures Define and document data mappings from source to target system Identify data quality issues and support cleansing and transformation
ETL Configuration & Migration Support
Populate and manage vendor-provided ETL templates Support multiple migration cycles and resolve mapping issues Validate data transformation outputs prior to system load
Data Validation & Reconciliation
Perform field-level validation and reconciliation between source and target data Work closely with business users to confirm data accuracy Identify and resolve discrepancies before final migration
Project Coordination
Coordinate day-to-day migration activities across: Data extraction vendor System vendor Internal business and IT teams Track tasks, risks, and dependencies Ensure timelines are maintained and issues are escalated
Migration Planning Support
Support development and execution of a detailed migration plan Assist in sequencing: Extraction Mapping and transformation Testing cycles Go-live preparation Identify risks and contribute to mitigation planning
Collaboration & Reporting
Work with a senior consultant providing oversight and coaching Participate in structured decision-making and documentation Communicate progress, issues, and recommendations clearly
Required Experience
Strong experience in: Data analysis and transformation, ETL-based data migration Experience working with complex or poorly documented data sources Ability to interpret data structures and resolve inconsistencies Experience coordinating work across multiple teams or stakeholders
Preferred Experience
Exposure to: HCL Domino / Lotus Notes, Yardi Rent Café Experience in: System implementations or data migrations
Contract Details
Start Date: July 2026 Duration: Approximately 6 months Engagement Type: Contract (hourly) Location: Remote / Hybrid
Ideal Candidate Profile
A hands-on data professional who can execute, not just plan Comfortable working in fast-paced, evolving environments Able to balance technical work with coordination responsibilities Proactive, detail-oriented, and accountable for outcomes
Not the right fit? Search for Data Analyst/Project Leader jobs in Ontario, Canada
About Amy Leonard Consulting
IT & management consulting, specializing in the acceleration of program & project delivery.
IT Program & Project Management delivering on time & on budget, consistently exceeding expectations.
- Facilitating large requirements initiatives with varied stakeholders to set portfolio strategies and project directions, culminating in multi-year program & portfolio plans and approved budget.
- Managing ambiguous and complex organizational structures and relationships. Defining specific directions despite conflicting priorities.
- Delivering infrastructure, application and process projects, managing deployments both local and remotely for up to 500 locations. Coordinating local and distributed teams, to deliver nationally.
- Improving and delivering processes across IT operations, delivery and governance, leveraging Key Performance Indicators to target opportunities and measure progress.
Division of AJ Biz Worx Corp.
Similar Jobs
Data Analyst/Project Leader
About the role
Overview
We are seeking a Data Analyst / Project Leader to support a housing system modernization initiative involving the migration of data from a legacy HCL Domino (Lotus Notes) system to Yardi / Rent Café. This is a hands-on delivery role, combining data analysis, ETL execution, and project coordination. The successful candidate will take ownership of data mapping, validation, and migration execution, while coordinating across vendors and internal teams. The role includes collaboration with a senior consultant providing project coaching, oversight, and escalation support.
Project Context
This initiative involves: Migration of complex, partially undocumented legacy data Coordination across multiple vendors and internal stakeholders Execution within a time-sensitive and resource-constrained environment Validation of data to ensure accuracy and readiness for system go-live
Key Responsibilities
Data Analysis & Transformation
Analyze extracted data from legacy systems, including complex and undocumented structures Define and document data mappings from source to target system Identify data quality issues and support cleansing and transformation
ETL Configuration & Migration Support
Populate and manage vendor-provided ETL templates Support multiple migration cycles and resolve mapping issues Validate data transformation outputs prior to system load
Data Validation & Reconciliation
Perform field-level validation and reconciliation between source and target data Work closely with business users to confirm data accuracy Identify and resolve discrepancies before final migration
Project Coordination
Coordinate day-to-day migration activities across: Data extraction vendor System vendor Internal business and IT teams Track tasks, risks, and dependencies Ensure timelines are maintained and issues are escalated
Migration Planning Support
Support development and execution of a detailed migration plan Assist in sequencing: Extraction Mapping and transformation Testing cycles Go-live preparation Identify risks and contribute to mitigation planning
Collaboration & Reporting
Work with a senior consultant providing oversight and coaching Participate in structured decision-making and documentation Communicate progress, issues, and recommendations clearly
Required Experience
Strong experience in: Data analysis and transformation, ETL-based data migration Experience working with complex or poorly documented data sources Ability to interpret data structures and resolve inconsistencies Experience coordinating work across multiple teams or stakeholders
Preferred Experience
Exposure to: HCL Domino / Lotus Notes, Yardi Rent Café Experience in: System implementations or data migrations
Contract Details
Start Date: July 2026 Duration: Approximately 6 months Engagement Type: Contract (hourly) Location: Remote / Hybrid
Ideal Candidate Profile
A hands-on data professional who can execute, not just plan Comfortable working in fast-paced, evolving environments Able to balance technical work with coordination responsibilities Proactive, detail-oriented, and accountable for outcomes
Not the right fit? Search for Data Analyst/Project Leader jobs in Ontario, Canada
About Amy Leonard Consulting
IT & management consulting, specializing in the acceleration of program & project delivery.
IT Program & Project Management delivering on time & on budget, consistently exceeding expectations.
- Facilitating large requirements initiatives with varied stakeholders to set portfolio strategies and project directions, culminating in multi-year program & portfolio plans and approved budget.
- Managing ambiguous and complex organizational structures and relationships. Defining specific directions despite conflicting priorities.
- Delivering infrastructure, application and process projects, managing deployments both local and remotely for up to 500 locations. Coordinating local and distributed teams, to deliver nationally.
- Improving and delivering processes across IT operations, delivery and governance, leveraging Key Performance Indicators to target opportunities and measure progress.
Division of AJ Biz Worx Corp.