Accounting BSA (Business Systems Analyst)

Volto Consulting; West Des Moines (IA); On-site; USD 90,000 - 130,000; Full time

Job summary

Volto Consulting seeks an Accounting BSA to bridge accounting and IT, ensuring financial systems meet business and regulatory needs. You’ll document requirements, design system solutions, and support ERP implementations across SAP FI/CO, Oracle Cloud, and Guidewire modules.

Responsibilities include validating integrations, building UPR and reserve calculations, and enabling compliance reporting with GAAP and SOX controls. Strong SQL/Excel and data analytics are essential.

Qualifications

• Must be able to gather and document business requirements with stakeholders.
• Experience with ERP systems and insurance finance processes.
• Strong understanding of GAAP and regulatory reporting.

Responsibilities

• Gather requirements and analyze insurance workflows for accurate system design.
• Support ERP implementation, configuration, and testing across modules.
• Build accounting processes for recognition, reserves, and settlements.
• Ensure data integrity across sub-ledgers and GL with reconciliations.
• Create dashboards and KPIs for financial and regulatory reporting.

Skills

Accounting

SQL

Excel (advanced)

Data modeling

Power BI/Tableau

APIs/integrations

Problem solving

Communication

Education

Bachelor's degree in accounting or finance

Tools

SAP FI/CO

Oracle Cloud

Guidewire Billing

Duck Creek

Job description

Responsibilities

An Accounting BSA (Business Systems Analyst) plays a crucial role in bridging the gap between accounting teams and IT or system development teams. Their primary responsibility is to ensure that financial systems and processes are aligned with business needs and regulatory requirements. Here’s a breakdown of their key responsibilities:

West Des Moines, Iowa - Contract

Full-time

Job Description

Accounting BSA

Must Have Technical/Functional Skills

Responsibilities

An Accounting BSA (Business Systems Analyst) plays a crucial role in bridging the gap between accounting teams and IT or system development teams. Their primary responsibility is to ensure that financial systems and processes are aligned with business needs and regulatory requirements. Here’s a breakdown of their key responsibilities:

Requirements Gathering & Analysis

Partner with accounting, finance, and insurance operations to gather and document business requirements.

Analyze insurance-specific workflows: policy administration, premium billing, claims accounting, commissions, and reinsurance settlements (ceded/assumed).

Translate business requirements into system designs, process maps, user stories, and acceptance criteria.

System Implementation & Support

Support implementation, configuration, and testing of ERP and insurance platforms (e.g., SAP FI/CO, Oracle Cloud, Guidewire Billing/Policy/Claims, Duck Creek).

Design and validate system integrations between policy, billing, claims, and general ledger modules.

Create and execute test plans (unit, SIT, UAT); manage defect triage and remediation; support change control.

Insurance Process Management

Build and optimize accounting processes for premium recognition, unearned premium reserves (UPR), loss reserves, IBNR, claims payments, and commissions.

Implement system logic for reinsurance (treaty/facultative; proportional/non-proportional), bordereaux, and settlements.

Partner with actuarial and underwriting on loss ratio, combined ratio, and reserve-related data and reporting.

Data Integrity & Reporting

Ensure data completeness, accuracy, and reconciliation across sub-ledgers and the GL.

Develop dashboards and financial/insurance KPIs (e.g., written/earned premium trends, loss & LAE, expenses).

Support statutory and regulatory reporting (e.g., NAIC statements, Schedule P, Schedule F) and management reporting.

Compliance, Controls & Audit

Ensure adherence to GAAP, SAP (Statutory Accounting Principles), SOX, and state insurance regulations.

Design and maintain internal controls; support audit requests and walkthroughs for insurance-specific areas.

Document end-to-end process controls, segregation of duties, and data lineage across systems.

Cross-functional Collaboration

Act as a liaison between Accounting, IT, Insurance Operations, Actuarial, Underwriting, Claims, Billing, and Compliance.

Facilitate workshops, sprint planning, and stakeholder alignment; manage expectations and timelines.

Training & Documentation

Create and deliver training for end users on enhancements and new features.

Maintain process documentation, configuration guides, data dictionaries, and SOPs.

Roles & Responsibilities

Accounting Expertise: GL, sub-ledgers, reconciliations, month-end close, revenue recognition, reserves.

Insurance Knowledge: Policy lifecycle, billing, claims, reinsurance structures, statutory reporting.

Technical Skills: SQL, Excel (advanced), data modeling, APIs/integrations, reporting tools (Power BI/Tableau).

Analysis & Problem-Solving: Root-cause analysis, process re-engineering, control design.

Communication & Stakeholder Engagement: Clear documentation, workshops, cross-functional alignment.

Project/Change Management: Prioritization, risk management, change control, UAT coordination.

Strong understanding of accounting principles.

Experience with ERP systems (e.g., SAP, Oracle R12, NetSuite).

Proficiency in SQL, Excel, and reporting tools (e.g., Power BI, Tableau).

Analytical thinking and problem-solving.

Communication and project management skills.