Business Analyst 8375-1016

Dheya; Old Toronto; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

An established industry player is seeking a Senior Business Analyst to join their dynamic team. This hybrid contract role involves leading business and system analysis for a new data warehouse/lakehouse project, where you will play a pivotal role in developing modernized reports and facilitating data migration activities. With a strong emphasis on collaboration and communication, you will engage with various stakeholders to ensure that business requirements are translated into effective solutions. If you have a passion for data and a proven track record in business analysis, this is an exciting opportunity to make a significant impact in a forward-thinking environment.

Qualifications

• 10+ years of experience in business and system analysis.
• Proven experience in agile and waterfall project management methodologies.

Responsibilities

• Lead business and system analysis for data migration projects.
• Document report requirements and conduct gap analysis.

Skills

Data Analysis

Communication Skills

Requirement Gathering

Problem Solving

Dynamics 365

Microsoft Power BI

Data Lakehouse

SQL Proficiency

Agile Methodologies

Project Management

Stakeholder Management

Business Process Modeling

Tools

DevOps

PowerBI

Job description

Skills Required:

Data Analysis, Communication Skills, Requirement Gathering, Problem Solving, Dynamics 365, Microsoft Power BI, Data Lakehouse, SQL Proficiency, Agile Methodologies, Project Management, Stakeholder Management, Business Process Modeling

HM Note: This hybrid contract role is in office at the manager's discretion. Candidates resume must include first and last name.

Description:

Scope:

• The Office of the Public Guardian and Trustee (OPGT) requires a Senior Business Analyst to assist with report development for the new data warehouse/lakehouse and associated data migration activities.

As a member of the data migration and reporting team, you will be responsible to build and deliver modernized reports from the new data warehouse/lakehouse and assist with the data migration from the existing legacy applications to the new Dynamics 365 solution. A high-level list of deliverables follows:

• 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.
• Other duties as assigned.

Skills Experience and Skill Set Requirements:

Mandatory 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.

Desired Skills and Experience:

• 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.
• 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 translating 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.

Resumes Evaluation/Criteria:

Criteria 1: Business Analysis Experience - 40 Points

• 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, with emphasis on agile.

Criteria 2: IT Specific Skills - 30 Points

• 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.

Criteria 3: Quality Assurance - 10 Points

• 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.

Criteria 4: Consulting and Communication Skills - 10 Points

• 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.
• Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively.
• A motivated, flexible, creative team player with perseverance, excellent multi-tasking abilities and a proven track record for meeting strict deadlines.

Criteria 5: DevOps and Agile - 10 Points

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

Knowledge Transfer:

What needs to be KT:

• Document the tasks executed and in process of execution as a member of the data migration team using the approach and tools required by the project manager.

To whom:

• Project Manager/Team Members

When:

• 1:1 meetings / team meetings / documentation in DevOps Wiki and boards throughout the duration of the project life cycle.

Must haves:

• 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.

Didn't find the role you were looking for? Upload your resume now to get considered for future job opportunities at Foilcon.