We are representing a prominent Canadian leader in the retail and real estate sectors currently undergoing a massive digital transformation. As they migrate their legacy systems to a next-generation ERP (S/4HANA), they require a meticulous Intermediate Data Analyst to serve as the bridge between raw data and system integration. You will be the guardian of data integrity, ensuring that complex financial and property information is harmonized, scrubbed, and ready for a high-stakes migration.
...
Advantages
High-Impact Tech: Play a pivotal role in one of the most significant ERP modernization projects (S/4HANA) in the industry.
Strategic Visibility: Work directly on a mission-critical project with a firm "Go-Live" target, offering high visibility within the organization.
Hybrid Flexibility: Enjoy a balanced work-life integration with a mix of onsite collaboration in Terrebonne and remote work.
Professional Growth: Deepen your expertise in financial data compliance, including IFRS standards and data privacy regulations.
Responsibilities
Data Orchestration: Extract, centralize, and harmonize fragmented data from various sources including legacy ERPs, specialized property management software, and complex Excel spreadsheets.
Quality Assurance: Execute rigorous cleaning and validation of financial datasets (rents, collections, construction budgets) to ensure zero-error transition.
ETL Optimization: Utilize Power Query to build robust data transformation pipelines and Power BI to create reconciliation dashboards for project stakeholders.
Compliance Oversight: Ensure all handled data adheres to IFRS accounting standards and Law 25 privacy requirements.
Collaborative Liaison: Partner with external consulting firms to align data preparation with the pre-defined technical architecture.
Qualifications
Analytical Mastery: Advanced proficiency in Power Query and Power BI is essential for manipulating large, disparate datasets.
ERP Familiarity: Experience with large-scale enterprise software (SAP R3, Oracle, Salesforce, or ServiceNow). Specific knowledge of SAP conversion cycles is a significant asset.
Financial Literacy: Strong understanding of financial data flow, particularly construction budgets, industrial drawings, and real estate accounting.
Domain Knowledge: Previous experience with property management tools (e.g., Hopem) or real estate data is highly preferred.
Compliance Mindset: Familiarity with data integrity laws (Law 25) and international reporting standards (IFRS).
Our client operates in Canada. The company takes all reasonable steps to limit the number of positions in Quebec that require knowledge of a language other than French, and only requires it when necessary and its existing bilingual employees are unable to perform these duties. Based on an assessment conducted by our client, it has been determined that this position requires candidates to be fluent in English (both spoken and written). In particular, this position will require the employee to interact with centralized internal departments (e.g., Operations / HR / Finance / Legal / Contracts / Sales) that support the organization in Canada and that do not speak French.
Summary
Location: Terrebonne, QC (Hybrid - 3 days onsite)
Duration: 9-month contract (covering Go-Live and post-migration support)
Schedule: 37.5 hours per week
Role Level: Intermediate (Grade 3-4 equivalent)
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
We are representing a prominent Canadian leader in the retail and real estate sectors currently undergoing a massive digital transformation. As they migrate their legacy systems to a next-generation ERP (S/4HANA), they require a meticulous Intermediate Data Analyst to serve as the bridge between raw data and system integration. You will be the guardian of data integrity, ensuring that complex financial and property information is harmonized, scrubbed, and ready for a high-stakes migration.
Advantages
High-Impact Tech: Play a pivotal role in one of the most significant ERP modernization projects (S/4HANA) in the industry.
Strategic Visibility: Work directly on a mission-critical project with a firm "Go-Live" target, offering high visibility within the organization.
Hybrid Flexibility: Enjoy a balanced work-life integration with a mix of onsite collaboration in Terrebonne and remote work.
Professional Growth: Deepen your expertise in financial data compliance, including IFRS standards and data privacy regulations.
Responsibilities
Data Orchestration: Extract, centralize, and harmonize fragmented data from various sources including legacy ERPs, specialized property management software, and complex Excel spreadsheets.
...
Quality Assurance: Execute rigorous cleaning and validation of financial datasets (rents, collections, construction budgets) to ensure zero-error transition.
ETL Optimization: Utilize Power Query to build robust data transformation pipelines and Power BI to create reconciliation dashboards for project stakeholders.
Compliance Oversight: Ensure all handled data adheres to IFRS accounting standards and Law 25 privacy requirements.
Collaborative Liaison: Partner with external consulting firms to align data preparation with the pre-defined technical architecture.
Qualifications
Analytical Mastery: Advanced proficiency in Power Query and Power BI is essential for manipulating large, disparate datasets.
ERP Familiarity: Experience with large-scale enterprise software (SAP R3, Oracle, Salesforce, or ServiceNow). Specific knowledge of SAP conversion cycles is a significant asset.
Financial Literacy: Strong understanding of financial data flow, particularly construction budgets, industrial drawings, and real estate accounting.
Domain Knowledge: Previous experience with property management tools (e.g., Hopem) or real estate data is highly preferred.
Compliance Mindset: Familiarity with data integrity laws (Law 25) and international reporting standards (IFRS).
Our client operates in Canada. The company takes all reasonable steps to limit the number of positions in Quebec that require knowledge of a language other than French, and only requires it when necessary and its existing bilingual employees are unable to perform these duties. Based on an assessment conducted by our client, it has been determined that this position requires candidates to be fluent in English (both spoken and written). In particular, this position will require the employee to interact with centralized internal departments (e.g., Operations / HR / Finance / Legal / Contracts / Sales) that support the organization in Canada and that do not speak French.
Summary
Location: Terrebonne, QC (Hybrid - 3 days onsite)
Duration: 9-month contract (covering Go-Live and post-migration support)
Schedule: 37.5 hours per week
Role Level: Intermediate (Grade 3-4 equivalent)
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
