Job Description

Specialist, Business Intelligence

BC Cancer Agency

Vancouver, BC

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 Sr Manager, Cancer Analytics and Performance Management, the Specialist, BI is responsible for providing advanced technical leadership and solution architecture in support of Business Intelligence (BI) activities and initiatives. The position designs leading edge approaches and guides the detailed implementation of these solutions from inception to completion. The position also contributes to the development, implementation and evaluation of training and business process improvement strategies to ensure that the BI environment and the various BI project processes and systems are working efficiently in order to improve transactional and reporting activities.

The Specialist provides input to the overall goals, objectives and operations of the department by providing feedback and recommendations specifically with respect to BI issues. The Specialist works across all levels of BC Cancer providing leadership and support in the area of BI development/maintenance and information reporting via dashboards, scorecards or reports.

What you\xe2\x80\x99ll do

• Architects and implements leading edge solutions to develop, enhance and improve the BI Program. This includes leading the design, creation, documentation and implementation of complex multidimensional cubes, reports and front-end interfaces which deliver information via the web to end users.
• Provides technical expertise in the development of the BI Solutions by assessing client needs/requirements, reviewing technical options, determining software architecture and leading all levels of the solution development and deployment. Ensures security and permission levels maintain patient, physician and data confidentiality.
• Maintains familiarity with the latest web technologies and an awareness of current information system trends and issues. Evaluates and recommends products or methods to deliver BI in an accurate, timely and user friendly manner.
• Mentors other developers and team members and provides technical and educational support to BI end users by developing training materials, delivering training sessions and training trainers.
• Collaborates with members PHSA Performance Measurement and Reporting\xe2\x80\x99s Data Architect and Data Integration team on conceptual design of databases and the development and implementation of solutions in the Enterprise Data Warehouse. Works with IMITS departmental staff and others to manage and maintain the BI servers and applications including system administration, maintenance and performance monitoring of various servers to ensure optimal uptime and production readiness.

What you bring

Qualifications

• A level of education, training and experience equivalent to a Bachelor\xe2\x80\x99s Degree in Health Information Science, Business, Computer Science or Management Information Systems from a recognized school plus a minimum of five (5) years of recent related BI work experience preferably in a healthcare environment.
• Expert knowledge and understanding of relational and multidimensional (OLAP) databases as well as proven knowledge and experience in working with SQL Server or Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), Performance Point, Sharepoint, Visual Studio , etc. Experience in the development and maintenance of popular BI platforms including Power BI and Tableau. Ability to create and understand complex T-SQL and MDX queries and previous administrative experience setting up new users and monitoring performance. Proficiency in scripting and computer programming foundations. Knowledge of web authoring technology such as JavaScripts, HTML, and ASP .NET, AJAX is also required. High level of expertise in Microsoft Office suite of applications.
• Ability to understand management reporting and statistical concepts. Ability to apply machine learning and/or natural language processing (NLP) concepts is a bonus. Strong analytical, problem solving and system analysis skills. Demonstrated ability to analyze operational problems and recommend innovative solutions. Self-directed and motivated to learn new technology (including hardware, software applications and programming applications) and stay up-to-date on new analytics solutions. Can identify and implement creative data visualizations for specific end-user needs. 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. Ability to be customer service focused. Excellent interpersonal and communication skills. Physical ability to perform the duties of the job.

Skills & Knowledge

• Commitment to upholding the shared responsibility of creating lasting and meaningful reconciliation in Canada as per TRC (2015) and BC\'s Declaration on the Rights of Indigenous Peoples Act (2019).
• As a strong asset for consideration, we are looking for our successful candidate to have: Knowledge of social, economic, political and historical realities impacting indigenous communities and familiarity with Indigenous Cultural Safety and anti-racism and accompanying reports (BC DRIPA, TRC, etc.).

What we bring

Every PHSA employee enables the best possible patient care for our patients and their families. Whether you are providing direct care, conducting research, or making it possible for others to do their work, you impact the lives of British Columbians today and in the future. That\xe2\x80\x99s why we\xe2\x80\x99re focused on your care too \xe2\x80\x93 offering health, wellness, development programs to support you \xe2\x80\x93 at work and at home.

