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.