The salary range for this position is CAD $38.88/Hr. - CAD $55.89/Hr.

The hours of work, including start and stop times, days off, work area and work site may be subject to change consistent with operations requirements and applicable provisions of the Collective Agreement and statutes. **Testing may be required. ***A criminal record check may be required

Help build the tools that make healthcare work smarter.

PHC's Data Analytics team is now hiring a temporary full-time BI Developer-Analyst to help transform data into practical solutions that support better decision-making across the organization. Reporting to the Senior Data Scientist and working alongsied Analysts and technical teams, you’ll contribute to a variety of projects ranging from process automation and application development to business intelligence solutions and data analytics initiatives. This is an opportunity to leverage your expertise in SQL, data visualization, automation, and data analytics to help improve the systems and processes that support healthcare delivery across PHC.
This is a primarily remote position, with occasional in-person work required. This posting is scheduled to close at 11:59PM on Friday, July 31st.

Education

• Bachelor's Degree in Computer Science, Business Analytics, Statistics, Mathematics, Engineering or related field plus a minimum of five (5) years' recent, related experience with data modeling, data visualization and reporting tools (specifically, Tableau, SAP Crystal Reports, SSRS and Power BI), ETL, Microsoft BI tools (SSAS, SSRS, and SSIS), advanced T-SQL (Microsoft Transact SQL) and analyzing business requirements or an equivalent combination of education, training and experience.

Significant recent experience is also required in the following:

• Business analysis and project management;
• Coordinating and documenting the change management process for complex information systems
• Upgrading/migrating to SQL Server Platforms - SQL Server 2019
• Writing T-SQL
• Programming experience in C#, VB.net, Java, etc.

Skills and Abilities

• Advanced knowledge of Microsoft Business Intelligence Stack, SSIS, SSAS, SSRS.
• Expert proficiency in Tableau and other Analytical and Reporting tools. Strong analytical/modeling skills with the ability to convert raw data into actionable business insights.
• Demonstrated knowledge of OLAP technologies and dimensional modeling.
• Strong background in data architecture, data quality, data mapping, and data structures.
• Strong understanding of database and business intelligence concepts.
• Proven ability to interpret data files and record layouts to map fields between multiple systems and database tables.
• Work effectively in an ETL framework driven environment with proven ability to prepare, maintain and publish ETL documentation, including source-to-target mappings and business-driven transformation rules.
• Strong understanding of business processes and transactional systems within the business domain.
• Demonstrated ability to understand and prioritize user and business requirements, and to conceptualize information processing solutions in response to them, including analyze, scope and define work effort required to correct program deficiencies and problems.
• Strong interpersonal relationship management skills, a team player with a client/user orientation.
• Excellent oral and written communication skills with demonstrated ability to effectively communicate complex ideas/processes in simple terminology to internal and external stakeholders, including all levels of management.
• Strong quantitative, analytical, and problem solving skills.
• Demonstrated attention to detail and maintaining high quality standards.
• Excellent organizational skills with proven ability to plan and execute complex projects.
• Ability to work to independently, meeting deadlines under pressure, with minimal supervision and frequent interruptions.
• Ability to teach, coach and mentor others.
• Physical ability to perform the duties of the position.

• Competitive Pay: $76,111 - $109,409 per year, depending on experience  

• Growth opportunities: We welcome individuals at all stages of their career, offering opportunities for professional development and growth. 

• State-of-the-art facilities:  The new St. Paul’s Hospital and health campus will be the most innovative approach to the delivery of integrated care in B.C. and Canada, designed to appropriately address the future health needs of patients, families, and our communities. From hospital care to primary and community health solutions, the new St. Paul’s Hospital and health campus will continue to lead innovations in care, research, and teaching. The new St. Paul’s Hospital is expected to open in 2027. 

• Inclusive culture: We respect the diversity, dignity and interdependence of all persons. We value the cultural richness that our diverse workforce brings to the care of our equally diverse population of patients and residents. 

• Meaningful impact: You will have the opportunity to work for an organization that is deeply committed to safeguarding of our surrounding environment by contributing to high quality care while promoting sustainable practices in your everyday work. 

• A comprehensive health benefits package including dental, vision, and life insurance as well as pension. 

Who We Are 

Providence Health Care is one of the largest faith-based health care organizations in Canada. For the people at Providence, living our Mission, Vision and Values means providing British Columbians with compassionate, socially just, exceptional and innovative care every day.  

