Note: The job is a remote job and is open to candidates in USA. RGP is a global network of experts providing solutions across on-demand talent and consulting. They are seeking a skilled Business Analyst with expertise in actuarial reporting to modernize the reporting environment by transitioning actuarial measures and reports into their Segment Data Warehouse.
Responsibilities
- Review current actuarial reports and calculations (primarily Excel and SQL-based)
- Clarify key calculation logic and underlying data relationships
- Develop detailed functional requirements and acceptance criteria as needed
- Provide instructions and clarification to developers for replicating reports within the Segment Data Warehouse
- Validate that new reports and measures adhere to business requirements and expected outputs
- Investigate discrepancies and assist in troubleshooting by performing detailed data analysis
- Coordinate user acceptance testing and manage the process through final signoff
- Ensure timely communication and resolution of testing issues
Skills
- 7+ years of accounting experience, with a strong focus on reinsurance or insurance industry, specifically in actuarial or reserving reporting processes
- Strong understanding of actuarial calculations, data structures, and drivers behind reserving and financial reporting
- Ability to translate complex business rules into clear, actionable requirements and acceptance criteria
- Hands-on experience validating data accuracy and reconciling reports
- High Proficiency in Excel, SQL, and familiarity with enterprise data warehouse environments
- Strong analytical and problem-solving skills; ability to identify anomalies and recommend solutions
- Excellent communication and stakeholder coordination skills
Benefits
- Medical
- Dental
- Vision
- Life Insurance
- Disability Insurance
- 401(k) Savings Plan
- Employee Stock Purchase Plan
- Professional Development Program
- Paid Time Off
- Paid Sick Time (in geographies where legally required)
Company Overview
RGP (Nasdaq: RGP) is an award-winning global professional services firm with three decades of experience helping the world’s top organizations navigate change and seize opportunity. It was founded in 2004, and is headquartered in Cincinnati, Ohio, USA, with a workforce of 1001-5000 employees. Its website is http://www.xperianz.com/.