Senior Business Analyst

Job Summary

This is a contract position for a Business Analyst - Senior for our public sector client. The successful candidate will be responsible for leading and conducting business and system analysis to assess client's business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.

Key Responsibilities

Lead and conduct business and system analysis in respect to building the golden layer of the data lakehouse and modernized reports in PowerBI.

Lead the effort into defining the reporting MVP; document legacy reports in scope of MVP; conduct gap analysis and provide recommendations.

Document report requirements in user stories in DevOps. Conduct analysis at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards

Liaise between Business Areas and the data migration and reporting team, to clarify business requirements and translate them into system and reporting requirements

Conduct business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non-functional requirements definitions for assigned projects, including report requirements, screen specifications, business rules, data migration requirements, etc.

Produce/update documentation which will allow future support of the implemented solutions

Assist with identifying and resolving data quality issues, defining test cases, performing data reconciliation, and addressing any issues or discrepancies that arise during the testing phase; developing KPIs to report on the progress, completeness and quality of the reporting and data migration effort.

Ongoing Support: provide post-migration support, analyze and address data-related issues or questions; help with optimizing data management processes in the new environment.

Requirements

10+ years of experience leading and conducting business and system analysis to assess client's business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.

Proven experience in both agile and waterfall project management methodologies.

Proven experience in conducting business and system analysis in respect to building data marts/data warehouses/data lakehouse or Business Intelligence/Data Analytics and Reporting solutions

Demonstrated experience working as a business analyst in large/complex data migration projects.

Demonstrated experience with writing user stories and using tools such as DevOps.

Skills and Knowledge

10+ years of experience leading and conducting business and system analysis to assess client's business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.

Experience conducting analyses at varying levels of detail, appropriate to the project and phases of project, aligning with OPS standards

Experience conducting business modeling; use case modeling; conceptual and logical data modeling; process and data flow modeling; use case surveys; business rules definition and non-functional requirements definitions for assigned projects, including screen specifications, business rules, data migration requirements, etc.

Proven experience in both agile and waterfall project management methodologies.

Proven experience in conducting business and system analysis in respect to building data marts/data warehouses/data lakehouse or Business Intelligence/Data Analytics and Reporting solutions

Demonstrated experience working as a business analyst in large/complex data migration projects.

Familiarity with BI/reporting tools such as PowerBI

Basic knowledge of SQL language; ability to execute SQL queries.

Understanding of concepts around ETL, data quality, data cleaning, data issues' handling.

Experience in conducting business and system analysis for a Dynamics 365 CE and/or F&O solution or other CRM/ERP solutions

Experience creating use cases, test plans, test cases, test scripts ideally around reporting and/or data migration

Experience with defect management processes, defect identification, logging, tracking, and resolution.

Familiarity with industry-standard quality assurance practices, such as ISO standards, CMMI, or Agile methodologies

Experience consulting and coordinating between Business Areas and the IT Development and Testing teams to clarify business requirements and translate them into system requirements

Critical thinking, analytical and problem-solving skills; proven gap analysis experience

Excellent verbal and written communication skills

Proven ability to engage with stakeholders and build strong working relationships

Demonstrated experience with writing user stories and using tools such as DevOps.

Criteria

10+ years of experience leading and conducting business and system analysis to assess client's business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.

Proven experience in both agile and waterfall project management methodologies, with emphasis on agile.

Proven experience in conducting business and system analysis in respect to building data marts/data warehouses/data lakehouse or Business Intelligence/Data Analytics and Reporting solutions

Demonstrated experience working as a business analyst in large/complex data migration projects.

Demonstrated experience with writing user stories and using tools such as DevOps.

Qualifications

10+ years of experience leading and conducting business and system analysis to assess client's business problems/opportunities and document the business/system requirements in such a way that I&IT solutions can be designed.

Proven experience in both agile and waterfall project management methodologies.

Proven experience in conducting business and system analysis in respect to building data marts/data warehouses/data lakehouse or Business Intelligence/Data Analytics and Reporting solutions

Demonstrated experience working as a business analyst in large/complex data migration projects.

Demonstrated experience with writing user stories and using tools such as DevOps.

Summary

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.

---