Business Intelligence Developer (RFT 1.0 FTE)

This position contributes to The Royal with its technical expertise in moving and transforming data.  They contribute to the data team’s environment and processes and enable the creation of reports, etc through the set-up of data models, collaborating with users to understand and document their requirements as well as helping to support the technology infrastructure in the data environment.   This team member will collaborate both with internal team members and external data partners in the shared data environment, they will contribute to collaborative planning and work in a supportive and positive manner.Duties:Database/Data Model Design & Development:

• Documents business requirements in the form of specifications (functional and technical specifications), validates accuracy and obtains necessary input and approval.
• Following established standards and practices, develops and maintains data models and data dictionaries, data maps and other artifacts, including the conceptual and physical models, as well as a metadata repository.
• Contributes to and supports activities to ensure the integrity and performance of data environment, including investigation and issue resolution as required. 

Report Design & Development:

• Contributes to and helps build data & analytic solutions (including database design) as assigned to support requests and business needs
• Generates reports and other data and analytics services within the Azure data & analytics environment. 
• Ensures reports and other data & analytics solutions are optimized for efficiency and performance in the production environment.
• Assists with documentation of report library and builds ETL packages.

Partnerships & Collaboration:

• Collaborates with data team members and partners such as IT to help ensure internal control & integrity of systems
• Actively participates and supports activities as part of various Data Working Groups.
• Contribute and work with partner hospitals towards approved initiatives and prioritie

Operational Support & Maintenance:

• As requested and assigned, performs system and platform performance monitoring and tuning, and SQL code review.
• Supports and follows information governance and data standardization procedures established by the organization and partnerships.
• Applies appropriate content and design details where appropriate
• Performs other related duties as assigned or requested.
• Collaborates closely with and provide coverage as needed for any BI Developer/Analyst

Other:

• Work in a manner that is in compliance with staff and patient/client safety practices, policies and procedures of The Royal. 
• Ensure a work environment that is conducive to The Royal’s Anti-Racism, Harassment, & Discrimination Free Workplace Policy 

Qualifications:

• Bachelor’s Degree in Computer Science, Software Engineering or Information Technology, or equivalent.  
• Minimum 3 years of work experience with SQL server, Business Intelligence, reporting and data modelling 
• Working knowledge of healthcare and/or Meditech HIS environment. 
• Expert working knowledge of relational databases, data model development, data warehousing, and business intelligence. 
• Expert in database design, relational integrity constraints, OLAP, OLTP, cubes, and normalization. 
• Experience with cloud-based BI, data virtualization including Azure platform and Power BI Services. 
• Demonstrated experience in creating medium to large-scale enterprise logical data models using normalization, star and snowflake schema techniques 
• Demonstrated experience with ETL and MS SQL Server performance tuning (Profiler, Tracing, Execution Plan Analysis). 
• Expert experience in generating custom reports using SQL Server and Microsoft reporting tools such as SSRS, SSMS, Azure Data Studio and Power BI Desktop, including advanced functions, scheduling and publishing reports on Report Server or Power BI Service 
• Demonstrated experience within the Azure platform, including, but not limited to: Azure Data Factory; Logic Apps; Azure Functions 
• Demonstrated experience in responding to and troubleshooting issues related to data quality and performance, with the ability to resolve them in a timely manner. 
• Demonstrated experience in building data analytics and reporting. 
• Experience with Object-Oriented Programming language, including but not limited to, C#/VB/Javais a asset. 
• The ability to foster collaborative and effective working relationships with stakeholders that promote cooperative goals and contribute to an atmosphere of trust and mutual respect. 
• Experience with SAS. 
• Experience in working on multiple projects at the same time. 
• Knowledge of HL7 and FHIR (Fast Healthcare Interoperability Resources) 
• Knowledge of the basics of Machine Learning and ability to write/read Python/R code. 
• Strong and effective communication skills to engage with all stakeholders to gather and document business requirements. 
• Excellent communication, interpersonal, organizational, change management and relationship management skills. 
• Proven abilities to take initiative and to be innovative and collaborative. 
• English level A- is mandatory in oral expression, comprehension, reading & writing.  Bilingual (French/English) is considered an asset.