Senior Business Analyst (PL708)

Our client, a leading organization in the public sector, is seeking a Senior Business Analyst with expertise in database management, SQL, and FHIR data standards. The successful candidate will play a key role in designing, analyzing, and validating data models while working closely with business and technical teams to ensure effective data management and compliance with regulatory standards.

(Hybrid role)

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 to assess clients' 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 Standards.

• Experience grooming and assembling requirements into coherent user stories and use cases, 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/logical data models, and data flow modeling; use case surveys; business rules definitions and non-functional requirements definitions.

• Work effectively with other teams (developers, analysts, business stakeholders) to ensure the data model meets business and technical requirements.

• Strong 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 the Accessibility for Ontarians with Disabilities 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, manipulate, and retrieve data from relational databases.

• Relational Databases: Experience with relational databases like Oracle, MySQL, SQL Server.

• Knowledge of data warehousing concepts and patterns.

• 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 perform data validation between entities, FHIR data flow, and mapping to FHIR.

• Experience with conceptual data modeling to describe FHIR data flow.

• Ability to document data requirements from source DB to FHIR service in Azure Data Services.

• Experience with data migrations.

• Experience with Computer-Aided Software Engineering (CASE) tools to document conceptual requirements and scope, such as Power Designer.

• Strong ability 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 knowing when to apply denormalization for performance optimization.