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 SQL • Cloud & hybrid Data Flows - Google BigQuery (preferred) • Billing, Payments & Accounting Systems – understanding of how they work, and can use Accounting/Finance terminology • Business Systems and Financial Data Analysis • User Story Creation & Requirements Documentation • Oracle 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.