From our humble roots 129 years ago, Providence Health Care has grown into a globally recognized leader in research, teaching, and care. As individuals within a mission-driven organization, we choose to be part of PHC because we value its long-standing dedication to social justice and compassionate care, its active efforts to advance environmental sustainability and planetary health, and its meaningful engagement in the process of Truth and Reconciliation with Indigenous Peoples. Curious about our culture and what it’s really like to work here? Check out the video below to meet some of the incredible people who make Providence a truly special place to work.  

Your day to day:

Reporting to the Manager, Data Analytics and Reporting, the BI Developer-Analyst is responsible for developing and maintaining BI solutions, including Extract, Transform, Load (ETL), reports, dashboards, and analytical solutions to support effective use of data by PHC clinical and non-clinical programs, Senior Leadership Team (SLT) and other key stakeholders. Responsibilities include dashboard development, database development and monitoring, data modeling, data dictionary development and maintenance, application development, documentation, maintenance of users and user permission, performing routine periodic processing activities related to key decision support applications, participating in the design, writing, production, and documentation of standard and ad hoc queries and reports, problem identification, analyzing healthcare data and communicating the findings through the use of data visualization and storytelling. The BI Developer-Analyst works closely with colleagues to audit, identify and follow-up on issues related to data quality, metric definitions or process deficiencies. The BI Developer-Analyst acts as a key interface between Data Analytics Leads, Solutions Architect and the Data Analytics (Decision Support) teams at our partner organizations, as well as the Information Management, Information Technology (IM/IT) departments to ensure the solutions meet the business requirements and the technical specifications and adhere to team standards. This role requires a strong foundation in analytical methods, data warehousing, data visualization and statistics. The position requires access to detailed and confidential information of all types (clinical, financial, payroll, etc.).

• Designs, develops and maintains dashboards, databases, ETL, reports and other BI content and analytical solutions 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.
• Participates in the VCH/PHC regional and PHC local Data Warehouse development lifecycle including: planning, development, testing, migration and production support development activities.
• Design, develop and support all extraction and integration processes (ETL).
• Design and build interactive and static data visualizations to provide insights
• Liaise with team members and/or other stakeholders to determine analytical solutions requirements including understanding inefficiencies in existing business applications and future business needs.
• Extract, manipulate and analyze complex information from multiple data sources / systems using a variety of software (e.g., R, SQL, Python)
• Conduct statistical analysis and hypothesis testing to improve forecasting, targeting and performance measurement
• Assist with data-related technical challenges and perform root-cause analysis to answer specific business questions and recommend and implementing ways to improve data reliability, efficiency and quality.
• Maintain a repository of metadata and lineage information about how data flows through its lifecycle.
• Contribute to the development and documentation of data management standards framework.
• In consultation with the Solutions Architect, provides input into the logical design and development of PHC Local Data Warehouse data models to be used for reporting and information delivery.
• Collaborates with Database Administrators, Systems Analysts, and Solutions Architect to identify, analyze and rationalize internal and external data sources and ETL strategies.
• Performs technical analysis and prepares and implements recommended ETL design approach.
• Prepares and validates end-to-end business logic and mappings.
• Develops, tests, documents and implements proposed analytical solutions (e.g., reports and dashboards).
• Responds to ad-hoc, on-demand and scheduled business user information requests as they relate to services and support provided by the business groups.
• Produces and maintains core PHC management reports, departmental dashboards and related management tools.
• Adapts ETL processes as necessary to accommodate changes in source systems and target business user requirements.
• Maintains and administers PHC organizational development key performance indicators data and reports.
• Supports and maintains migration of data to data mart from source systems.
• Develops, maintains and schedules ETL data flows/workflows/jobs, and provides daily support of these processes once implemented.
• Works with business users to validate rules regarding data integrity and data quality as it relates to the impact on business needs.
• Debugs, monitors and troubleshoots business solutions to resolve production issues.
• Liaises with other IT Development and Operations departments to clarify and build applications that meet business unit objectives.
• Administers security settings and access to the data mart and related systems.
• Supports all business users with the use of data mart tools and in deployment activities such as user acceptance testing, user training, product demos and product evaluation.
• Performs other duties as assigned.

We acknowledge that Providence Health Care & the new St. Paul’s Hospital site is located on the traditional, ancestral, and unceded territory of the Coast Salish Peoples, including the territories of the xʷməθkwəy̓əm (Musqueam), Skwxwú7mesh (Squamish), and Səl̓ílwətaʔ/Selilwitulh (Tsleil-Waututh) Nations.