Transformational Business Analyst – Canada Benefits Data & Integrations

Description

Transformational Business Analyst – Canada Benefits Data & Integrations

Vacancy Status

Yes - This posting is for an existing vacancy within the organization and is open to new applications. (Backfill)

AI Disclosure

As part of the application process, Artificial Intelligence will be used in the hiring process for this role

Hybrid - This role is categorized as hybrid. This means the successful candidate is expected to report to the Oshawa Elevation Centre three times per week, at minimum [or other frequency dictated by the business].

Key Responsibilities

Process Transformation & Digital Solutions

• Execute assigned transformation and integration projects with high‑quality, timely deliverables.

• Implement requested changes to existing or new programs, tools, and reports.

• Conduct current‑state process analysis; document and refine business processes, data flows, and interactions with service provider systems.

• Identify opportunities to simplify, standardize, and automate business processes to improve quality, efficiency, and user experience.

• Create end‑to‑end solutions for business processes, including documentation, training materials, and ongoing support.

• Stay current on benefits program changes, labor agreement changes, new technology, and evolving data requirements .

• Support new business processes and projects across Benefits Operations. #### Requirements, Design & Testing

• Partner with business sponsors to define business requirements for new and/or enhanced data, reporting, and integrations.

• Document business requirements and collaborate with business partners, Third Party Administrators (TPAs), and IT on appropriate design decisions.

• Create and co‑own functional specifications for new and/or enhanced data transmissions and interfaces.

• Lead and facilitate functional specification review sessions with cross‑functional stakeholders (business sponsors, IT, other business analysts, operations, and TPAs).

• Coordinate with GM Subject Matter Experts, GM IT, and TPAs to ensure comprehensive user acceptance testing and training plans are developed and executed.

• Manage change controls to ensure successful transition of new or updated solutions into production, Operations Support & Issue Management

• Provide ongoing support to Benefits Operations for benefits‑related data and integration issues.

• Own emerging data integration issues and errors, including root cause analysis for existing and emergent issues.

• Open and manage change requests or break/fix requests based on identified issues.

• Create and maintain meaningful metrics and dashboards to communicate data issues, trends, and resolutions to leadership.

Canada Benefits Data & Integrations – Primary Focus

• End‑to‑End Data Quality & Reconciliation

  • Ensure data quality and reconciliation for Canadian benefits by reviewing:

    • Daily Alight edit reports

    • CAAT change/full‑file error reports

    • Kronos bypass reports

  • Complete weekly future‑dated termination checks.

  • Monitor integrations during key annual events (e.g., contractual general wage increases, Advanced Comp salary updates).

  • Lead semi‑annual/annual full reconciliations with Alight and annual status‑history reviews with CAAT .

• Integration Issue Analysis & Defect Management

  • Lead analysis and defect management for Workday‑to‑vendor interfaces.

  • Triage data vs. integration defects and partner with HR/LR business partners on required Workday corrections.

  • Log, track, and prioritize integration defects; collaborate with IT on fixes and legal/regulatory change implementations.

  • Develop test scenarios, enter test data, and validate output files to support defect resolution and enhancements.

• Subject Matter Expertise & Stakeholder Support

  • Serve as SME to Benefits, Payroll, HR, and Pension teams for Canadian benefits data flows.

  • Investigate employee data transmitted to Alight, Canada Life, and CAAT and confirm employee status (e.g., pension withdrawals, retirements).

  • Advise stakeholders on the impact of Workday changes on vendor integrations and downstream processes.

• Reporting, Monitoring & Business Continuity

  • Maintain reporting and business continuity readiness by extracting key Workday reports to OneDrive on a daily basis.

  • Use Access databases, Databricks, and Workday reporting to support analysis, root‑cause investigation, and ongoing monitoring of Canadian benefits data flows.

• Access Management & Vendor Platform Ownership

  • Maintain and administer user access for key vendor portals (e.g., CAAT portal, Alight site ), including access requests, renewals, and troubleshooting.

  • Serve as business/application owner for key Canadian benefits platforms ( Alight, CAAT, Canada Life ), including:

    • Completing annual SOX activities

    • Coordinating PGP key changes

    • Reviewing EDT documentation

    • Supporting broader vendor and application operations.

Qualifications

• Successful completion of a Bachelor’s degree in business, business analytics, statistics, computer science or a related field.

• Demonstrated proficiency working with extremely large and complex data sets .

• Strong analytical, organizational, and project management skills.

• Ability to think creatively and strategically and translate strategy into executable plans.

