Do you have hands-on experience with SQL and ETL? Do you have working experience in similar or larger initiatives with extensive usage of SQL and Unified Modeling Language (UML)? If so this would be a great opportunity for you!
Our client is looking for a Senior Data Analyst for a 6-month contract in North York. This is a hybrid role and there is high chance of contract extension.
...
Advantages
- Six-month contract with potential extension
- Hybrid Work Flexibility
- Earn a competitive rate within the industry
Responsibilities
1. Provide support and perform data related activities such data profiling, data mapping, data maintenance/quality and table changes associated with software applications; apply statistical and analytical techniques to derive insights and trends from complex datasets.
2. Engage in control activities to ensure data quality and adherence to enterprise data policy; perform exploratory data analysis to uncover trends, patterns, and anomalies. Create and/or review Data Profiling and Legacy Landscape Reports
3. Work with business systems analysts to define and document the scope and functional requirements for data and reporting needs, including the conceptual data model and data flow for the solution.
4. Analyze, develop specifications, and execute data mapping and transformation processes and requirements within and between applications.
5. Ensure data integrity by executing necessary processes and controls around the flow of data.
6. Assist in the design and execution of the overall Extract, Transform, and Load (ETL) processes and architecture.
7. Utilize technology to analyze data and/or metrics from applicable systems to review data processes, identify issues, determine actions to resolve or escalate problems that require data, systems, or process improvements.
8. Perform data‐related research and root cause analysis activities, provide correction specifications, and escalate issues as appropriate;
Develop and execute scripts and workflows to automate data collection, data cleansing, and data reconciliation.
9. Validate data accuracy, completeness, and integrity. Identify and address data quality issues and discrepancies.
10. Collaborate with cross-functional teams to design and deliver actionable data insights, participate in Data Quality Assurance and other data related project activities
11. Provide input to data architecture discussions and data related decisions on request.
12. Develop various projects artifacts including entity relationship diagrams by using Business Processes Modeling (BPM)/its Notation (BPMN)/ Unified Modeling Language (UML).
13. Work closely with the project team to support the procurement and acquisition of information software solutions (COTS);
14. Perform other project duties as required
Qualifications
- University degree in Computer Science, Data Science, Information Systems or related discipline, and 7+ years of progressively more responsible experience
working on large-scale information technology projects or the approved equivalent combination of education and/or experience.
- 7+ years extensive experience with Systems/Data Migration Projects especially involving legacy systems transitioning to COTS Platforms including data profiling, data mapping, transformation and validation processes.
- 5+ years hands-on experience with SQL and ETL including writing SQL queries and designing/executing ETL (Extract, Transfer and Load) processes to move and reconcile data between old and new system.
- Working experience and familiarity with data governance principles, data profiling, and insuring data integrity during migration. Able to define quality checks, identify data anomalies, and support resolution strategies.
- Demonstrated ability to establish and maintain an effective working relationship with clients and projects stakeholders with a strong customer service orientation; have highly developed interpersonal skills and communication ability to interact and work effectively.
Technical Capabilities:
- 7+ years of working experience in similar or larger initiatives with extensive usage of SQL and Unified Modeling Language (UML);
- 5+ years working experience in preparing project documentation such as Data Profiling, Data Mapping, Data Quality Documents and others data project related artifacts
- 5+ years working experience in designing, developing and executing ETL Specifications and Scripts
- Working experience with technical and business teams in supporting Accessibility for Ontarians with Disabilities Act (AODA), Security Threat and Risk Assessment (STRA), Privacy Impact Assessment (PIA);
Summary
If you are interested in the Senior Data Analyst in North York, please apply online at www.randstad.ca. Qualified candidates will be contacted.
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
Do you have hands-on experience with SQL and ETL? Do you have working experience in similar or larger initiatives with extensive usage of SQL and Unified Modeling Language (UML)? If so this would be a great opportunity for you!
Our client is looking for a Senior Data Analyst for a 6-month contract in North York. This is a hybrid role and there is high chance of contract extension.
Advantages
- Six-month contract with potential extension
- Hybrid Work Flexibility
- Earn a competitive rate within the industry
Responsibilities
1. Provide support and perform data related activities such data profiling, data mapping, data maintenance/quality and table changes associated with software applications; apply statistical and analytical techniques to derive insights and trends from complex datasets.
2. Engage in control activities to ensure data quality and adherence to enterprise data policy; perform exploratory data analysis to uncover trends, patterns, and anomalies. Create and/or review Data Profiling and Legacy Landscape Reports
3. Work with business systems analysts to define and document the scope and functional requirements for data and reporting needs, including the conceptual data model and data flow for the solution.
...
4. Analyze, develop specifications, and execute data mapping and transformation processes and requirements within and between applications.
5. Ensure data integrity by executing necessary processes and controls around the flow of data.
6. Assist in the design and execution of the overall Extract, Transform, and Load (ETL) processes and architecture.
7. Utilize technology to analyze data and/or metrics from applicable systems to review data processes, identify issues, determine actions to resolve or escalate problems that require data, systems, or process improvements.
8. Perform data‐related research and root cause analysis activities, provide correction specifications, and escalate issues as appropriate;
Develop and execute scripts and workflows to automate data collection, data cleansing, and data reconciliation.
9. Validate data accuracy, completeness, and integrity. Identify and address data quality issues and discrepancies.
10. Collaborate with cross-functional teams to design and deliver actionable data insights, participate in Data Quality Assurance and other data related project activities
11. Provide input to data architecture discussions and data related decisions on request.
12. Develop various projects artifacts including entity relationship diagrams by using Business Processes Modeling (BPM)/its Notation (BPMN)/ Unified Modeling Language (UML).
13. Work closely with the project team to support the procurement and acquisition of information software solutions (COTS);
14. Perform other project duties as required
Qualifications
- University degree in Computer Science, Data Science, Information Systems or related discipline, and 7+ years of progressively more responsible experience
working on large-scale information technology projects or the approved equivalent combination of education and/or experience.
- 7+ years extensive experience with Systems/Data Migration Projects especially involving legacy systems transitioning to COTS Platforms including data profiling, data mapping, transformation and validation processes.
- 5+ years hands-on experience with SQL and ETL including writing SQL queries and designing/executing ETL (Extract, Transfer and Load) processes to move and reconcile data between old and new system.
- Working experience and familiarity with data governance principles, data profiling, and insuring data integrity during migration. Able to define quality checks, identify data anomalies, and support resolution strategies.
- Demonstrated ability to establish and maintain an effective working relationship with clients and projects stakeholders with a strong customer service orientation; have highly developed interpersonal skills and communication ability to interact and work effectively.
Technical Capabilities:
- 7+ years of working experience in similar or larger initiatives with extensive usage of SQL and Unified Modeling Language (UML);
- 5+ years working experience in preparing project documentation such as Data Profiling, Data Mapping, Data Quality Documents and others data project related artifacts
- 5+ years working experience in designing, developing and executing ETL Specifications and Scripts
- Working experience with technical and business teams in supporting Accessibility for Ontarians with Disabilities Act (AODA), Security Threat and Risk Assessment (STRA), Privacy Impact Assessment (PIA);
Summary
If you are interested in the Senior Data Analyst in North York, please apply online at www.randstad.ca. Qualified candidates will be contacted.
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
