Are you a data expert with a passion for ensuring clean, accurate, and efficient data migrations? Our client seeks a detail-oriented Data Analyst to support the migration of critical asset data from Cartegraph to IBM Maximo. This role plays a vital part in improving asset management capabilities through a successful and seamless transition of information. If you bring strong SQL expertise, migration experience, and a collaborative mindset, this opportunity is built for you.
...
Advantages
- 6-month contract with a potential 6-month extension
- Play a key role in a high-impact asset management data migration
- Collaborate with subject matter experts and IT professionals
- Opportunity to work with enterprise systems like IBM Maximo and Cartegraph
- Enhance operational efficiency through data-driven transformation
Responsibilities
- Conduct thorough analysis of asset data within the Cartegraph database to understand data structure, quality, and relationships.
- Identify data discrepancies, inconsistencies, and potential migration challenges.
- Assess data quality and develop data cleansing strategies.
- Collaborate with subject matter experts (SMEs) to define data mapping requirements between Cartegraph and IBM Maximo.
- Develop and document detailed data mapping specifications.
- Perform data transformation and cleansing activities to ensure data compatibility with IBM Maximo. Assist in the design of the overall ETL processes.
- Develop and execute data validation scripts and procedures to ensure data accuracy and completeness during migration.
- Conduct thorough data quality checks and resolve data issues.
- Participate in User Acceptance Testing (UAT) to validate migrated data.
- Create and maintain comprehensive documentation related to data mapping, transformation, and validation processes.
- Provide regular progress reports and updates to project stakeholders.
- Assist in creating data migration-related reports.
- Work closely with Project Manager, Maximo SMEs, database administrators, and other project team members.
- Communicate effectively with stakeholders to ensure alignment and address data-related concerns.
Qualifications
Must Haves:
- Strong SQL skills for data extraction, manipulation, and analysis.
- Experience with relational databases (e.g., Oracle, SQL Server).
- Understanding of database schemas, data modeling, and data warehousing concepts.
- Proven experience in data migration projects, preferably involving large datasets.
General Skills:
- Understanding of asset management principles and practices.
- Familiarity with asset data structures and relationships.
- Ability to identify and resolve data-related issues.
- Excellent written and verbal communication skills.
- Ability to collaborate effectively with cross-functional teams and stakeholders.
- Ability to clearly articulate technical concepts to non-technical audiences.
- Strong attention to detail and accuracy.
- Ability to work with large datasets and ensure data integrity.
- Ability to create clear and concise documentation.
Summary
Our client is looking for a skilled and analytical Data Analyst to support a major data migration initiative. This is a great opportunity to apply your technical skills in a meaningful way, ensuring the integrity and effectiveness of asset management data within a dynamic project environment.
Also, remember that updating your profile on Randstad.ca helps us find you faster when we have roles that match your skills! So, even if this role isn’t for you, please update your profile so we can find you!
We look forward to supporting you in your job search! Good luck!
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
Are you a data expert with a passion for ensuring clean, accurate, and efficient data migrations? Our client seeks a detail-oriented Data Analyst to support the migration of critical asset data from Cartegraph to IBM Maximo. This role plays a vital part in improving asset management capabilities through a successful and seamless transition of information. If you bring strong SQL expertise, migration experience, and a collaborative mindset, this opportunity is built for you.
Advantages
- 6-month contract with a potential 6-month extension
- Play a key role in a high-impact asset management data migration
- Collaborate with subject matter experts and IT professionals
- Opportunity to work with enterprise systems like IBM Maximo and Cartegraph
- Enhance operational efficiency through data-driven transformation
Responsibilities
- Conduct thorough analysis of asset data within the Cartegraph database to understand data structure, quality, and relationships.
- Identify data discrepancies, inconsistencies, and potential migration challenges.
- Assess data quality and develop data cleansing strategies.
...
- Collaborate with subject matter experts (SMEs) to define data mapping requirements between Cartegraph and IBM Maximo.
- Develop and document detailed data mapping specifications.
- Perform data transformation and cleansing activities to ensure data compatibility with IBM Maximo. Assist in the design of the overall ETL processes.
- Develop and execute data validation scripts and procedures to ensure data accuracy and completeness during migration.
- Conduct thorough data quality checks and resolve data issues.
- Participate in User Acceptance Testing (UAT) to validate migrated data.
- Create and maintain comprehensive documentation related to data mapping, transformation, and validation processes.
- Provide regular progress reports and updates to project stakeholders.
- Assist in creating data migration-related reports.
- Work closely with Project Manager, Maximo SMEs, database administrators, and other project team members.
- Communicate effectively with stakeholders to ensure alignment and address data-related concerns.
Qualifications
Must Haves:
- Strong SQL skills for data extraction, manipulation, and analysis.
- Experience with relational databases (e.g., Oracle, SQL Server).
- Understanding of database schemas, data modeling, and data warehousing concepts.
- Proven experience in data migration projects, preferably involving large datasets.
General Skills:
- Understanding of asset management principles and practices.
- Familiarity with asset data structures and relationships.
- Ability to identify and resolve data-related issues.
- Excellent written and verbal communication skills.
- Ability to collaborate effectively with cross-functional teams and stakeholders.
- Ability to clearly articulate technical concepts to non-technical audiences.
- Strong attention to detail and accuracy.
- Ability to work with large datasets and ensure data integrity.
- Ability to create clear and concise documentation.
Summary
Our client is looking for a skilled and analytical Data Analyst to support a major data migration initiative. This is a great opportunity to apply your technical skills in a meaningful way, ensuring the integrity and effectiveness of asset management data within a dynamic project environment.
Also, remember that updating your profile on Randstad.ca helps us find you faster when we have roles that match your skills! So, even if this role isn’t for you, please update your profile so we can find you!
We look forward to supporting you in your job search! Good luck!
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
