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
HR Tech • Professional Services • Consulting • Automation
Conduct founder interviews, identify themes and narrative arcs, organize material for books, and repurpose stories into articles, podcasts, social posts, emails, landing pages, and ads. Research subjects, prepare customized questions, coordinate creative deliverables, support audio and podcast production, and document a repeatable interview-to-content workflow.
Top Skills:
DescriptOtter
Insurance
Provides primary personal assistant support to senior Legal and Finance executives, managing calendars, inboxes, travel, meetings, documents, expenses, invoices, correspondence, and confidential information. Provides secondary US-based support to the Group Chief Legal Officer and Chief Financial Officer while coordinating with London-based EAs. Also independently manages the New York office, including supplies, facilities, vendors, visitors, onboarding, IT setup, and office relocation logistics.
Top Skills:
ConcurExcelMS OfficeMicrosoft TeamsOutlookPowerPointSharepointWord
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
