Reporting to the Business Operations Coordinator, the Database Coordinator ensures consistent and accurate use of SPR-specific information management systems and interpretation of SPR data in compliance with Agency and Program policies. The Database Coordinator utilizes a variety of computerized database and query tools, spreadsheet, graphics and statistical analysis software to perform data retrieval from the SPR databases and perform analysis for operational performance reporting, quality improvement activities and assigned research projects. Provides feedback regarding data quality, liaises with other departments or healthcare professionals to ensure that procedures and policies are followed and improved as needed, and contributes to the initiation, ongoing development and delivery of high quality information to support the strategic objectives of the Program. Provides support for the use of SPR -specific information management systems by other SPR staff for the provision of routine clinical care.
What you’ll do:
Use a variety of computerized database and query tools, spreadsheet, graphics and word processing software to prepare routine and ad hoc reports or statistical information. Perform data quality checks by random audits and by utilizing a variety of computerized database query and statistical analysis tools such as MS Access, SQL, SAS, and SPSS to perform data retrieval from one or multiple databases. Retrieve and extract data, analyze and summarize statistical information, perform calculations and tallies. Record information and prepare and generate reports as directed or needed.
Develop and maintain operational related documentation including training documents, data dictionaries, processes and standard operation procedures to support applicable SPR information management systems. Provide end-user training and support including assisting with troubleshooting, identifying options and implementing appropriate action including escalating issues for technical assistance. Maintain communication with users and documents incidents.
Perform routine privacy audits in accordance with confidentiality and privacy requirements.
Perform testing and system validation to ensure functionality and compliance to defined expectations.
Perform data management functions to ensure accuracy and quality of information management systems, including importing files, validating data, clarifying discrepancies and editing/correcting/inputting data.
Clarify data needs with requesters, prioritize requests in conjunction with manager, perform data extraction or analysis, provide and review output with requesters. Provide training to staff to ensure staff clearly understand data entry requirements and database functionality. Provide recommendations and input into database development to Program Leadership.
What you bring:
A level of education, training and experience equivalent to a Bachelor's degree in Science, Statistics, Health Information, Business or related discipline plus two years of recent experience with database management, use of database querying tools and technical documentation.
Advanced database management and computer literacy. Demonstrated experience in database query and statistical analysis tools.
High degree of competency with Excel, Word and Visio.
Demonstrated ability to communicate effectively both verbally and in writing. Strong interpersonal and collaboration skills and the ability to establish and maintain effective working relationships internally and externally.
Excellent troubleshooting and organizational skills as well as great attention to detail. Capable of identifying problems and developing creative solutions.
Ability to work under pressure with a diverse group of people, policies and procedures.
Demonstrated ability to be self-directed, express initiative yet work well within a team environment. Demonstrated ability to handle multiple concurrent assignments.
What’s in it for you:
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 and development.
Access to more than 2,000 in-house training programs.
Enjoy a comprehensive benefits package, including municipal pension plan.
12 annual statutory holidays with generous vacation entitlement and accruement.
Perks include onsite fitness classes and discounts to 350 BC-wide recreational programs, travel, technology, car and bike sharing, and more.
Job type: Regular Full-Time
Location: 1333 W. Broadway Vancouver, BC
Closing date: Open until position is filled
Reference number: 104474E
About Us
The Provincial Health Services Authority (PHSA) is part of the Provincial Health Services Authority (PHSA). PHSA provides specialized health services to British Columbians, including cancer care, organ transplantation, pediatrics, emergency services, mental health and substance use services. 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: https://jobs.phsa.ca/programs-and-services
We hire on the basis of merit and encourage all qualified applicants 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, backgrounds and experiences. We strive to create a safe and welcoming environment where everyone can come to work and be their best, authentic self.