Business Intelligence Database Analyst

16 hours ago


Vancouver, Canada PHSA Full time

**Business Intelligence Database Analyst**

BC Centre for Disease Control

655 W 12th Ave, Vancouver, BC V5Z 4R4

In accordance with the Mission, Vision and Values, and strategic directions of Provincial Health Services Authority patient safety is a priority and a responsibility shared by everyone at PHSA, and as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.

The Business Intelligence Database Analyst is responsible for the planning, design, development and management of new and existing reporting database systems related to Panorama. Reporting to the Technical Manager, the Business Intelligence Database Analyst applies a broad range of information technology experience and Business Intelligence (BI) knowledge, to provide assistance to all Health Authorities and supports Surveillance Analysts, report builders and Data Analysts for report building, optimization, schema and data interpretation. This position plans, designs, and develops BI solutions, including Extract, Transform, Load (ETL) process, reports and data cubes. This position ensures the integrity and quality of the data accessible through these BI solutions, and also manages and maintains the overall Panorama existing BI system and its associated security.

**What you’ll do**
- Designs and develops reports to deliver “BI” (Business Intelligence) to the end users.
- Collaborates with Database Administrators, Systems Analysts, Surveillance Analysts and Biostatisticians to identify, analyze and rationalize internal and external data sources and ETL strategies.
- Assists the Business Analysts and Application Analyst to develop and maintain a current mapping between the data dictionary and the database structure/map.
- Designs and sustains a coherent Integrated Data model and data mart that supports the BI needs of various customers.
- Supports 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.
- Administers security settings and access to BI reports, cubes and overall system
- Conducts analysis related to data conversion routines and system interfaces.
- Supports operational requirements by assembling, creating and maintaining the required set of information systems technical and operational documentation, according to departmental standards.
- Develops user documentation and maintains system, report and licensing documentation.
- Collaborates with PHSA IM/IT regarding server maintenance, upgrades, system failures, backups and disaster recovery planning.
- Liaises with BI vendor(s) to resolve issues, and may negotiate license contracts, and participates in contract negotiations with vendors in conjunction with senior staff or managers.
- Participates in the analysis, definition of and user acceptance of report criteria, development, testing, training, implementation and maintenance of assigned projects.
- Provides advice on methods to improve performance efficiencies through the use of automated tools and revised work processes.
- Acts as key contact and trainer for BI users of all skill levels on data reports and data retrieval using BI tools. Develops, updates and coordinates the preparation of educational and training materials and provides education and instruction in the use of the BI tools.
- Develops and modifies Panorama reports to support regional and provincial level reporting.
- Supports other report developers and ensures high quality reporting through reviewing the assumptions, calculations and report design.
- Manages, modifies and maintains operations for the Panorama reporting data base and data warehouse environment and escalates system issues to Panorama Support.
- Implements system, catalog, security, report and cube upgrades.
- Extracts data for ad-hoc requests.
- Builds and publishes scheduled batch procedures to automate routine BI tasks. Monitors scheduled reports and cubes.
- Designs, builds, publishes, configures and secures OLAP cubes.
- Monitors servers and systems for availability, logical and physical performance.
- Participates 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 (5years 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.

Skills & Knowledge
- Proven hands-on experience with standard data warehousing/data mart and Business Intelligence tools, Microsoft SQL Server, including queries, stored pro



  • Vancouver, Canada PHSA Full time

    **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,...


  • Vancouver, Canada PHSA Full time

    **Business Intelligence Analyst** PHSA Corporate Vancouver, BC In accordance with the Mission, Vision and Values, and strategic directions of PHSA safety, including both patient and employee safety, is a priority and a responsibility shared by everyone at PHSA’s Agencies/Divisions/Services, and as such, the requirement to continuously improve quality...


  • Vancouver, Canada Clio Full time

    -Clio is more than just a tech company-we are a global leader that is transforming the legal experience for all by bettering the lives of legal professionals while increasing access to justice Summary: We are currently looking for a new Business Intelligence Analyst to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto...


  • Vancouver, Canada Visier Full time

    Overview: Visier is the leader in people analytics. We are passionate about a 'people first' approach to business strategy and our addictive technology is transforming the way that organisations make decisions. Recently closing a hugely successful funding round and a landmark $1b valuation, Visier is embarking on an incredible phase of its 12 year growth...


  • Vancouver, Canada People Corporation Full time

    We are seeking a Benefits Analyst/Business Intelligence Analyst to join our team in Vancouver. The Benefits Analyst will provide group benefits consulting support, including design and financial management for clients and prospects. The Benefits Analyst will work closely with internal consulting teams, interface with vendors, support client deliverables,...


  • Vancouver, Canada Vancouver Whitecaps FC Full time

    **Position Title**:Analyst, Business Intelligence & CRM** **Location**:788 Beatty Street, Vancouver, BC V6B 2M1** **Terms**:Full-time, Permanent** **Reports to**:Director, Business Intelligence** Vancouver Whitecaps FC is looking for a new team member to join our Business Intelligence department in the position of **Analyst, Business Intelligence &...


  • Vancouver, Canada Port of Vancouver Full time

    **JOIN US IN CHARTING A COURSE TO A MORE SUSTAINABLE FUTURE** Join an organization that plays a critical role in Canada’s economy. At the Vancouver Fraser Port Authority, we focus on doing the incredible work it takes to become the world’s most sustainable port. The Vancouver Fraser Port Authority is responsible for the stewardship of the Port of...


  • Vancouver, Canada West Fraser Full time

    West Fraser is a leading diversified North American forest products company. We are a growing Company looking for talented people to be part of our team. Our Information Technology group in Vancouver, BC has an opportunity for a: **BI Analyst - HCM** As part of the IT group, this role will the Business Intelligence (BI) Developer to create and manage Cognos...


  • Vancouver, Canada Alquemy Search & Consulting Full time

    Job Title: Business Intelligence Data Analyst About the Job:We are seeking a skilled Business Intelligence Data Analyst to join our team in Calgary, Alberta. As a key member of our data analysis team, you will be responsible for testing and validating data sources and reports built by our developers, both manually and through automated testing.The ideal...


  • Vancouver, Canada Clarius Mobile Health Full time

    **A Career at Clarius** Today, as many as 25 million medical professionals globally don’t have access to medical imaging, which is proven to improve patient care and reduce healthcare costs. That’s why we’re on a mission to make medical imaging accessible everywhere by delivering high-performance, affordable, and easy-to-use solutions powered by...


  • Vancouver, Canada PHSA Full time

    **Business Intelligence Database Analyst, PH Data** BC Centre for Disease Control Vancouver, BC **What you’ll do** *** - Receive incoming specimens and requisitions and checks for accuracy and completeness of information such a personal health number, name, date of birth and tests required, assigns laboratory numbers, and assembles into work batches...


  • Vancouver, Canada Mitacs Full time

    **_Do you want to be part of our innovative and entrepreneurial team?_** - Do you thrive in an entrepreneurial environment and enjoy working in a team atmosphere? Are you an “outside the box” thinker who strives to implement continuous improvements? Do you take a strategic approach to your work? Do you enjoy working in a fast-paced culture where your...


  • Vancouver, Canada Vancouver Fraser Port Authority Full time

    **JOIN US IN CHARTING A COURSE TO A MORE SUSTAINABLE FUTURE** Join an organization that plays a critical role in Canada’s economy. At the Vancouver Fraser Port Authority, we focus on doing the incredible work it takes to become the world’s most sustainable port. The Vancouver Fraser Port Authority is responsible for the stewardship of the Port of...


  • Vancouver, Canada CDW Full time

    **What you'll do** *** - Design and develop dashboards and reports in data visualization tools (e.g. PowerBI) for various audiences to track performance on leading and lagging indicators - Identify opportunities where data can support decision making and solution/deliver reports and analyses - Automate existing manual reports and suggest process...


  • Vancouver, British Columbia, Canada Insight Global Full time

    About Insight Global: As a global workforce solutions company, Insight Global provides exceptional talent to leading organizations in various industries.Job Overview: We are seeking an experienced Business Intelligence Data Analyst to join our team and support our client's People and Culture department.Key Responsibilities:To oversee daily reporting duties...


  • Vancouver, British Columbia, Canada Vancouver Airport Authority Full time

    Unlock Your Potential as a Senior Business AnalystWe are seeking an experienced Senior Business Analyst to lead our Business Intelligence team. As a key member of our Enterprise Advanced Analytics Department, you will be responsible for driving business value through the development and implementation of strategic BI solutions.About the Role:Collaborate with...


  • Vancouver, Canada Wesgroup Properties Full time

    Wesgroup Properties started as a family business in British Columbia more than 60 years ago and today is one of Western Canada’s largest private real estate companies with a diversified portfolio spanning across residential and commercial real estate. Wesgroup owns and manages over 3.2 million square feet of commercial and multi-family real estate and has...


  • North Vancouver, Canada District of North Vancouver Full time

    **Database Administrator/Analyst**: **3 Year Temporary Full-Time** Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of **BC’s Top Employers **for 4 years, the District offers exciting professional...


  • North Vancouver, Canada District of North Vancouver Full time

    **Database Administrator/Analyst**: **3 Year Temporary Full-Time** Home to vast parkland and attractions including Grouse Mountain, Lynn Canyon and Capilano Suspension Bridge, the District of North Vancouver is inspired by nature, and enriched by people. Designated one of **BC’s Top Employers **for 4 years, the District offers exciting professional...

  • Junior Data Analyst

    1 week ago


    Vancouver, Canada Aboriginal Business Law Full time

    Job Summary: The Database Analyst will maintain data storage; assess database design; and gather, organize, and interpret statistical information based on the data in the database. Supervisory Responsibilities: - None. Duties/Responsibilities: - Oversees database development and modification efforts. - Designs and implements secure, efficient, and...