• Join one of BC\xe2\x80\x99s largest employers with province-wide programs, services and operations \xe2\x80\x93 offering vast opportunities for growth, development, and recognition programs that honour the commitment and contribution of all employees.
• Access to professional development opportunities through our in-house training programs, including +2,000 courses, such as our San\xe2\x80\x99yas Indigenous Cultural Safety Training course, or Core Linx for Leadership roles.
• Enjoy a comprehensive benefits package, including municipal pension plan, and psychological health & safety programs and holistic wellness resources.
• Annual statutory holidays (13) with generous vacation entitlement and accruement.
• PHSA is a remote work friendly employer, welcoming flexible work options to support our people (eligibility may vary, depending on position).
• Access to WorkPerks, a premium discount program offering a wide range of local and national discounts on electronics, entertainment, dining, travel, wellness, apparel, and more.

Job Type: Regular, Full-time

Salary Range: $72,445 - $104,139 /year. The starting salary for this position would be determined with consideration of the successful candidate\xe2\x80\x99s relevant education and experience, and would be in alignment with the provincial compensation reference plan. Salary will be prorated accordingly for part time roles.
Location: 601 W Broadway, Vancouver, BC V5Z 4C2
Closing date: Applications accepted until position is filled
Hours of Work: 0830-1630 (Monday to Friday)
Requisition # 152112E

As per the current Public Health Order, full vaccination against COVID-19 is a condition of employment with PHSA as of October 26, 2021.

What we do

The Provincial Health Services Authority ( ) plans, manages and evaluates specialized health services with the BC health authorities to provide equitable and cost-effective health care for people throughout the province. Our values reflect our commitment to excellence and include: Respect people \xe2\x80\x93 Be compassionate \xe2\x80\x93 Dare to innovate \xe2\x80\x93 Cultivate partnerships \xe2\x80\x93 Serve with purpose.

Learn more about PHSA and our programs:

PHSA is committed to employment equity, encouraging all qualified individuals to apply. We recognize that our ability to provide the best care for our diverse patient populations relies on a rich diversity of skills, knowledge, background and experience, and value a safe, inclusive and welcoming environment.

Reconciliation is an ongoing process and a shared responsibility for all of us. The BC Governments\xe2\x80\x99 unanimous passage of the Declaration on the Rights of Indigenous Peoples Act was a significant step forward in this journey\xe2\x80\x94one that all health authorities are expected to support as we work in cooperation with Indigenous Peoples to establish a clear and sustainable path to lasting reconciliation. True reconciliation will take time and ongoing commitment to work with Indigenous Peoples as they move toward self-determination. Guiding these efforts Crown agencies must remain focused on creating opportunities that implement the Truth and Reconciliation Commission Mandate.

ATTN: PHSA Employees:

To be considered as a PHSA employee (internal applicant) for this position, you must apply online via your internal profile at http://internaljobs.phsa.ca

Please note the internal job posting will no longer be accessible after the expiry date of September 20, 2023. If the internal job posting has expired, please contact the Internal Jobs Help Desk and advise that you would like to be considered as a late internal applicant for this position. Please do not apply for the external job posting.

If you have not registered your internal profile, a password is required to log in for the first time. To obtain your password, please contact the Internal Jobs Help Desk at 604-875-7264 or 1-855-875-7264. Please note regular business hours are Monday \xe2\x80\x93 Friday (excluding stats), 8:30am to 4:30pm. For inquiries outside of regular business hours, please email the Internal Jobs Help Desk at internaljobshelpu@phsa.ca and a Help Desk Representative will contact you the next business day.
Labor Agreement Excluded
Requisition # 152112E-2405233
Work Site 601 W.Broadway, Vancouver
Job Type Regular, Full-Time
Salary/Rate $72,445.00 - $104,139.00 / Year
FTE 1.00
Hours of Work 0830-1630
Work Days Mon, Tue, Wed, Thu, Fri
Expiry Date 12-Oct-2023

Provincial Health Services Authority