RQ08769 - Business Analyst - Intermediate

RQ08769 - Business Analyst - Intermediate About the job RQ08769 - Business Analyst - Intermediate Description: SkillsExperience and Skill Set Requirements Closing Date - 2025-04-01, 12:15 p.m. 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 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 communicating 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. Work 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 in creating and interpreting Entity-Relationship Diagrams to represent the relationships between different data entities. Strong skills in SQL query, manipulation, and retrieval of data from 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 with Computer Aided Software Engineering (CASE) tools to document conceptual requirements and scope such as Power Designer. Experience creating data models at different levels of abstraction and then mapping 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 strategies for denormalization to optimize performance. Notes - Please ensure all candidates have all the must haves. Get started by sending an email, scheduling a task, and more information. #J-18808-Ljbffr