Business Systems Analyst Data Repository; Data Warehouse/Data Lake and Ministry Reporting Data
Job in
Vancouver, BC, Canada
Listing for:
S.i. Systems
Full Time, Part Time, Contract
position
Listed on 2026-01-01
Job specializations:
-
IT/Tech
Data Warehousing, Data Engineer
Job Description & How to Apply Below
Position: Business Systems Analyst for a Data Repository (Data Warehouse / Data Lake) and a Ministry Reporting Central Data
Our client is seeking a Business Systems Analyst for a Data Repository (Data Warehouse / Data Lake) and a Ministry Reporting Central Data Warehouse project.
Initial contract goes till end of Mar with possibilities of renewals.
For local candidates: hybrid model in Vancouver 2 days/week on-site (Thursdays included) with first 4 days of contract on-site for onboarding.
For remote candidates living outside of Lower Mainland: first 4 days of contract on-site for onboarding, then one Thursday per month in Vancouver office at own expense.
Standard 35 hours/week - 7 hours/day Mon - Fri
Must Have:
Experience with system architecture and data flow design for data warehouses.Deep understanding of data warehousing concepts, including ETL, data conversion
, and optimization for reporting.Experience advising on reporting tools and strategies for compliance reporting.Ability to design and support intelligence reporting and multi-source data querying.Experience in entity relationship modeling, data denormalization, and query optimization.able to be onsite in Vancouver 2 days per week.Nice to Haves:
Ability to define integrations with Workday; work involves reading Workday objects for data extraction.Technical expertise with Oracle DB, and both relational and non-relational databases.Responsibilities:
This role supports the planning of a scalable, efficient, and compliant data repository and reporting infrastructure. You’ll focus on data architecture, integration, and governance.Support the design and document end-to-end data architecture, including data flows and integration patterns for warehousing and reporting.Collaborate with technical and business teams to define and optimize data warehouse structures, ensuring scalability and performance.Provide advisory on ETL strategy, data reporting tools, and data storage optimization.Analyze and define integrations with Workday, focusing on data extraction using Workday's unique object model and APIs.Lead data conversion efforts for migration or transformation projects.Understand and implement entity relationship models, data denormalization, and other data modeling best practices.Support intelligence reporting by designing efficient data retrieval methods and integrating disparate data sources.Ensure solutions align with compliance and governance standards for secure and accurate reporting.Troubleshoot and optimize complex queries and data flows across multiple data environments.
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
