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 WarehousesData lake / One Lake / LakehousesOperational Data Store (ODS) and source systems in MS AzureDesign and maintain facts, dimensions, relationships and business logicMigrate legacy Crystal Reports to Cognos and Power BI while maintaining performanceCreate curated datasets and enable governed self‑serve accessProfile data, identify defects, and perform reconciliation across layersTranslate business requirements into technical reporting solutionDevelop operational, analytical, and executive‑level reportsDevelop business logic, calculations, KPIs, and measuresEnsure reports are optimized and meet performance, usability, and visualization best practicesTroubleshoot issues and deliver enhancements iterativelySupport ad‑hoc reporting and self‑serve analytics use casesSupport execution of system testingSupports execution of User Acceptance Testing (UAT)Create deployment plans for BI technology deliverablesSupport deployment of BI technology deliverablesStrong 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 ReposWhat 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 experience5+ years of Business Intelligence implementation projects.Strong SQL skillsExpert 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 logicAbility to prepare and analyze data using data warehouses, data lakes, ODS concepts, cubes, and ExcelKnowledge 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
#J-18808-Ljbffr