Business Consultant Level 3 - Education Data Warehouse Modernization

Veracity Software Inc; Victoria; On-site; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Business Consultant for an exciting project focused on modernizing education data systems. In this role, you'll identify and document business needs, develop business cases, and ensure that solutions meet quality expectations. Your expertise in communication and project management will be vital as you interact with a diverse range of stakeholders, from executives to technical experts. This position offers a unique opportunity to contribute to significant improvements in data processes within the education sector, making a real impact on the community. If you are passionate about driving change and enhancing business processes, this is the perfect opportunity for you.

Qualifications

• Degree in computer science or related field required.
• Excellent communication skills with diverse stakeholders.

Responsibilities

• Identify and document business needs and technical solutions.
• Manage quality of business solutions and ensure compliance.

Skills

Excellent oral and written communication skills

Ability to manage business impact of systems changes

Understanding client requirements

Education

Degree or diploma in computer science

Equivalent combination of education and experience

Tools

Education Data Warehouse (EDW)

GAME (ETL)

Job description

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.