Business Intelligence Database Analyst
BC Centre for Disease Control
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 provide 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.
What you bring
A Bachelor’s Degree in Computer Science, Information Technology or related field
Minimum of 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.
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.
You will have the ability to:
Understand and clearly relate technical information and principals of operation to other members of the organization.
Analyze operational problems and recommend innovative solutions, demonstrating time management skills.
Plan and execute complex projects with stringent budgets and timelines.
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.
655 West 12th Avenue, Vancouver
Applications will be accepted until position is filled.
Monday to Friday from 8:30 - 16:30
Requisition Number: 95678
What we do
BC Centre for Disease Control (BCCDC) bccdc.ca is dedicated to preventing and controlling communicable disease and promoting environmental health for the province
Provincial Health Services Authority plans, coordinates 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 is committed to employment equity and hires on the basis of merit, 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, backgrounds and experiences, and value a safe, inclusive and welcoming environment.
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 Jul7 7, 2020. 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 firstname.lastname@example.org and a Help Desk Representative will contact you the next business day.