Job Summary:

In accordance with the Mission, Vision and Values, and strategic directions of Provincial Health Services Authority patient safety is a priority and a responsibility shared by everyone at PHSA, and as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.

Reporting to the Lead, Data Architecture and Business Intelligence, the Specialist, Data Integration is responsible for the planning, design, development and management of new and existing data warehouse and analytics solutions related to various PHSA programs and services. Applying a broad range of information technology experience, Data Warehousing (DW), Business Intelligence (BI), and clinical and operational knowledge, the Business Intelligence Specialist works with stakeholders to develop analytical products that meet their analytical, reporting, monitoring, surveillance and evaluation needs.  This position plans, designs, and develops BI and analytical solutions, including data Extract, Transform, Load (ETL) processes, data marts, reports and dashboards as part of the overall PHSA Enterprise Data Warehouse.  This position ensures the integrity and quality of the data accessible through these solutions, and also manages and maintains the metadata and other product documentations.

Duties/Accountabilities:

•    Architects and implements analytics solutions to develop, enhance and improve analytics and use of data at various PHSA programs and external stakeholders. This includes leading the design, development, documentation and implementation of complex data marts, multidimensional cubes or other semantic models, reports, dashboards and other front-end interfaces.
•    Architects and implements optimal database schemas and ETL solutions to integrate data from various source systems into integrated linked data marts. Collaborates with other members of the team on conceptual design, development, and implementation of the Enterprise Data Warehouse.
•    Leads the identification of new data sources and implements data extraction routines from departmental feeder systems. Provides advice and direction on data availability and quality. Consults and problem-solves with feeder departments regarding routine data extracts.
•    Participates in the development, definition and reporting of performance indicators as related to program operations, access and throughput, for use at the program director and executive level. Liaises on behalf of the agency with external consultants on the provisioning of patient specific data, as well as providing education on analysis and interpretation.
•    Provides technical expertise in the development of Analytics and Business Intelligence solutions by assessing client needs and requirements, reviewing technical options, determining the design and architecture and leading all levels of the solution development and deployment.  
•    Ensures the designed solutions meet the established architectural, security, and quality standards set by the department by actively engaging peers and leads in design and review processes. Maintains current metadata, definitions and documentation of the solutions.
•    Maintains familiarity with the latest on-premises and cloud analytics technologies, and an awareness of current clinical and business information system trends and issues. Evaluates and recommends products or methods to deliver analytics and Business Intelligence in an accurate, timely and user friendly manner.
•    Mentors other developers and team members and provides technical and educational support to end users by developing training materials, delivering training sessions and training trainers.    
•    Represents DARE on committees at various levels with regard to data standards, appropriate usage, availability and quality.

Qualifications:

A level of education, training, and experience equivalent to a Bachelor’s degree in Computer Science, Information Technology, Health Information Science, Management Information Systems or a related field, plus 3 to 5 years of recent BI, data warehousing, data modelling or analytics experience. Strong understanding of health care system operations and public and population health concepts is definite asset.

Advanced knowledge, and experience in application of best practices of data standards, database design, data architecture and modelling. Expertise in developing ETL solutions, relational and multi-dimensional databases and data marts. Superior database querying, and query optimization skills using Structured Query Language -preferably T-SQL, MDX or DAX or equivalents. Knowledge of experience with BI and visualizations tools such as Microsoft Power BI, and Tableau, and collaboration solutions such as SharePoint. Proven hands-on experience with standard data warehousing and Business Intelligence tools such as Microsoft SQL Server, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), and related development tools and version control tools, or comparable technologies from other vendors. Working knowledge of big data technologies, data science methods and languages such as (Python, R) and Windows and web application development tools and languages is an asset. High level of expertise in Microsoft Office suite of applications.

Excellent interpersonal, oral and written communication skills with the ability to communicate complex ideas in simple terminology with internal and external contacts. Demonstrated ability to analyze operational problems and recommend innovative solutions. Strong analytical, problem solving and system analysis skills including the ability to comprehend complex large scale health care environment operational issues and related data/information and present information in concise meaningful ways. Customer focused with ability to facilitate and encourage cooperation between professionals from other disciplines. Ability to understand management reporting and statistical concepts.  Ability to educate and lead management staff on the importance of using high quality data for decision making, via business intelligence tools and other means.  Self-directed and motivated to learn new tools and technology. Ability to work independently with little direct supervision and as a member of a multi-disciplinary team. Excellent time management skills with the ability to organize and prioritize work. Physical ability to perform the duties of the job. Persistence and a positive attitude are essential given the iterative development cycle and sometimes problematic data integration issues.