Business Intelligence Database Analyst, Ph Data

2 weeks ago

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, prevention, and consultation.

At our core, we aim to cultivate vibrant communities where everyone can achieve optimal health and well-being—right where they live, work, learn, and play.

**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.
- 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.
- Liaise with BI vendor(s) to resolve issues, and may negotiate license contracts, and participate in contract negotiations with vendors in conjunction with senior staff or managers.
- Participate in the analysis, definition of and user acceptance of report criteria, development, testing, training, implementation and maintenance of assigned projects.
- Provide advice on methods to improve performance efficiencies through the use of automated tools and revised work processes.
- Act as key contact and trainer for BI users of all skill levels on data reports and data retrieval using BI tools. Develop, update and coordinate the preparation of educational and training materials and provides education and instruction in the use of the BI tools.
- Develop and modify Panorama reports to support regional and provincial level reporting.
- Support other report developers and ensure high quality reporting through reviewing the assumptions, calculations and report design.
- Manage, modify and maintain operations for the reporting database and data warehouse environment and escalates system issues.
- Implement system, catalog, security, report and cube upgrades.
- Extract data for ad-hoc requests.
- Build and publish scheduled batch procedures to automate routine BI tasks. Monitor scheduled reports and cubes.
- Design, build, publish, configure and secure OLAP cubes.
- Monitor servers and systems for availability, logical and physical performance.
- Participate 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 (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.

You will also have
- 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.
- 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 historica

  • Business Intelligence Database Analyst, Ph Data

    3 weeks ago

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

  • Business Intelligence Database Analyst

    3 weeks ago

    Vancouver, Canada PHSA Full time

    **Job Summary**: 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...

  • Business Intelligence Database Analyst

    4 weeks ago

    Vancouver, Canada PHSA Full time

    **Business Intelligence Database Analyst** BC Centre for Disease Control Vancouver, BC The Business Intelligence Database Analyst is responsible for the planning, design, development and management of new and existing reporting database systems. Reporting to the Manager, the Business Intelligence Database Analyst applies a broad range of information...

  • Business Intelligence Analyst

    4 weeks ago

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

  • Business Intelligence Analyst

    23 hours ago

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

  • Business Intelligence Analyst

    2 months ago

    Vancouver, Canada T-Net British Columbia Full time

    We are currently looking for a new Business Intelligence Analyst to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations.What your team does:Our Business Intelligence team is part of the larger Data & AI group. Together, we're focused on stewarding a scientific culture to drive better decisions. Along with the Manager of...

  • Business Intelligence Analyst

    2 months ago

    Vancouver, Canada T-Net British Columbia Full time

    We are currently looking for a new Business Intelligence Analyst to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations.What your team does:Our Business Intelligence team is part of the larger Data & AI group. Together, we're focused on stewarding a scientific culture to drive better decisions. Along with the Manager of...

  • Business Intelligence Analyst

    2 months ago

    Vancouver, Canada T-Net British Columbia Full time

    We are currently looking for a new Business Intelligence Analyst to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations.What your team does:Our Business Intelligence team is part of the larger Data & AI group. Together, we're focused on stewarding a scientific culture to drive better decisions. Along with the Manager of...

  • Business Intelligence Analyst

    3 weeks ago

    Vancouver, Canada T-Net British Columbia Full time

    We are currently looking for a new Business Intelligence Analyst to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations.What your team does:Our Business Intelligence team is part of the larger Data & AI group. Together, we're focused on stewarding a scientific culture to drive better decisions. Along with the Manager of...

  • Business Intelligence Analyst

    3 weeks ago

    Vancouver, Canada T-Net British Columbia Full time

    We are currently looking for a new Business Intelligence Analyst to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations.What your team does:Our Business Intelligence team is part of the larger Data & AI group. Together, we're focused on stewarding a scientific culture to drive better decisions. Along with the Manager of...

  • Business Intelligence Analyst

    2 months ago

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

  • Business Intelligence Analyst

    2 days ago

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

  • Business Intelligence Analyst

    7 days ago

    Vancouver, British Columbia, Canada Clio Full time

    Cliois more than just a tech company-we are a global leader that is transforming the legal experience for all bybettering the lives of legal professionalswhileincreasing access to justiceSummary:We are currently looking for a new Business Intelligence Analyst to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations.What...

  • Analyst, Business Intelligence

    4 weeks ago

    Vancouver, Canada Vancouver Whitecaps FC Full time

    **Position Title**:Analyst, Business Intelligence** **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.** The...

  • Analyst, Business Intelligence

    2 weeks ago

    Vancouver, Canada Vancouver Whitecaps FC Full time

    **Position Title**:Analyst, Business Intelligence** **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.** The...

  • Data Modeller, Business Intelligence

    1 week ago

    Vancouver, British Columbia, Canada CLIO Full time

    Job Title: Business Intelligence Analyst at ClioOur team at Clio, a dynamic and rapidly growing company, is seeking a skilled Business Intelligence Analyst to join our Data & AI group. As part of this team, you will play a crucial role in fostering a data-driven culture that leads to informed decision-making across all aspects of our organization.About...

  • Business Analyst

    1 week ago

    Vancouver, Canada PHS Community Services Society Full time

    BUSINESS ANALYST JOB SUMMARY Reporting to the Contracts and Systems Manager, the Business Analyst (BA) is responsible for providing a range of business and systems analysis and support to the Finance team and PHS Senior Management. Based on observation and critical analysis of data, this position plays a key role in digitization, integration and efficient...

  • Business Intelligence Intern

    1 week ago

    Vancouver, British Columbia, Canada Clarius Mobile Health Full time

    Business Intelligence Intern – Summer 2024A Career at ClariusToday, 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...

  • Analyst, Business Intelligence

    4 weeks ago

    Vancouver, Canada Whitecaps Football Club Ltd Full time

    Position Title: Analyst, Business Intelligence 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. The Analyst, Business Intelligence...

  • Analyst, Business Intelligence

    4 weeks ago

    Vancouver, Canada Whitecaps Football Club Ltd Full time

    Position Title: Analyst, Business Intelligence 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. The Analyst, Business Intelligence...