The BC Centre for Disease Control (BCCDC) provides provincial and national leadership in public health through surveillance, detection, prevention and consultation and provides both direct diagnostic and treatment services to people with disease of public health importance.
The BCCDC is an agency of the Provincial Health Services Authority (PHSA), which plans, manages and evaluates selected specialty and province-wide health care services across BC. PHSA embodies values that reflect a commitment to excellence. These include: Patients first • Best value • Results matter • Improvements through knowledge • Open to possibilities.
Business Intelligence Database Analyst
Vancouver, British Columbia
Delivering Business Intelligence (BI) to the end user, you will plan, design, develop and manage reporting database systems related to iPHIS (integrated Public Health Information System). Collaborating with Database Administrators, Systems Analysts, Surveillance Analysts and Biostatisticians, you will identify, analyze and rationalize internal and external data sources as well as ETL strategies. BI users will look to you for training on using BI tools for data reports and data retrieval. As well, you will assist the Business Analysts and Application Analyst in developing and maintaining a current mapping between the data dictionary and the database structure/map. Supporting the needs of various customers, you will design and sustain a coherent Integrated Data model and data mart, and conduct analysis related to data conversion routines and system interfaces. As the liaison with BI vendors, you will resolve issues and participate in contract negotiations, as well as develop documentation.
Demonstrating a broad range of information technology experience and BI knowledge, you have a Bachelor’s degree in Computer Science, Information Technology or related field and 5 years of BI/data modeling experience. Your experience includes working directly with end users (clinicians, managers, senior executives) to produce data models and reports that produce real business results. As well, you have proven hands-on experience with standard data warehousing/data mart and BI tools, Microsoft SQL Servers, including queries, stored procedures, and when to use triggers/views, and SQL, Oracle, XML, HTML, DHTML, client/server and web development. Knowledge of OLAP architecture and multidimensional database design techniques is required. Able to communicate complex ideas in simple terms, you can clearly relate technical information and principals of operation and recommend innovative solutions to a variety of audiences.
We invite you to apply by clicking the "Apply Online Now" button where you can register for the first time or enter your Username and Password in order to re-access your profile on our system.
Applications will be accepted until the position is filled.
For more information on all that the PHSA has to offer, please visit: http://careers.phsa.ca
For more information about the Agency that you are interested in, please visit the website at: www.bccdc.org.
The PHSA is committed to employment equity and hires on the basis of merit. We encourage applications from all qualified individuals, including Aboriginal peoples, persons with disabilities