BI Developer-Analyst - #232137

Summary

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. The current scheduled end date for this temporary position is October 1st, 2027. This posting is scheduled to close at 11:59PM on Friday, July 31st.

What you will be doing

• Supporting automation and analytics initiatives:Collaborating on projects involving automation, process improvement, application development, and innovative solutions that enhance business operations.
• Developing data solutions and visualizations: Designing and maintaining dashboards, reports, data models, and analytical solutions that transform complex data into meaningful insights for decision-making.
• Building and optimizing data workflows: Developing and supporting ETL processes, data integrations, queries, and data structures to improve data quality, reliability, and accessibility.
• Partnering with stakeholders to solve data challenges: Working with Data Analytics teams, business users, and technical partners to understand requirements, troubleshoot issues, and deliver solutions that meet organizational needs.

What You Bring

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.

What We Offer

• 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.