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
Other
Provide ticket-based customer support to gamers for a major gaming brand. Resolve issues efficiently, conduct web-based research, follow escalation policies, communicate clearly in written English, and adapt to changing client needs. Agents self-schedule 20 hours weekly, including seven weekend hours during required availability. The role requires strong typing skills, high-volume customer service experience, reliable equipment, dual monitors, high-speed internet, a headset, and a quiet workspace.
Top Skills:
Amd RyzenIntel CoreTwo-Factor Authentication (2Fa)Windows 11
Fintech • Payments • Financial Services
Investigates consumer credit complaints, examines evidence, assesses relevant rules and regulations, and makes fair, balanced decisions. The role involves managing an independent caseload, meeting targets, working with consumers and financial businesses, handling sensitive or challenging interactions empathetically, and clearly communicating findings in writing. New investigators receive up to six months of academy training before assuming full caseload responsibility.
Edtech • Other • Professional Services
Lead graphic design and videoboard content for Miami Athletics, support social media strategy and analytics, manage student interns, coordinate with university communications, and operate/upload content to venue videoboards including in-game operation. Work nights, weekends, and holidays as needed.
Top Skills:
Adobe Creative SuiteAfter EffectsAudio Production SoftwareCanvaFinal Cut ProMotion GraphicsPhotoshopVideoboard
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
