Oracle dba Jobs in Markham, ON

Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.

At Aviva Canada, we put people first, our employees, our customers, and our communities. We’re proud of a culture built on care, inclusion, and collaboration, where your voice matters and your growth is supported. We’re not just about insurance; we’re about making a real difference by protecting what matters most.

We are looking for a highly skilled Finance and Data Solution Architect to help build the future of our Finance Transformation journey. Using your expertise in Oracle Fusion, IFRS 17, finance data architecture, and cloud technologies, you will design solutions that strengthen financial reporting, data governance, operational efficiency, and adherence to industry regulations.

What you'll do

• Own the finance solution architecture for Aviva Canada’s multi-year Finance Transformation program, defining the target state across sub-ledgers, GL, IFRS17 reporting, actuarial integrations, financial controls, reporting, and analytics.

• End-to-end finance architecture: Own the architecture across operational systems, sub-ledger, GL, reporting, and analytics layers; support and assure solution designs so they remain aligned to approved architecture principles, patterns, and standards.

• Finance data flows, integration, and data architecture: Define event-driven accounting and finance data flow architecture, including integration patterns, data models, pipelines, lineage, governance, and quality controls to support accurate processing, reconciliation, reporting, analytics, and audit-ability.

• Sub-ledger, GL, IFRS17, and actuarial integration: Own the architecture approach for sub-ledgers, accounting rules engines, GL integration, IFRS17 reporting, and actuarial-to-finance platform integration, while supporting delivery teams in translating architecture into executable designs.

• Controls, reconciliation, and FRCF: Establish architecture that supports the Financial Reporting Control Framework (FRCF), embedding controls, audit-ability, reconciliation, evidence capture, and regulatory compliance into finance processes.

• Architecture governance and decision authority: Participate in the architecture governance through design authorities, review forums, and governance processes, approving key architecture decisions and supporting risk-based design decisions.

• Cross-functional alignment and influence: Partner with Canada Architecture, Finance Business, Finance Operations, IT, Aviva Group Architecture, Group Finance, Actuarial, Data Engineering, Business, and delivery teams to align with, influence, and shape architecture standards, platform decisions, and executable solution outcomes.

• Investment, vendor, and outcome leadership: Support funding and investment decisions through architecture options, technical feasibility, cost-benefit input, and business case contributions; lead architecture input into vendor and platform assessments, including build-versus-buy-versus-partner decisions; and define measurable architecture outcomes such as target-state alignment, technical debt reduction, platform adoption, control effectiveness, and reconciliation improvement.

• Cloud Finance data platform architecture: Define Snowflake and AWS-based finance data platform patterns for ingestion, processing, analytics, scalability, performance, and cost optimization.

• Finance data models and semantic layers: Build standardized finance data models, hierarchies, and regulated semantic and performance measurement layers to maintain consistent reporting, analytics, and business interpretation.

• Reusable data products: Enable certified finance datasets and reusable data products using medallion architecture that support cross-domain consumption, reduce duplication, and improve trusted data reuse.

What you'll bring

• 8+ years of experience in finance and data architecture, with exposure to finance transformation initiatives for insurance or financial institutions.

• Solid understanding of sub-ledgers, GL, accounting processes, and IFRS17 requirements.

• Strong Oracle Fusion Finance architecture expertise especially General Ledger, Accounting Hub, sub-ledgers, cash management and month-end / posting flows.

• Experience in architecting IFRS 17 and reconciliation solution including the end-to-end design from source data to actuarial outputs, sub-ledger/accounting treatment, journal generation, disclosure support, and reconciliation back to the ledger.

• Experience in data architecture, including lineage, governance, quality, and control considerations.

• Knowledge of Snowflake and Snowflake based data integration is preferred.

• Experience with integration architecture especially Oracle integration Cloud (OIC), file/data exchange, and upstream/downstream finance interfaces including actuarial

• Experience supporting architecture governance, design reviews, and risk management processes.

• Ability to influence architecture forums, standards, and key decision-making processes.

• Experience contributing to business proposals, funding discussions, and investment decisions.

• Experience assessing vendor and platform options, including build, buy, and partner models.

• Ability to define, measure, and track architecture benchmarks and delivery outcomes.

• Experience with end-to-end financial data movement, system integration, and related architecture patterns.

• Strong understanding of financial controls, audit-ability, compliance, and FRCF expectations.

• Strong partner engagement, communication, and influencing skills.

• Ability to document architecture clearly through fit-for-purpose views, including end-to-end solutions, technology, data architecture, infrastructure, network, security, and integration views.

• Experience building canonical financial data frameworks and governing semantic layers incorporating key indicators for reporting and analytics.

What you’ll get

• The salary band for this position ranges from $140,000 – 190,000. Please note that individual salary is determined by factors such as job-related knowledge, skills and experience, as well as internal equity.

• Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.

• Outstanding Career Development opportunities.

• We’ll support your professional development education.

• Competitive vacation package with the option to purchase 5 extra days off per year.

• Employee driven programs focused on gender, LGBTQ+, origins, diversity, and inclusion.

• Corporate wellness programs to support our employees’ physical and mental health.

• Hybrid flexible work model.

This job advertisement is for a new vacancy which has been posted both internally & externally.

Aviva Canada may use AI (Artificial Intelligence) tools to assist us throughout the recruitment process to screen, assess or select applicants for a position.

Aviva Canada welcomes applications from all qualified individuals and has a process in place to provide accommodations for persons with disabilities at all stages of the hiring process and during employment. If you require an accommodation during the interview or hiring process, please contact your Aviva Talent Acquisition Partner so that an appropriate accommodation can be arranged.

#LI-PS1
#LI-Hybrid