Analyzes large datasets from multiple systems and converts them into business insights using SQL, Power BI, Power Query, DAX, and data modelling. Responsibilities include requirements gathering, data profiling, source-system analysis, technical specifications, EDW and BI framework development, ETL/data pipelines, dashboards, reporting, documentation, and standards development. The role also configures advanced Power BI Service capabilities, including Dataflows, Datamarts, security, workspaces, and automated refresh.
Project Description
Business
Intelligence Analyst – Metro Vancouver
Metro
Vancouver is seeking a Business Intelligence Analyst to support the
Liquid Waste Services Business Strategy and Improvement Team. The project
focuses on analyzing large datasets from multiple systems and transforming data
into meaningful business insights through SQL, Power BI, Power Query, and
data modelling.
The
resource will be responsible for requirements gathering, data profiling,
source-system analysis, technical specifications, BI/EDW framework development,
ETL/data pipelines, dashboards, reporting, and documentation/standards
development. The role also involves advanced Power BI Service capabilities such as Dataflows, Datamarts, security, workspaces, and automated
data refresh. Microsoft Fabric experience is considered a strong asset.
- Strong SQL and
relational databases — SQL Server, Oracle
- Power
BI development and analytics
- Advanced Power
BI Service, including:
- Dataflows
- Datamarts
- Workspace/security configuration
- Automated data refresh
- Power Query
/ M Query
- DAX
- Data
modelling and visualization
- Data profiling and source-data analysis
- Data warehouse / EDW architecture and reusable frameworks
- Data lakes / ODS
- ETL/ELT
and data pipelines
- Relational and non-relational databases
- REST APIs
- OLAP cubes
- Technical specifications and design
documentation
- Azure DevOps
- Python or R
- Microsoft Fabric, particularly:
- Data integration
- Data warehousing
- Analytics
- Semantic modelling
- Enterprise reporting
- Requirements gathering and translating
business requirements into technical specifications
- Business analysis
- Documentation and standards development
- Streamlining and standardizing
technical/operational documentation
- Ability to communicate technical concepts in
non-technical language
- Independent work with minimal supervision
- Ability to analyze information, identify
priorities, and recommend alternative business processes
Similar Jobs
Aerospace
Designs, develops, tests, and troubleshoots electrical components, electronic circuitry, and PCB layouts for new and existing products. Supports new product introduction, EMC compliance, manufacturing testing, root cause analysis, FMEA, vendor evaluation, and production issue resolution. Collaborates with manufacturing and cross-functional teams while ensuring quality, regulatory, reliability, and schedule requirements are met.
Top Skills:
AltiumCadCircuit Simulation SoftwareEmcFrequency GeneratorHelmholtz CoilExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft VisioMicrosoft WordOscilloscopePcb LayoutPower SupplyVoltmeter
Edtech
Develops and evaluates research-based educational programs that improve farm financial management, business planning, risk management, profitability, and sustainability. Translates applied research into practical tools and technical assistance, coordinates workshops and outreach, builds stakeholder partnerships, conducts needs assessments and applied research, documents program impact, and secures external funding. The role serves agricultural producers statewide, requires collaboration across disciplines, and involves travel throughout Pennsylvania.
Top Skills:
Financial SoftwareExcelMS OfficeMobile ApplicationsStatistics Software
Artificial Intelligence • Analytics
Handle high-volume customer interactions through calls, chats, and emails. Explain insurance products and policy actions, gather information, resolve service requests, document outcomes, and collaborate with licensed agents. Maintain accuracy and quality standards, complete administrative tasks, learn product updates, and provide empathetic customer care while meeting turnaround objectives.
Top Skills:
Crm ApplicationsExcelMS OfficeOutlookWord
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
