Business & Data Analyst

Vantix Systems Inc.; Edmonton; On-site; CAD 70,000 - 90,000; Full time

Job summary

A technology solutions provider in Canada seeks a skilled individual to coordinate business analysis and project management efforts. The role involves leading initiatives that ensure alignment with operational goals and delivering analytical support for strategic decisions. The ideal candidate will have extensive experience in data analysis, advanced Excel skills, and the ability to communicate effectively with diverse stakeholders. This is an essential position to enhance processes and ensure data integrity across services.

Qualifications

• Direct experience in business requirement analysis and solution architecture.
• Strong communication skills to convey technical concepts to non-technical stakeholders.
• Experience in identifying business needs and proposing effective improvements.

Responsibilities

• Coordinate activities to support operational requirements.
• Lead working groups for program development and enhancements.
• Design operational reports and workflows.
• Manage risk assessments and mitigation plans.
• Create system test strategies and participate in testing activities.

Skills

Business analysis

Project management

Data analysis

Communication skills

Advanced Excel skills

Experience with PowerBI

Tools

PowerBI

Microsoft SQL Reporting

Analytical Services

Job description

Overview

• Coordinate and conduct activities to support Child Care Claims Unit operational requirements and initiatives, ensuring alignment with Division/Branch/Unit goals and objectives.
• Provide business information expertise and support related to CRT to the internal Branch staff, including business technology functions and planning and light project management.
• Ensure impacted users (internal staff, providers, families as applicable) understand new/changed processes by conducting reviews and walkthroughs of child search, CCPN assignment, enrollment, and data correction flows.
• Recommend approaches that achieve business objectives and data integrity, including controls, validation rules, duplicate‑prevention practices, and reconciliations across CRT, Claims, Adjustments, Subsidy, and Family Portal.
• Facilitate focus groups/requirements workshops to define business requirements and edge cases.
• Translate business requirements into detailed specifications and acceptance criteria to IT service designers and developers addressing policy, business rules, privacy, audit, and user needs.

Responsibilities – Analytical and Project Management

• Provide analytical and business support through data/statistical/operational analysis and policy option analysis.
• Assess business opportunities and risks (e.g., duplicate payments, provider error hotspots, subsidy/grant exposure) and develop/evaluate business cases.
• Lead working groups for program and system development/enhancements.
• Design and document procedures and job aids to enable accurate completion of business processes by staff and providers.
• Define user security/access needs and coordinate role‑based access design accordingly.
• Design operational reports and information management processes and workflows (e.g., duplicates queue, exception handling, reconciliation dashboards).

Responsibilities – Project Management

• Work closely with designated product owner staff in Strategic Design and Technology Integration Branch and Digital Development and Delivery team to support initiatives to improve service delivery and align with business plans.
• Provide input on schedules, strategies, and resource needs from delivery perspective; monitor work plans for completion of tasks.
• Develop and manage risk assessments and mitigation plans (e.g., double‑dipping risk due to duplicate CCPNs).
• Develop post‑implementation review strategies (e.g., duplicate rate trends, provider error rates, inquiry volumes).
• Participate in and monitor test activities to ensure system functions meet business requirements.
• Create system test strategies, plans, and scripts; conduct functional/integration/regression testing (child search/match, CCPN assignment, merge/split, security, navigation, reporting).
• Coordinate UAT plan; recruit participants, provide tester training, manage defect triage and resolution.
• Identify Decision/Change Requests and complete documentation for governance.
• Identify data conversion/cleanup requirements and manage transition/stabilization issues.
• Administer change management processes and provide status reporting; participate in outcome measurement.

Responsibilities – Planning and Process Modeling

• Provide business analysis services for planning, feasibility, requirements, business case development, and process modeling for CRT and related services.
• Provide expertise for identification, development, implementation, and enhancement of CRT and interconnected services (Claims, Adjustments, Subsidy, Family Portal).
• Understand business needs and design solutions to simplify, improve, or automate operations while preserving auditability and privacy.
• Manage/participate in committees and project teams; develop proposals/options in response to identified needs.
• Review and evaluate system deliverables from a user perspective to ensure objectives are met.

Responsibilities – Transitional Management

• Coordinate communications plans across multiple releases and stakeholder groups (internal staff, providers, families as applicable).
• Design and facilitate change management activities to ready users for new processes (e.g., Family Portal confirmations, dedupe workflows).
• Develop training strategies, plans, and materials; deliver web‑based and classroom training as needed.
• Design and deliver presentations to multiple audiences.
• Develop quality assurance processes to ensure data integrity and compliance with policies and procedures.

Direct, hands-on experience performing business requirement analysis, solution architecture and design, and deployment related to data analysis, data analytics, data visualization, data science, data mining.

Work experience creating and using advanced Excel skills such as Pivot table, VLOOKUP etc.

Experience with PowerBI, PowerView, Microsoft SQL Reporting, and Analytical Services.

Strong communication skills with the ability to convey technical concepts to non-technical stakeholders and influence decision-making.

The proposed resource must have demonstrated experience in a role identifying and documenting business requirements, interpreting business needs and proposing improvements to increase the effectiveness of the business.

The proposed resource must have demonstrated experience planning and conducting requirements gathering workshops with operational and clinical staff, leadership teams or stakeholder representatives.