Business Intelligence Database Analyst, PH Data - BC Centre for Disease Control

Business Intelligence Database Analyst, PH Data

BC Centre for Disease Control

Vancouver, BC

Are you ready to make a difference? The BC Centre for Disease Control, a dynamic Provincial Health Services Authority program, seeks passionate individuals to join us in providing provincial and national leadership in disease surveillance, detection, treatment, prevention, and consultation.

At our core, we aim to cultivate vibrant communities where everyone can achieve optimal health and well-being—right where they live, work, learn, and play.

If you're driven by the desire to create positive change and contribute to healthier communities, this is the opportunity you've been waiting for! Apply now to join our innovative team and make a difference that matters.

What you’ll do

• Design and develop reports to deliver “BI” (Business Intelligence) to the end users.
• Collaborate with Database Administrators, Systems Analysts, Surveillance Analysts and Biostatisticians to identify, analyze and rationalize internal and external data sources and ETL strategies.
• Assist the Business Analysts and Application Analyst to develop and maintain a current mapping between the data dictionary and the database structure/map.
• Design and sustain a coherent Integrated Data model and data mart that supports the BI needs of various customers.
• Support the Business Analysts, Application Analysts and PHSA IM/IT teams in rollout activities such as user acceptance testing, user training, product demos and product evaluation.
• Administer security settings and access to BI reports, cubes and overall system. Analyzes system performance and provides recommendations for the development of capacity plans for the existing application.
• Conduct analysis related to data conversion routines and system interfaces.
• Support operational requirements by assembling, creating and maintaining the required set of information systems technical and operational documentation, according to departmental standards.
• Develop user documentation and maintains system, report and licensing documentation.
• Collaborate with PHSA IM/IT regarding server maintenance, upgrades, system failures, backups and disaster recovery planning.
• Liaise with BI vendor(s) to resolve issues, and may negotiate license contracts, and participate in contract negotiations with vendors in conjunction with senior staff or managers.
• Participate in the analysis, definition of and user acceptance of report criteria, development, testing, training, implementation and maintenance of assigned projects.
• Provide advice on methods to improve performance efficiencies through the use of automated tools and revised work processes.
• Act as key contact and trainer for BI users of all skill levels on data reports and data retrieval using BI tools. Develop, update and coordinate the preparation of educational and training materials and provides education and instruction in the use of the BI tools.
• Develop and modify Panorama reports to support regional and provincial level reporting.
• Support other report developers and ensure high quality reporting through reviewing the assumptions, calculations and report design.
• Manage, modify and maintain operations for the reporting database and data warehouse environment and escalates system issues.
• Implement system, catalog, security, report and cube upgrades.
• Extract data for ad-hoc requests.
• Build and publish scheduled batch procedures to automate routine BI tasks. Monitor scheduled reports and cubes.
• Design, build, publish, configure and secure OLAP cubes.
• Monitor servers and systems for availability, logical and physical performance.
• Participate in Data Standards Group and Panorama meetings and communicates important system, report and cube changes.

What you bring

Qualifications

• A level of education, training, and experience equivalent to Bachelor’s Degree in Computer Science, Information Technology or related field and five (5 years of experience in BI/data modeling, including working directly with end users (clinicians, managers, senior executives) to produce data models and reports that produce real business results.

You will also have

• Advanced knowledge of BI Tools and applied knowledge of SQL Server. Knowledge of OLAP architecture and multidimensional database design techniques.
• Proven hands-on experience with standard data warehousing/data mart and Business Intelligence tools, Microsoft SQL Server, including queries, stored procedures, and when to use triggers/views, and SQL, Oracle, XML, HTML, DHTML, client/server and Web development.
• Excellent interpersonal, oral and written communication skills with the ability to communicate complex ideas in simple terminology. 
• Ability to understand and clearly relate technical information and principals of operation to other members of the organization. 
• Ability to analyze operational problems and recommend innovative solutions, demonstrating time management skills.
• Proven ability to plan and execute complex projects with stringent budgets and timelines.
• Physical ability to perform the duties of the position.
• 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).
• 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’s why we’re focused on your care too – offering health, wellness, development programs to support you – at work and at home.

• Join one of BC’s largest employers with province-wide programs, services and operations – 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’yas 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: $74,618 - $107,264/year. The starting salary for this position would be determined with consideration of the successful candidate’s 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: 655 West 12th Avenue, Vancouver BC, V5Z 4R4
Applications will be accepted until position is filled.
Hours of Work: Monday – Friday, 0900 - 1700
Requisition # 165079E

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 BC Centre for Disease Control (BCCDC) is dedicated to preventing and controlling communicable diseases and promoting environmental health for the province of BC.

BCCDC is part of the Provincial Health Services Authority (PHSA).

The Provincial Health Services Authority (PHSA) 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 – Be compassionate – Dare to innovate – Cultivate partnerships – Serve with purpose. Learn more about PHSA and our programs: jobs.phsa.ca/programs-and-services

PHSA and BCCDC are 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’ unanimous passage of the Declaration on the Rights of Indigenous Peoples Act was a significant step forward in this journey—one 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 May 13^th, 2024. 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 – 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.