Business Intelligence Analyst

Job Title: Business Intelligence Analyst
Job :90089
Location:Burnaby, British Columbia

The Business Intelligence Analyst will work in collaboration with our Business Strategy and Improvement Team and will focus on:

• Translating business requirements into technical specifications
• Data profiling
• Source data analysis with SQL or applicable tools
• Business Analysis
• Designing and developing the data analytics (data warehouse, data lake ODS, data modelling, Power BI security, Power BI workspace) reusable framework
• Designing data models based on technical specifications
• Exploring advanced Power BI features for analytics, including customized solutions such as Dataflows and Datamarts
• Designing and building data pipelines and ETL packages including:
  • M Query
  • Dax Language
  • Power Query
  • Dashboards and reports with Power BI Desktop
  • Troubleshoot day-to-day data warehouse issues
• Design, build, and deploy BI solutions (e.g., reporting tools, dashboards)
• Maintain and improve existing BI systems

• Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle)
• Experience with on-premise data warehouse reusable framework design and implementation
• Experience with data modelling, analysis, and visualization
• Work with relational and non-relational databases to extract, transform, and load (ETL) data
• Experience with building data pipelines and ETL processes
• Extensive development experience with technologies including SQL Server, REST APIs, OLAP cubes, and BI analytics tools
• Extensive analytic development experience with Power BI and preferably Microsoft Power Platform
• Advanced Power BI Service configuration experience, including Power BI Dataflows and Datamarts
• Experience in Power BI report development, reports automation with data source refresh configurations
• Experience with analyzing data source systems to identify data transformation needs
• Thorough knowledge of software development methods, practices and procedures
• Ability to prepare technical design and write technical specifications
• Experience using Azure Dev Ops to manage projects is preferred
• Experience with programming languages such as Python or R is a plus
• Experience with Microsoft Fabric for data integration, data warehousing, analytics, semantic modeling, and enterprise reporting solutions is considered a strong asset

Salary/Rate: $85.00/ hour