Senior Data & AI Analyst, Finance Systems

Worker TypeRegularJob DescriptionSummaryThe Senior Data & AI Analyst, Finance Systems owns financial data migration for Oracle Fusion implementation while pioneering the use of AI, large language models (LLMs), and intelligent agents to transform finance operations. This role combines traditional data conversion excellence with cutting-edge AI capabilities, building intelligent workflows for data quality, process automation, anomaly detection, and predictive analytics. This position reports directly to the Director, Finance Systems and serves as the technical lead for data and emerging AI initiatives.Position ResponsibilitiesFinance Systems Data Operations & MigrationLead end-to-end data conversion planning for Oracle Fusion, including scope definition, data source identification, mapping specifications, and conversion schedulesExtract, 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 (Mock 1, Mock 2, Final) with progressively tighter quality gates and validation checkpointsCoordinate with IT Infrastructure team on technical data extraction, FBDI file generation, and API-based data loadingData Quality, Validation & AnalyticsDesign 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 frameworksPartner with Accounting SMEs to validate converted balances, ensure trial balance integrity, and resolve discrepanciesDevelop predictive models for financial forecasting, anomaly detection in journal entries, and intelligent close process monitoringAI/LLM & Intelligent Agent DevelopmentDesign and build AI-powered intelligent agents using large language models (GPT, Claude, Gemini, or open-source alternatives) for finance process automationDevelop LLM-based data quality agents that automatically detect anomalies, validate business rules, and suggest corrections during data migration and ongoing operationsCreate conversational AI interfaces for finance users to query data, generate reports, and troubleshoot issues through natural languageBuild intelligent document processing pipelines using LLMs for invoice extraction, contract analysis, and regulatory filing automationImplement prompt engineering frameworks, retrieval-augmented generation (RAG), fine-tuning strategies, and governance frameworks for responsible AI use including bias detection, explainability, and audit trailsEPM, Reporting & Data GovernanceSupport data migration and integration for Oracle EPM Cloud (PBCS, FCCS, Planning) connecting to Oracle Fusion actuals and subledger dataTroubleshoot reporting issues in Oracle Fusion (OTBI, BIP, Smart View, FBDI) and SplashBI, diagnosing data quality problems and performance bottlenecksPartner with FP&A and Accounting on EPM data flows, dimension hierarchies, and planning/forecasting data structuresSupport Apex application rollout through data integration, ensuring clean data pipelines between Apex, Fusion, and EPM environmentsEstablish data governance frameworks for master data (COA, customers, vendors, projects) including ownership, quality rules, stewardship processes, data lineage documentation, and metadata repositories for regulatory complianceSupport finance transformation projects through data analysis, migration support, and capitalization documentationCross-Functional Collaboration & InnovationCoordinate with Business Units, IT Infrastructure, and external vendors to secure data extracts, coordinate conversion windows, and troubleshoot technical issuesPartner with Senior Manager, Finance Systems to align data conversion schedules with functional configuration timelines and testing cyclesEvangelize AI/LLM capabilities across Finance organization through proof-of-concepts, workshops, lunch-and-learns, and documentation; build internal capability by training team members on effective LLM usageMaintain knowledge of emerging AI technologies, attend conferences/training, and share best practices through cross-team collaborationProduction Support, Post-Go-Live & Continuous ImprovementProvide ongoing production support for existing finance systems data flows, reporting, and integrations (Oracle Fusion, EPM, Apex, and other applications); execute data migration activities for Oracle Fusion and other finance system implementations; own hypercare support for data-related issues (balance mismatches, missing records, data correction requests)Develop and maintain ongoing data quality monitoring processes leveraging AI agents for real-time anomaly detection; document data lineage, transformation logic, business rules, and AI model documentation for audit complianceTrain Finance Systems team on data maintenance procedures, AI agent usage, and troubleshooting techniquesBasic Qualifications (Required Skills & Experience)Education & ExperienceBachelor'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/analytics2+ years hands-on experience building AI/LLM applications, intelligent agents, or machine learning models (personal projects, hackathons, or professional work)Proven experience leading at least 2 full-cycle ERP data conversions from planning through post-go-live stabilizationTechnical & AI SkillsExpert-level proficiency with Python (pandas, numpy, scikit-learn) for data transformation, analysis, and machine learningHands-on experience with LLM APIs (OpenAI GPT, Anthropic Claude, Google Gemini), prompt engineering techniques, and AI agent frameworks (LangChain, LlamaIndex, AutoGen, CrewAI) including retrieval-augmented generation (RAG) architecturesStrong SQL skills for data extraction, transformation, and validation across relational databasesExperience with data integration tools (Oracle FBDI, APIs, SSIS, Informatica, Alteryx), cloud data platforms (Oracle Cloud, AWS, Azure), and software development best practices including version control (Git) and CI/CD pipelines for production AI deploymentsExperience with Oracle EPM Cloud data structures, integration patterns, and reporting (PBCS, FCCS, Planning preferred)Strong troubleshooting skills for Oracle Fusion reporting tools (OTBI, BIP, Smart View) and third-party BI platforms (SplashBI, Power BI, Tableau)Working knowledge of data governance principles, MDM concepts, and data quality frameworksExperience supporting Apex application rollouts through data integration and connectivityFinance & Analytical SkillsStrong understanding of financial accounting principles, chart of accounts structures, and subledger-to-general ledger reconciliationExperience with Oracle Fusion data models (Procure to Pay, Record to Report, Quote to Cash, Project to Close) or comparable ERP data structuresExceptional analytical skills with ability to investigate complex data issues, identify root causes, and implement sustainable solutionsMeticulous attention to detail and commitment to accuracy—zero tolerance for data quality compromisesStrong documentation skills with ability to create clear, comprehensive technical documentation for both technical and non-technical audiencesInnovation & Collaboration SkillsEntrepreneurial mindset with passion for exploring emerging technologies and building innovative solutionsAbility to translate business problems into AI/data science solutions and articulate value propositions to non-technical stakeholdersComfortable working in ambiguity, experimenting with new approaches, and iterating based on feedbackCollaborative approach with strong communication skills for presenting technical concepts, demonstrating prototypes, and building stakeholder buy-in across Finance, IT, and external AI/data science communitiesPhysical DemandsAbility to work in an office environment (Constant)Required to sit and stand for long periods; talk, hear, and use hands and fingers to operate a computer and telephone keyboard (Frequent)Clearance LevelNo ClearanceThe salary range for this role is:$89,000 - $135,750AeroVironment considers several factors when extending an offer, including but not limited to, the location, the role and associated responsibilities, a candidate’s work experience, education/training, and key skills.ITAR Requirement:This position requires access to information that is subject to compliance with the International Traffic Arms Regulations (“ITAR”) and/or the Export Administration Regulations (“EAR”). In order to comply with the requirements of the ITAR and/or the EAR, applicants must qualify as a U.S. person under the ITAR and the EAR, or a person to be approved for an export license by the governing agency whose technology comes under its jurisdiction. Please understand that any job offer that requires approval of an export license will be conditional on AeroVironment’s determination that it will be able to obtain an export license in a time frame consistent with AeroVironment’s business requirements. A “U.S. person” according to the ITAR definition is a U.S. citizen, U.S. lawful permanent resident (green card holder), or protected individual such as a refugee or asylee. See 22 CFR § 120.15. Some positions will require current U.S. Citizenship due to contract requirements. Benefits: AV offers an excellent benefits package including medical, dental vision, 401K with company matching, a 9/80 work schedule and a paid holiday shutdown. For more information about our company benefit offerings please visit: .We also encourage you to review our company website at to learn more about us.Principals only need apply. NO agencies please.About AV:AV isn’t for everyone. We hire the curious, the relentless, the mission-obsessed. The best of the best.We don’t just build defense technology—we redefine what’s possible. As the premier autonomous systems company in the U.S., AV delivers breakthrough capabilities across air, land, sea, space, and cyber. From AI-powered drones and loitering munitions to integrated autonomy and space resilience, our technologies shape the future of warfare and protect those who serve.Founded by legendary innovator Dr. Paul MacCready, AV has spent over 50 years pushing the boundaries of what unmanned systems can do. Our heritage includes seven platforms in the Smithsonian—but we’re not building history, we’re building what’s next.If you're ready to build technology that matters—with speed, scale, and purpose—there’s no better place to do it than AV.We are proud to be an EEO/AA Equal Opportunity Employer, including disability/veterans. AeroVironment, Inc. is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Qualified applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, disability, protected veteran status, genetic data, sexual orientation, gender identity or other legally protected status.ITARU.S. Citizen, U.S. Permanent Resident (Green Card holder), asylee/refugee status as defined by 8 U.S.C. 1324b(a)(3) or a person approved for an export license from the appropriate governing agency.SummaryLocation: Simi Valley, CA; Dayton, OH; Albuquerque, NM; Huntsville, AL; Sunrise, FL; Herndon, VA; Arlington, VA; Germantown, MD; Melbourne, FL; San Diego, CAType: Full time