Finance Data & AI Lead for Oracle Fusion

AV; San Diego (CA); On-site; USD 89,000 - 136,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401K with company matching

9/80 work schedule

Paid holiday shutdown

Job summary

AV in San Diego, CA seeks a Senior Data & AI Analyst, Finance Systems to own financial data migration for Oracle Fusion and to pioneer AI-driven finance operations. You will lead end-to-end conversion, build AI-enabled data quality workflows, and guide data governance across ERP and EPM platforms.

You will collaborate with FP&A, Accounting, and IT to implement AI agents, automate anomaly detection, and create reports and dashboards that advance forecasting and close processes.

Qualifications

• Bachelor's degree in Finance, Accounting, Computer Science, Data Science, or related field (Master's in Data Science, AI, or related field preferred)
• 5+ years of experience in financial data management, ERP data migration, or business intelligence/analytics
• 2+ years hands-on experience building AI/LLM applications, intelligent agents, or machine learning models
• Proven experience leading at least 2 full-cycle ERP data conversions from planning through post-go-live stabilization

Responsibilities

• Lead end-to-end data conversion planning for Oracle Fusion, including scope definition, data source identification, mapping specifications, and conversion schedules
• Extract, transform, and load financial data from legacy systems (Chart of Accounts, customer/vendor masters, open balances, historical transactions, asset registers)
• Develop and maintain data mapping documents that translate legacy data structures to Oracle Fusion Cloud data models (Procure to Pay, Record to Report, Quote to Cash, Project to Close)
• Execute iterative mock conversion cycles with progressively tighter quality gates and validation checkpoints
• Coordinate with IT Infrastructure team on technical data extraction, FBDI file generation, and API-based data loading
• Design and implement comprehensive data quality rules, reconciliation controls, and exception handling processes; build automated validation scripts, profiling reports, and dashboards using Python, SQL, and AI/ML frameworks
• Partner with Accounting SMEs to validate converted balances, ensure trial balance integrity, and resolve discrepancies
• Develop predictive models for financial forecasting, anomaly detection in journal entries, and intelligent close process monitoring
• Design and build AI-powered intelligent agents using large language models for finance process automation
• Develop LLM-based data quality agents that automatically detect anomalies, validate business rules, and suggest corrections during data migration and ongoing operations
• Create conversational AI interfaces for finance users to query data, generate reports, and troubleshoot issues through natural language
• Build intelligent document processing pipelines using LLMs for invoice extraction, contract analysis, and regulatory filing automation
• Implement prompt engineering frameworks, retrieval-augmented generation (RAG), fine-tuning strategies, and governance frameworks for responsible AI use including bias detection, explainability, and audit trails
• Support data migration and integration for Oracle EPM Cloud (PBCS, FCCS, Planning) connecting to Oracle Fusion actuals and subledger data
• Troubleshoot reporting issues in Oracle Fusion (OTBI, BIP, Smart View, FBDI) and SplashBI, diagnosing data quality problems and performance bottlenecks
• Partner with FP&A and Accounting on EPM data flows, dimension hierarchies, and planning/forecasting data structures
• Support Apex application rollout through data integration, ensuring clean data pipelines between Apex, Fusion, and EPM environments
• Establish data governance frameworks for master data (COA, customers, vendors, projects) including ownership, quality rules, stewardship processes, data lineage documentation, and metadata repositories for regulatory compliance

Skills

Python

SQL

AI/ML knowledge

Data governance

Analytical thinking

Education

Bachelor's degree in Finance/Accounting/Data Science

Master's in Data Science/AI (preferred)

Tools

Oracle FBDI

SSIS

Informatica

Alteryx

Git

CI/CD

OpenAI GPT

Anthropic Claude

Google Gemini

LangChain

LlamaIndex

AutoGen

CrewAI

Job description

AV in San Diego, CA seeks a Senior Data & AI Analyst, Finance Systems to own financial data migration for Oracle Fusion and to pioneer AI-driven finance operations. You will lead end-to-end conversion, build AI-enabled data quality workflows, and guide data governance across ERP and EPM platforms.

You will collaborate with FP&A, Accounting, and IT to implement AI agents, automate anomaly detection, and create reports and dashboards that advance forecasting and close processes.