Business Intelligence Database Analyst

2 weeks 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

  • Business Intelligence Database Analyst

    5 days 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 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

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

  • Business Intelligence and Reporting Analyst

    7 days ago

    Metro Vancouver Regional District, Canada First Nations Health Authority Full time

    **FNHA Overview**: **About us** The First Nations Health Authority is a diverse and transformational health organization of professional, innovative, and dedicated team members and leaders. The first of its kind in Canada, FNHA works as a health-and-wellness partner with BC First Nations to support self-determination and decision-making to improve health...

  • Business Intelligence SQL Consultant

    3 weeks ago

    Vancouver, BC, 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. 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...

  • Business Intelligence Analyst

    3 weeks ago

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

  • Business Intelligence Specialist

    3 days ago

    Vancouver, Canada First Canadian Insurance Corporation Full time

    First Canadian is a national organization and we are experiencing unprecedented growth! We aim to hire bright, hard-working people who share our values. We seek employees who are committed to learning, career growth, and opportunity. We take pride in being an organization that our employees support long-term. We believe in our employees and celebrate their...

  • Data Architecture

    4 weeks ago

    Vancouver, Canada PHSA Full time

    **Data Architecture & Business Intelligence Lead** PHSA Corporate Vancouver, BC 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...

  • Business Development Representative

    10 hours ago

    Vancouver, Canada Blockchain Intelligence Group Full time

    Blockchain Intelligence Group Inc. (subsidiary of public company BIGG Digital Assets Inc., CSE: BIGG) is headquartered in Vancouver, British Columbia. We help global customers in law enforcement, government agencies, financial institutions and cryptocurrency businesses mitigate risk, stay compliant, and investigate illicit activity on the blockchain. We are...

  • Manager, Business Intelligence

    7 days ago

    Vancouver, Canada Rocky Mountainer Full time

    Purpose The Manager, Business intelligence is a key driver and contributor to the company in providing expertise in the field of data management, dashboarding and reporting, helping the company draw critical insights from all sources of collected data. The role’s primary focus is on the design and development of cross functional strategic dashboards,...

  • HR Systems and Business Analyst

    3 weeks ago

    Vancouver, Canada Providence Healthcare Full time

    **Article Flag: Mandatory Vaccination Please Note**: As per the current Public Health Orders (Long Term Care/Seniors Assisted Living Provincial Health Order and the Health Sector Order), as of October 26, 2021, all employees working for Providence Health Care must be fully vaccinated against COVID-19. Proof of vaccination status will be...

  • Data and Business Information Analyst

    6 days ago

    Vancouver, Canada HSBC Full time

    Opening up a world of opportunity. We're a financial services organization serving more than 40 million customers across the globe through our Wealth & Personal Banking, Commercial Banking and Global Banking & Markets businesses. We’re here to use our unique expertise, capabilities, breadth and perspectives to open up a world of new opportunities for our...

  • Business Analyst

    3 weeks ago

    Vancouver, British Columbia, Canada TEEMA Full time

    Job Title: Business AnalystJob ID: PL Location: Vancouver, BCOverview:The Business Decision Support Professional facilitates complex decision-making in support of the design and implementation of business change or improvement initiatives. The Business Decision Support Professional is most likely an expert in business, specializing in a particular field such...

  • Business Data Analyst

    2 weeks ago

    Vancouver, Canada Rocky Mountainer Full time

    Purpose The Business Data Analyst reports into the Manager, Analytics. This position is a key point of contact for business support analytics. The primary focus of this role is to assist with business data analysis and internal reporting thereby identifying underlying opportunities to make Rocky Mountaineer better for our guests and travel...

  • Research Analyst

    1 day ago

    Vancouver, Canada Cushman & Wakefield Full time

    **Job Title** Research Analyst **Job Description Summary** Based in our Vancouver, British Columbia office, the Research Analyst is responsible for supporting the development of local research output and thought leadership by gathering, tracking, and analyzing local market data to derive insights for colleagues and clients. Specifically, this position is...

  • Advisory Analyst

    5 days ago

    Vancouver, Canada MLA Canada Full time

    **ABOUT MLA CANADA** MLA Canada is the most comprehensive real estate service provider in Canada. Partnering with residential developers, MLA Canada offers an unmatched level of expertise in advisory services, market intelligence, project marketing, sales, customer care and administration. From boutique projects to large masterplan communities, our diverse...

  • Business Analyst

    3 weeks ago

    West Vancouver, Canada CB Canada Full time

    Business Analyst, Technical On behalf of our Healthcare client, Procom Consultants Group is currently looking for a Business Analyst. Business Analyst Job Details• Works collaboratively with all business areas, applications and technology teams, and external partners, including client's stakeholders, to support in implementing key strategies and...

  • Business Analyst – Supply Chain

    4 weeks ago

    Vancouver, Canada Consolidated Fastfrate Inc. Full time

    Business Analyst – Supply Chain / Transportation About Fastfrate:Fastfrate Group has been providing industry-leading transportation services for more than 50 years. From what started as an LTL over-the-road and intermodal carrier, Fastfrate has grown into a diverse group comprised of multiple companies operating across Canada. This evolution allows us to...