EAM – Business Intelligence Analyst

TEEMA; New Westminster; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading staffing and consulting firm in Canada seeks an EAM – Business Intelligence Analyst to design and develop reports and dashboards. The candidate will utilize Microsoft Power BI and Cognos, collaborating with data engineers to process and analyze data effectively. Ideal applicants should have a diploma in computer science and a minimum of 5 years of experience in Business Intelligence projects. The role requires strong SQL skills, excellent analytical ability, and experience working with business stakeholders.

Qualifications

• 5+ years of requirements analysis and/or process improvement experience.
• 5+ years of Business Intelligence implementation projects.
• Ability to prepare and analyze data using data warehouses, data lakes, ODS concepts.

Responsibilities

• Design and maintain reports using Microsoft Power BI, Cognos, and Excel.
• Migrate legacy reports to new BI technologies while maintaining performance.
• Translate business requirements into technical reporting solutions.
• Support user acceptance testing and deployment of BI technology deliverables.

Skills

Strong SQL skills

Expert knowledge of Cognos BI

Experience with DAX and calculation logic

Strong analytical skills

Strong communication skills

Ability to gather and analyze information

Education

Diploma in computer science

Tools

Microsoft Power BI

IBM Cognos Analytics

SAP Crystal Reports

MS Excel

Microsoft SQL Server

Job description

Job Title:EAM – Business Intelligence Analyst
Job ID:84765
Location:New Westminster, British Columbia

What you will be doing

• Design, develop, enhance, and maintain reports and dashboards using:
  • Microsoft Power BI (Reports, Dashboards, Semantic Models)
  • IBM Cognos Analytics
  • SAP Crystal Reports
  • MS Excel
• Work with data engineer and architect to consume data from:
  • Data Warehouses
  • Data lake/One Lake/Lakehouses
  • Operational Data Store (ODS) and source systems in MS Azure
• Design and maintain facts, dimensions, relationships and business logic
• Migrate legacy Crystal Reports to Cognos and Power BI while maintaining performance
• Create curated datasets and enable governed self‑serve access
• Profile data, identify defects, and perform reconciliation across layers
• Translate business requirements into technical reporting solution
• Develop operational, analytical, and executive‑level reports
• Develop business logic, calculations, KPIs, and measures
• Ensure reports are optimized and meet performance, usability, and visualization best practices
• Troubleshoot issues and deliver enhancements iteratively
• Support ad‑hoc reporting and self‑serve analytics use cases
• Support execution of system testing
• Supports execution of User Acceptance Testing (UAT)
• Create deployment plans for BI technology deliverables
• Support deployment of BI technology deliverables
• Strong analytical and communication skills. Ability to gather, analyze, and consolidate information from a variety of sources (i.e. documents, interviews, brainstorming sessions, etc.).
• Proven record of accomplishment of working with business stakeholders.
• Ability to work collaboratively, professionally, and effectively with the project team, the business stakeholders, and the end users.
• Follow best practices of query writing and document changes using Repos

What you must have

• Diploma in computer science from a recognized institute of technology including courses in database design, programming, business, and systems analysis. 5+ years requirements analysis and/or process improvement experience
• 5+ years of Business Intelligence implementation projects.
• Strong SQL skills
• Expert knowledge and experience of Cognos BI Enterprise Reporting platform, Microsoft BI technologies, including Power BI, Power BI Report Builder SSAS (SQL Server Analysis Services), SSRS, Power Pivot, Power Query and Power Viewer.
• Experience with DAX and calculation logic
• Ability to prepare and analyze data using data warehouses, data lakes, ODS concepts, cubes, and Excel
• Knowledge and experience of Microsoft SharePoint in conjunction with Microsoft BI technologies.
• Knowledge and experience of Microsoft SQL Server Database (e.g. on‑premise, Azure, Synapse Serverless SQL).
• Training and experience in best practice business intelligence techniques and best practices.
• Strong analytical and communication skills. Ability to gather, analyze, and consolidate information from a variety of sources (i.e. documents, interviews, brainstorming sessions, etc.).
• Proven record of accomplishment of working with business stakeholders.
• Ability to work collaboratively, professionally, and effectively with the project team, the business stakeholders, and the end users.

Thank you for your interest in this opportunity

If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.

For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com