BI Data Warehouse Analyst | Power BI, SQL, ETL

New Value Solutions; Burnaby; On-site; CAD 70,000 - 110,000; Full time

Job summary

New Value Solutions, a national IT consulting company, is seeking a Business Intelligence Analyst to support our client’s Business Strategy and Improvement team. This role will focus on analyzing large datasets, developing data visualizations and business intelligence solutions, and translating business requirements into technical specifications.

The successful candidate will bring strong experience with SQL, Power BI, data modelling, data warehousing, ETL, and source-system analysis, while also

Qualifications

• Strong BI/EDW experience and architecture
• Strong SQL skills with SQL Server and/or Oracle
• Extensive Power BI experience and analytics
• Design, build, and deploy dashboards and reports
• Experience in data modelling, analysis, and visualization
• Reusable frameworks for on-premise data warehouses
• Develop complex data pipelines and ETL processes
• SQL Server, REST APIs, OLAP cubes, and BI analytics technologies
• Advanced Power BI Service with Dataflows and Datamarts
• Automate data-source refreshes in Power BI
• Analyze source systems for data transformation requirements
• Translate business requirements into technical specifications
• Requirements gathering experience
• Document technical designs and specifications

Responsibilities

• Translate business requirements into detailed technical specifications and solution requirements.
• Perform data profiling and source-system analysis using SQL and other applicable tools.
• Gather, document, and analyze business and technical requirements.
• Design, build, and deploy BI solutions, including dashboards, reports, and analytical data products.
• Design and develop reusable data analytics frameworks incorporating data warehouses, data lakes, operational data stores, data models, Power BI security, and Power BI workspaces.
• Design relational and analytical data models based on business and technical requirements.
• Develop data pipelines and ETL processes for data extraction, transformation, integration, and loading.
• Develop solutions using SQL, M Query, DAX, Power Query, REST APIs, OLAP cubes, and related BI technologies.
• Develop dashboards and reports using Power BI Desktop.
• Configure and support Power BI Service, including workspaces, Dataflows, Datamarts, security, and automated data-source refreshes.
• Maintain, troubleshoot, and enhance existing business intelligence and data warehouse solutions.
• Analyze source systems to identify transformation, integration, and data-quality requirements.
• Design and support reusable frameworks for on-premise enterprise data warehouse environments.
• Prepare technical designs, specifications, requirements documentation, and supporting technical documentation.
• Review, streamline, and standardize technical and operational documentation.
• Develop practical standards and processes that promote consistency and maintainability.
• Provide technical advice to internal stakeholders.
• Present technical concepts and recommendations clearly to non-technical stakeholders.
• Work independently with minimal supervision while collaborating with the broader team.

Skills

SQL

Power BI

Data modelling

Data warehousing

ETL

Source-system analysis

Requirements gathering

Documentation

Business analysis

REST APIs

DAX

Power Query

OLAP cubes

Tools

Power BI Service

Dataflows

Datamarts

REST APIs

Job description

New Value Solutions, a national IT consulting company, is seeking a Business Intelligence Analyst to support our client’s Business Strategy and Improvement team. This role will focus on analyzing large datasets, developing data visualizations and business intelligence solutions, and translating business requirements into technical specifications.

The successful candidate will bring strong experience with SQL, Power BI, data modelling, data warehousing, ETL, and source-system analysis, while also