Business Intelligence Database Analyst, Information Management and Surveillance

BC Centre for Disease Control

Vancouver, BC

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

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.
• Advanced knowledge of BI Tools and applied knowledge of SQL Server. Knowledge of OLAP architecture and multidimensional database design techniques.

You will also have

• 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: $72,445 - $104,139/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 # 152075E

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