• Proven capability to manage multiple tasks and projects simultaneously in a fast‑paced environment.

• Experience with project management, change management, and continuous improvement methodologies.

• Demonstrated ability to present data, findings, and recommended actions/solutions to stakeholders at various levels.

• Experience with Workday business processes and reporting.

• Strong interpersonal skills and demonstrated ability to work effectively in a team environment.

• Excellent written and verbal communication skills.

Skills & Competencies

• Problem solving with strong analytical capabilities.

• Strategic thinking to translate program and process design into operational requirements.

• Broad understanding of systems, integrations, and connectivity to external vendors .

• Ability to work both independently and collaboratively with cross‑functional teams.

• Proficiency in writing complex SQL queries .

• Proficiency with MS Office , including MS Access .

• Strong consulting skills and ability to influence without direct authority.

• Strong communication, active listening, and stakeholder management skills.

• Comfort dealing with ambiguity and changing priorities; high degree of flexibility and organizational agility .

• Ability to prioritize and manage multiple tasks and projects without sacrificing quality.

• Highly collaborative work style with a focus on partnership and shared outcomes.

• Ability to evaluate the big picture and solve business problems, not just optimize individual metrics.

Compensation

The salary range for this role is $97,800.00 to $146,600.00. The actual base salary a successful candidate will be offered within this range will vary based on factors relevant to the position.

Benefits:

The goal of the General Motors of Canada total rewards program is to support the health and well-being of you and your family. Our comprehensive compensation plan currently includes the following benefits, in addition to many others:

• Paid time off including vacation days, holidays, and supplemental benefits for pregnancy, parental and adoption leave.

• Healthcare, dental and vision benefits including health care spending account and wellness incentive.

• Life insurance plans to cover you and your family.

• Company and matching contributions to a Defined Contribution Pension plan to help you save for retirement.

• GM Vehicle Purchase Plan for you, your family, and friends.

THIS JOB IS NOT ELIGIBLE FOR RELOCATIONS BENEFITS. ANY RELOCATION COSTS WOULD BE THE RESPONSIBILITY OF THE SELECTED CANDIDATE.

GM DOES NOT PROVIDE IMMIGRATION-RELATED SPONSORSHIP FOR THIS ROLE. DO NOT APPLY FOR THIS ROLE IF YOU WILL NEED GM IMMIGRATION SPONSORSHIP NOW OR IN THE FUTURE.

GM does not provide immigration-related sponsorship for this role. Do not apply for this role if you will need gm immigration sponsorship now or in the future.

This role is categorized as hybrid. This means the selected candidate is expected to report to a specific location at least 3 times a week {or other frequency dictated by their manager}.

This job is not eligible for relocation benefits. Any relocation costs would be the responsibility of the selected candidate.

About GM

Our vision is a world with Zero Crashes, Zero Emissions and Zero Congestion and we embrace the responsibility to lead the change that will make our world better, safer and more equitable for all.

Why Join Us 

We believe we all must make a choice every day – individually and collectively – to drive meaningful change through our words, our deeds and our culture. Every day, we want every employee to feel they belong to one General Motors team.

Total Rewards | Benefits Overview

From day one, we're looking out for your well-being–at work and at home–so you can focus on realizing your ambitions. Learn how GM supports a rewarding career that rewards you personally by visiting Total Rewards resources. 

Non-Discrimination and Equal Employment Opportunities (U.S.)

General Motors is committed to being a workplace that is not only free of unlawful discrimination, but one that genuinely fosters inclusion and belonging. We strongly believe that providing an inclusive workplace creates an environment in which our employees can thrive and develop better products for our customers.

All employment decisions are made on a non-discriminatory basis without regard to sex, race, color, national origin, citizenship status, religion, age, disability, pregnancy or maternity status, sexual orientation, gender identity, status as a veteran or protected veteran, or any other similarly protected status in accordance with federal, state and local laws. 

We encourage interested candidates to review the key responsibilities and qualifications for each role and apply for any positions that match their skills and capabilities. Applicants in the recruitment process may be required, where applicable, to successfully complete a role-related assessment(s) and/or a pre-employment screening prior to beginning employment. To learn more, visit How we Hire.

Accommodations

General Motors offers opportunities to all job seekers including individuals with disabilities. If you need a reasonable accommodation to assist with your job search or application for employment, email us [email protected] or call us at 1-800-865-7580. In your email, please include a description of the specific accommodation you are requesting as well as the job title and requisition number of the position for which you are applying.