Job Title: Business Systems Analyst Data Warehouse(Contract)
Job ID: 89912
Location :Vancouver, British Columbia
Overview:
Our client isseeking a Business Analyst on acontract to support two client projects concurrently.
Centralized Data Warehouse Project:Develop a solution to migrate data from two existing ERP systems into an external data warehouse while meeting all data integrity and compliance needs.
Data Repository Selection Project: Gather requirements and evaluate solutions for an internal data repository solution (data warehouse, date lake, etc.)
What you will be doing: Deliverables to be completed
Business Analysis Approach
Business Requirements Document containing comprehensive definition of Business requirements
Stakeholder requirements
Functional requirements
Non-Functional requirements

Functional Requirements Document (with detailed definition of functional requirements).
Comprehensive Data mapping Document containing: Business Glossary
Data Sources
Data Source Quality
Data Mapping (source, ETL, Target)

Current state and future state process flows
Data flows (end-to-end)
Data Quality Management Plan (to ensure data integrity and compliance with Ministry requirements)
What you must have: Bachelor’s degree in information systems, Computer Science, Data Analytics, or related field
5+ years of experience as a BusinessAnalyst (BSA)



working on data reporting and data warehouse for Waterfall projects
Business Analysis Experience Definition of business analysis approach
Elicitation techniques
Comprehensive documentation of requirements (business requirements, stakeholder requirements, functional requirements, non-functional requirements, transition requirements)
Translating business needs into requirements and requirements into technical specifications
Assessment of current state and future state, and gap analysis
Documenting process and data flows
Requirements lifecycle management (including requirements traceability)
Systems Analysis Experience Experience with SQL queries, data profiling etc.
Data Integrity, data profiling, data transformation, data management rules
Comprehensive documentation of data mapping
Data warehousing and reporting
Familiarity with cloud data platforms (Azure Synapse, Snowflake, AWS Redshift)
Compliance Experience Interpret ministry and government compliance standards to ensure solution meets regulatory expectations
Salary/Rate Range: $70.00 -$80.00/hr
Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a positive fit.

#J-18808-Ljbffr

📌 Business Analyst Data Warehouse (Contract) (British Columbia)
🏢 TEEMA
📍 British Columbia