Business Systems Analyst Data Warehouse(Contract)

Job Title: Business Systems Analyst Data Warehouse(Contract)
Job ID: 89912
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 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 Business Analyst (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 good fit.