Business Systems Analyst for a Data Repository (Data Warehouse / Data Lake) and a Ministry Reporting Central Data Warehouse project.

Our client is seeking a Business Systems Analyst for a Data Repository (Data Warehouse / Data Lake) and a Ministry Reporting Central Data Warehouse project.

Contract Period: This contract can be until March 31,

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

Required Qualifications

• Bachelor’s degree in information systems, Computer Science, Data Analytics, or related field
• 5+ years of experience as a Business Systems Analyst (BSA) working on data reporting and data warehouse
• Working extensively on Waterfall projects recently
• IIBA certification, comprehensive training in Business Analysis, or solid knowledge of BABOK

Business Analysis Experience

Solid experience of business analysis in waterfall projects. The experience MUST include:

• 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
• 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
• Understanding of privacy and data protection regulations in BC

Soft Skills:

• Excellent analytical, problem-solving skills
• Excellent communication (both verbal and written) skills
• Ability to work collaboratively with cross-functional teams and stakeholders
• Demonstrates a strong sense of accountability and responsibility in managing and delivering business analysis activities
• Adaptability to follow our PMO processes and use our templates
• Exhibits exceptional organizational skills and time management, effectively managing multiple priorities and tasks
• Takes ownership of tasks and ensures that business analysis deliverables are completed on time
• Provide comprehensive documentation on all analysis performed
• Transparency and initiative-taking communication
• Ability to digest information (business and technical)

Technical Expertise (must be comfortable working with)

• MS Teams
• Word
• Excel
• MS Visio
• SQL databases (specially queries using SQL Developer)
• Data Warehouses

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)

Hybrid work

• 2 days per week office presence:
• Thursdays
• The day of the week the project team has as a second designated day
• 7 hours per week (with the schedule of 8:30 am to 4:30 pm and one hour lunch)

Contract Period: This contract can be until March 31,