Hybrid Work Arrangement: FFS will need to work at 5700 Yonge for 2-3 days per week at discretion of HM.

Must Haves:

• In-depth knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).
• Ability to write complex queries, joins, subqueries, and use SQL functions
• Experience working with FHIR: data validation between entities, FHIR data flow, mapping to FHIR entities

General Skills - 40%

• Lead and conduct business analysis in order to assess client’s business problems/opportunities at varying levels of detail appropriate to the project, aligning with OPS Unified Project Management Methodology, Enterprise Architecture and Gating Process, and OPS Standard
• 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
• Meet with the Product Owner and end-users to understand the team’s work
• Act as a proxy Product Owner for the team, where the BA answers questions or facilitates decisions on behalf of an absent Product Owner
• 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
• Working effectively with other teams (developers, analysts, business stakeholders) to ensure the data model meets business and technical requirements
• Good communication skills to explain complex data modeling concepts to non-technical business users and ensure alignment with their needs
• Experience with agile practices, including sprints, user stories, and iterative development, especially when working in an agile data environment
• knowledge of emerging IT trends and technologies
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Technical Skills - 60%

• Experience how to create and interpret Entity-Relationship Diagrams to represent the relationships between different data entities
• Strong skills in SQL query, manipulate, and retrieve data from relational databases.
• Relational Databases: Experience with relational databases like Oracle, MySQL, SQL Server
• Knowledge of data warehousing concepts and platforms
• Ability to analyze data patterns, structures, and business requirements to define an optimal data model
• Experience working with FHIR to map entities to FHIR entities and to perform data validation between entities, FHIR data flow, mapping to FHIR entities
• Experience with conceptual data model to describe FHIR data flow
• Ability to document data requirements from source DB to FHIR service in Azure Data Services
• Experience with data migration projects
• Experience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope such as Power Designer
• Experience to create data models at different levels of abstraction and then map them to physical data storage.
• Ability to translate business requirements into effective data models that align with organizational goals
• Documenting definitions, structures, and rules for data elements
• Experience with database normalization techniques and when to apply denormalization for performance optimization.

Max no of submission- 1 (one)

Hybrid Work Arrangement: FFS will need to work at 5700 Yonge for 2-3 days per week at discretion of HM.

Notes- Please ensure all the candidates have all the must haves

Must Haves:

• In-depth knowledge of database management systems (e.g., SQL Server, Oracle, MySQL).
• Ability to write complex queries, joins, subqueries, and use SQL functions
• Experience working with FHIR: data validation between entities, FHIR data flow, mapping to FHIR entities