HM Note: This hybrid contract role is three 3 days in office. Candidates resume must include first and last name.
Description
Responsibilities:
Provides a comprehensive range of I and amp;IT business analysis services for clients with diverse business and technological needs. Interacts with the business stakeholders and subject matter experts in order to understand their requirements through gathering documenting and analyzing business needs and requirements.
Prepares and advises on business analysis policies processes best practices and standards to promote a comprehensive and consistent business analysis practice within the organization.
General Skills:
Leads and conducts business analysis in order to assess clients business problems/opportunities and documents the business requirements in such a way that I and amp;IT solutions can be determined.
Applies re-engineering concepts to promote business improvements through alternative and cost effective service delivery approaches
Leads and conducts business analysis at varying levels of detail appropriate to the project and phases of project aligning with OPS Unified Project Management Methodology Enterprise Architecture and Gating Process and OPS Standard Systems Development Methodologies
Develops strategies prepares business cases and cost-benefit analysis and conducts feasibility studies for business I and amp;IT initiatives
Develops sound processes for requirements gathering including but not limited to JAD sessions interviews mockups etc.
Conducts 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 Monitors progress resolves problems and reports regularly to I and amp;IT management and stakeholders
Develops performance measures and traceability matrices for business analysis evaluation and conducts follow-up
Experience developing strategies preparing business cases and cost-benefit analysis
Experience conducting requirements gathering developing documentation including presentations and briefing notes and conducting stakeholder engagement
Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope
Awareness of emerging I and amp;IT trends and technologies Excellent analytical problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
A team player with a track record for meeting deadlines
Desirable Skills:
Experience in the use of information retrieval packages
Knowledge and understanding of Information Management principles concepts policies and practices
Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions
Experience with a wide range of methods tools and techniques for business analysis such as: business functional modelling business event modelling business process mapping
Experience in structured object oriented and agile methodologies for user requirements
Experience developing performance measures for business analysis evaluation and subsequent follow-up
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
Skills
Experience and Skill Set Requirements
Must Haves: and nbsp;
- In-depth knowledge of database management systems (e.g. SQL Server Oracle MySQL Data Bricks). and nbsp;
- Ability to write complex queries joins subqueries and use SQL functions and nbsp;
- Experience with Agile project methodology leveraging Azure DevOps and nbsp;
- Experience transposing requirements into coherent user stories and nbsp;
- In-depth knowledge of delta tables ETL pipelines change data capture and databricks and nbsp;
General Skills - 50 and nbsp;
- 58 years of experience as a Business Analyst with at least 3 years focused on data-centric projects and nbsp;
- Experience in large-scale system integrations data migrations or legacy system replacements and nbsp;
- Experience with agile practices including sprints user stories and iterative development especially when working in an agile data environment and nbsp;
- Experience grooming and assembling requirements into coherent user stories and use cases and managing the Product Backlog Items refining them and communicate changes to project manager/Team Lead and nbsp;
- Lead and conduct business analysis in order to assess clients business problems/opportunities at varying levels of detail appropriate to the project and nbsp;
- Analyze current and future data needs data flows and data governance practices to support enterprise data strategies and nbsp;
- Translate business requirements into data requirements (e.g. data sourcing transformation logic reporting needs and data quality rules) and nbsp;
- Lead data discovery efforts and participate in the design of data models and data integration solutions and nbsp;
- Support data migration data warehousing and business intelligence initiatives by ensuring clarity and accuracy of requirements and nbsp;
- Ability to write clear and comprehensive documentation: business requirements documents (BRD) data dictionaries mapping documents and use cases. and nbsp;
- Conduct gap analyses between current and desired states of data assets or data processes and nbsp;
- Ensure data requirements align with privacy security and OPS regulatory standards and nbsp; and nbsp;
- 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 and nbsp;
- Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope and nbsp;
- Apply re-engineering concepts to promote business improvements through alternative and cost effective service delivery approaches and nbsp;
and nbsp;
Technical and Project Management Expertise - 50 and nbsp;
- Expert Knowledge of data warehouse design methodologies delta lake Medallion Architecture and nbsp; and nbsp;
- Experience working with relational databases (e.g. SQL Server Oracle) Azure Databricks SQL Warehouse Azure Data Lake and nbsp;
- Strong skills in SQL query manipulate and retrieve data from relational databases. and nbsp;
- Experience how to create and interpret Entity-Relationship Diagrams to represent the relationships between different data entities and nbsp;
- Strong knowledge of data analysis techniques data modeling data warehousing and of Extract/Transform/Load processes (ETL) processes and nbsp;
- Solid understanding of data governance data quality metadata and master data management (MDM) and nbsp;
- Ability to analyze data patterns structures and business requirements to define an optimal data model and nbsp;
- Ability to translate business requirements into effective data models that align with organizational goals and nbsp;
- Documenting definitions structures and rules for data elements and nbsp;
- Familiarity with reporting tools (e.g. Power BI) and how data is structured and nbsp; and nbsp;
- Experience in defect fixing testing support and development activities for ETL tool and nbsp;
- Experience in the development and maintaining a plan to address contract deliverables through the identification of significant milestones and expected results with weekly status reporting. and nbsp;
- Good communication skills to explain complex data modeling concepts to non-technical business users and ensure alignment with their needs and nbsp;
- A team player with a track record for meeting deadlines and nbsp;
Must Haves: and nbsp;
- In-depth knowledge of database management systems (e.g. SQL Server Oracle MySQL Data Bricks). and nbsp;
- Ability to write complex queries joins subqueries and use SQL functions and nbsp;
- Experience with Agile project methodology leveraging Azure DevOps and nbsp;
- Experience transposing requirements into coherent user stories and nbsp;
- In-depth knowledge of delta tables ETL pipelines change data capture and databricks