Billing Analyst

Bayshore HealthCare; Mississauga; On-site; CAD 70,000 - 110,000; Full time

Job summary

Bayshore Healthcare is seeking a Billing Analyst on a contract basis to support monthly billing, data management, and analytics for Bayshore Specialty Rx. The role emphasizes data integrity and adherence to contractual obligations.

Under the direction of the Senior Manager, Program Billing and Analytics, you will reconcile data, prepare invoices, validate billing calculations, and contribute to digitalization projects while maintaining accuracy and timely reporting.

Qualifications

• University Degree relevant to the role (Accounting, Finance, Statistics, Business Administration).
• Knowledge of Microsoft Office (Excel, Word, Outlook).
• Expert Excel knowledge preferred; Power BI, Power Query and Power Pivot.

Responsibilities

• Acquire data from primary or secondary data sources and maintain databases/data systems.
• Identify, analyze and interpret trends or patterns in complex data sets.
• Participate in Billing digitalization and transformation projects including automation, reconciliation, validation, and analytics.
• Prepare supporting data to invoices, reconciling production data to invoice to ensure completeness.
• Generate and submit supporting back-up to Reviewers/Approvers and make revisions as required.
• Analyze and understand all billing calculations to ensure billing is consistent with contractual terms.

Skills

Advanced Excel

Data analysis

Adaptability

Education

University degree in Accounting, Finance, Statistics, or Business Administration

Tools

Excel

Word

Outlook

Power BI

Power Query

Power Pivot

Data mining tools

Job description

JOB SUMMARY

This is a contract opportunity with an anticipated end date of August 2027.

The Billing Analyst, under the direction of the Senior Manager, Program Billing and Analytics, completes monthly billing, reconciliation, data management and verification activities as required by Bayshore Specialty Rx. Maintaining data integrity while preparing and analyzing all billing data in accordance with contractual obligations.

DUTIES AND RESPONSIBILITIES

• Acquire data from primary or secondary data sources and maintain databases/data systems
• Identify, analyze and interpret trends or patterns in complex data sets
• Participation in various Billing digitalization and transformation projects including but not limited to automation, reconciliation, validation, and analytics of Bayshore Patient Support Services.
• Prepare supporting data to invoices, reconciling production data to invoice to ensure completeness;
• Generate and submit supporting back-up to Reviewers/Approvers and make revisions as required;
• Analyze and understand all billing calculations to ensure billing is consistent with contractual terms, escale billing issues and or concerns to the Validation and Reconciliation Manager.;
• Develop and document efficient billing data procedures for new and existing business needs as determined by Management;
• Additional duties include reconciliation of billing data, data entry, filing, and obtaining/organizing supporting documentation including preparation of reports, spreadsheets and dashboards as needed; ensuring monthly timelines and targets are met
• Ensure deadlines are met for all reporting commitments
• Auditing of controls and Invoices of program Billing and Co-pay data in accordance with contractual obligations and thresholds.
• Review, validate and reconciliation of month end invoice back up data before its sent to the billing department.
• Participates in proactive Health & Safety activities while performing all duties. Is responsible to notify immediate Supervisor of any health and safety risks or concerns. Responsible for completing Accident Reports for all direct reports who injure themselves on the job, within 24 hours of the incident.
• Maintains confidentiality of client and corporate information and discusses same only with appropriate Bayshore personnel
• AAd- Hock requests from Senior Management

QUALIFICATIONS

• University Degree relevant to the role (Accounting, Finance, Statistics, Business Administration)
• knowledge of Microsoft Office (Excel, Word, Outlook)
• Expert Excel knowledge preferred; PIVOT, Functions: Lookups, IF statements, Pivot Charts, Concatenate
• Ability to work in a very busy and high paced environment.
• Ability to adapt to change quickly. Especially the potential shifting of projects and tasks based on reprioritization.
• Knowledge of Power BI, Power Query and Power Pivot
• Data mining and in-depth knowledge of Data Science techniques is an asset.
• Understanding and Manipulation of Billing Data Sets and Financial Information Systems
• Knowledge of techniques and methods of working with large datasets

At Bayshore Healthcare, our commitment to Equity, Diversity & Inclusion is our strength. This is how we bring our vision of being the difference in the lives of those we care for, work with and in our communities. We have a great sense of pride in creating a culture of belonging, where individual differences are embraced and celebrated, through programs, resources and policies that support each individuals purpose, potential and wellbeing. At Bayshore Healthcare Ltd., and its subsidiaries, we are committed to fostering an inclusive workplace and operate in full compliance with all Provincial and Territorial legislation pertaining to Human Rights Codes and Accessibility requirements. To ensure continued compliance throughout the recruitment and selection process, we encourage candidates to disclose any accommodation needs they may have.