Job Summary:
In accordance with the Mission, Vision and Values, and strategic directions of PHSA, safety, including both patient and employee safety, is a priority and a responsibility shared by everyone at PHSA. As such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.
The Business Intelligence (BI) Analyst reports to the Manager/Lead and is primarily focused on developing and maintaining “Extract Transform Load” (ETL) solutions. The BI Analyst works closely with colleagues to audit, identify and follow-up on issues related to data quality, metric definitions or process deficiencies. Responsibilities also include database development and monitoring, data modeling, data dictionary development and maintenance, ad-hoc reporting, report development, documentation, maintenance of users and user permissions. The BI Analyst identifies, documents, and resolves issues with data in collaboration with business stakeholders, and supports and liaises with Technology Services regarding hardware and network problems as related to data warehouse and BI environments. This role communicates with staff and stakeholders at all levels to ensure requirements are met.
.
Duties/Accountabilities:
• Designs, develops and maintains databases, ETL, OLAP cubes, reports, dashboards and other BI content as required. Works collaboratively with clients and business analysts to gather requirements, create definitions and specifications and translate into data models, ETL packages and reports as appropriate. Writes ad-hoc queries and reports to support analysts and leaders in data analysis. Creates and maintains report subscriptions for staff and operational leaders across participating organizations.
• Administers the SQL Server databases (data marts) including security, user permissions, performance and usage monitoring. Maintains data quality and ensures data integrity and daily refresh of data warehouse and OLAP cubes and BI content. Maintains lookup tables, writes technical and user documentation, troubleshoots issues with reports, data sources, performance and other related duties. Maintains the reporting environment (SQL SSRS, Tableau, Power BI, SharePoint TeamSites). Ensures that databases, reports and other BI content are developed and maintained in accordance with PHSA Privacy and Confidentiality guidelines.
• Provides first-line support to users for all published BI content. Provides technical and educational support to colleagues and stakeholders and report writers.
• Collaborates with Technology Services, vendors and other teams on hardware and software implementation, upgrades and troubleshooting as it relates to database and BI software and hardware. Communicates with various external clients such as HEABC, Ministry Of Health, and WSBC on definitions, ad hoc queries and regular data/report submissions as directed by stakeholders.
• Evaluates current solutions, researches new and alternative technologies, processes and approaches according to industry best practices.
Qualifications:
A level of education, training, and experience equivalent to a degree or diploma in Information Systems or Computer Science from a recognized program, plus a minimum of three (3) years’ recent related work experience, preferably in a health care environment.
An in-depth working knowledge of relational and multidimensional (OLAP) databases, as well as proven knowledge and experience in working with SQL Server BI stack. Administrative experience including setting up new users, monitoring performance, and query tuning. Effective communication skills, both verbal and written. Excellent analytical skills and ability to turn complex business requirements into analysis ready data-sets, data-marts, cubes or data-models. Knowledge of privacy and confidentiality policies and procedures.
Experience with and ability to develop technical documentation, and understand management reporting and statistical concepts. Demonstrated ability to analyze operational issues and recommend innovative solutions. Self-directed, motivated, and adaptable to new technology including hardware, software, and programming applications. Ability to work on project teams, organize workload, set priorities and meet deadlines in a dynamic environment, and flexibility to multi-task.
** Please note: Support for nomination with the BC Provincial Nominee Program is not a guarantee, entitlement, nor an employee benefit after receiving a full time job offer with PHSA **