Business Intelligence Database Analyst, Ph Data

6 months 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

    6 months 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 Analyst

    6 months 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

    6 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 Data Analyst

    2 weeks ago

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

  • Business Intelligence Analyst and Data Strategist

    1 month ago

    Vancouver, British Columbia, Canada PHSA Full time

    Job DescriptionWe are seeking a highly skilled Business Intelligence Analyst and Data Strategist to join our team at PHSA. As a key member of our organization, you will be responsible for analyzing and interpreting complex data to inform business decisions and drive strategic initiatives.Key Responsibilities:Develop and implement data-driven solutions to...

  • Business Intelligence Program Manager, Ph Data

    4 months ago

    Vancouver, Canada PHSA Full time

    **Business Intelligence Program Manager, 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,...

  • Benefits Analyst/business Intelligence Analyst

    2 months ago

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

  • Analyst, Business Intelligence

    2 months ago

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

  • Business Intelligence Program Manager, Ph Data

    4 months ago

    Vancouver, Canada BC Centre for Disease Control Full time

    Business Intelligence Program Manager, 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,...

  • Business Intelligence Analyst

    6 months ago

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

  • Data Modeller, Business Intelligence

    6 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 Data Modeller to join our Business Intelligence team in one of our Vancouver, Calgary, or Toronto locations. What your...

  • Business Intelligence Analyst

    2 months ago

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

  • Data Architecture

    1 week ago

    Vancouver, Canada PHSA Full time $88,990 - $127,923

    What you’ll doManages teams of designated Data Warehouse and Business Intelligence Specialists, Business Analysts, and contractors to develop and implement high-quality solutions that meet the Enterprise Data Architecture standards. Establishes clear definitions of responsibility for each employee, reviews workload assignments, and adjusts schedules...

  • Data Architecture

    1 week ago

    Vancouver, Canada PHSA Full time

    **Data Architecture & Business Intelligence Lead** Decision Support Services 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...

  • Associate Business Intelligence Analyst

    6 months ago

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

  • Business Intelligence Analyst

    6 months ago

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

  • Social Media Analyst, Data

    2 months ago

    Vancouver, Canada Hill & Knowlton Full time

    Hill & Knowlton is a strategic and creative partner to drive breakthrough opportunities for growth and value creation, advance corporate strategy, and build reputation capital and resiliency. We're a proven partner for business and brand transformation. A full-service global firm, we provide strategic communication, marketing and corporate affairs solutions...

  • Business Intelligence Database Analyst, Ph Data

    7 months ago

    Vancouver, Canada BC Centre for Disease Control Full time

    **Job Type**: Full-Time, Part-Time, Temporary, Casual, Contractor **Job Level**: Entry, Mid, Senior **Travel**: Minimal

  • Financial Business Analyst

    2 months ago

    Vancouver, Canada NTT DATA Full time

    Company Overview: Req ID: 301656 We are currently seeking a Financial Business Analyst to join our team in Vancouver, British Columbia (CA-BC), Canada (CA). **Business Analyst** At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company’s growth,...

  • Financial Business Analyst

    2 months ago

    Vancouver, Canada NTT DATA Full time

    **Job Description: Business Analyst** At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company's growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring, the best people and helping them grow both...