Hybrid role in Vancouver.2 days onsite.

Job Title: Business Systems Analyst Data Warehouse(Contract)

Location : Vancouver, British Columbia

Overview:

- Our client is seeking a Business Analyst on a contract 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 completedBusiness 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 Business Analyst (BSA) working on data reporting and data warehouse for Waterfall projects
- Business Analysis ExperienceDefinition 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 ExperienceExperience 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 ExperienceInterpret ministry and government compliance standards to ensure solution meets regulatory expectations

📌 Business Analyst(Data Warehouse) (Vancouver)
🏢 TEEMA
📍 Vancouver