Business Consultant Level 3 - Education Data Warehouse Modernization

Project Name: Education Data Warehouse Modernization

Location of Services: Victoria, BC

Estimated Work Start Date: 01-Apr-2025

Estimated Work End Date: 31-Mar-2026

Standard Hours Per Day: 7

Estimated Work Days: 261.00

Business Consultant Responsibilities:

• Identify, define, model and document business needs, including the ability to:
• model and document technical solutions,
• develop and present business cases including feasibility studies, risk assessments and cost benefit analysis of solution alternatives,
• define and document product and funding for development and ongoing support,
• develop presentations, reports and submissions required by clients to secure approval and funding from Executive or Treasury Board, and
• develop work plans;
• Interact professionally and productively with a wide variety of people in diverse roles (e.g. executives, contractors, technical experts, naïve users) to develop and implement:
• automated business processes,
• service agreements with service consumers and suppliers,
• appropriate service management processes,
• training/educational materials, and
• application maintenance support;
• Manage the quality of the delivered business solution to ensure it meets the quality expectations:
• ensure structure, design and development of the deliverables is in compliance with applicable standards,
• monitor/control project progress, resource usage and cost, and
• ensure performance of technical reviews and audits and obtain required approvals before implementation.

Required Skills and Experience:

• Degree or diploma in computer science or a related field, demonstrated ongoing learning activities, or an equivalent combination of education and experience;
• Excellent oral and written communication skills with demonstrated experience communicating effectively to a broad range of stakeholders;
• Ability to ensure client requirements and priorities are understood and met throughout the systems development life cycle (e.g. change management, problem resolution, user acceptance testing, implementation, and post implementation reviews);
• Experience managing business impact of systems changes.

Additional Skills and Experience:

• Ability to conduct analysis and document requirements, create test plans, create and document migration plans, etc. related to creating the appropriate views, aggregate levels, etc. for new or modifying existing data loads;
• Ability to identify data conflicts for re-prioritization and investigate data anomalies between data warehouses;
• Experience with the Education Data Warehouse (EDW) and GAME (the ETL used for the historical data loads);
• Experience working with development of data loads used by the Ministry of Education;
• Experience working with BC Government core policy, compliance, and standards.

Contractor Responsibilities:

• Review project plan and provide input on any risks, issues, dependencies of data loads;
• Advise of any impacts from other projects at the Ministry;
• Attend project meetings, including those related to the agile approach (scrums, demos, retrospectives, planning session, etc.);
• Provide associated Ministry standard deliverables for Ministry review and acceptance;
• Liaise and assist Service Provider resources to analyse the design approaches and assess impacts to the business requirements.