Sr Business Data Analyst/ BSA

Duration: 6 months to start, will definitely extend.

Location: GTA

Hybrid Model: 1-2 days a week onsite (open to remote within Ontario but must be open to occasional visits)

Interview Process: 2 virtual meetings steps

Main Deliverables

Support and enhance a custom-built Billing application within a Billing Development pod.Partner with Development, Finance, and Accounting stakeholders to drive billing and payment-related initiatives.Analyze billing, accounting, and payment data across Oracle and cloud-based environments.Document requirements and create user stories to support system enhancements.

Technical Stack

Advanced SQLCloud & hybrid Data Flows - Google BigQuery (preferred)Billing, Payments & Accounting Systems – understanding of how they work, and can use Accounting/Finance terminologyBusiness Systems and Financial Data AnalysisUser Story Creation & Requirements DocumentationOracle Database (some experience at least or good familiarity)

Requirements

10+ years of Business Systems/ Data Analysis experience.Expert-level SQL skills with strong data analysis, troubleshooting, and validation capabilities.Extensive experience with Billing, Payments, Accounting, or Financial systems.Strong understanding of accounting principles and financial terminology.Experience working with cloud and hybrid data environments, preferably including BigQuery.Experience with Oracle databases and relational data models.Proven ability to gather requirements, create user stories, and bridge business and technical teams.Insurance industry experience is a strong asset.

Responsibilities

Gather, analyze, and document business, functional, and system requirements.Work closely with Development teams, Finance, Accounting stakeholders, and leadership teams.Perform data analysis, reconciliation, and validation using complex SQL queries.Analyze billing workflows, payment processing, accounting integrations, and data flows.Create user stories, acceptance criteria, process maps, and functional documentation.Support enhancements, maintenance, and optimization of a custom billing platform.Investigate data discrepancies, system issues, and process inefficiencies.Participate in knowledge transfer activities and documentation of existing processes.Collaborate with teams supporting Oracle databases, cloud platforms, and hybrid data ecosystems.