Data & Reporting Strategy provides access to a comprehensive financial database populated by AXA XL’s Finance Architecture. Team members manage the Data Conformance Layer (called CL) which is home to the technical data of the Insurance Segment. This is where all data is interfaced from various source systems (the Frame, GENIUS, WINS, etc.), which includes policy level details, and is then conformed into financial codes using accurate mappings for all Insurance data. Maintaining these mappings is crucial. The available data is based on requirements for external reporting, financial MI, GL and accounting practices. Tools connect the GL to source details, whilst adhering to the guiding principles for 'a single source of truth' and other governance standards. Representing Finance, DRS assists with complex reporting needs, data analytics, and the Finance Close. This is accomplished by Financial Data Analysis, complex reconciliations, Data Quality Control, managing change requests from across the organization, and enhancement or deployment of new systems.
What you’ll be doingWhat will your essential responsibilities include?
- Source System Subject Matter Expert (SME) (the Frame, GENIUS, US Genius, WINS, Procede).
- Build a solid understanding of the financial data flow and source to ledger mappings (underwriting source system to the Financial Ledger) and be the 1st line of support for any issues.
- Develop expertise on multiple data sources, learn data structure, tables, fields etc., and extract required data using SQL queries.
- Analyse and provide fixes to data mappings to ensure the correct derivation of conformed values for the Frame source system.
- Analyse and provide resolutions to monthly financial hard stops.
- Take ownership of reviewing the balances and control reports, analyze variances and work with the relevant stakeholders to resolve irregularities including preparing of the rectification journals.
- Coordination within finance and IT teams during ITC and UAT test release cycles to ensure delivery of finance projects within defined timelines.
- Prepare balance sheet reconciliations to ensure data integrity from source to target flow of financials, often using cubes to do so.
- Act urgently to attend any critical issues in the process / financial data and work with the relevant stakeholders to restore normality.
- Perform impact assessment to any changes in the process or data flow and work through implementation including source system changes, Annual Planning and or projects.
- Participate in change assessment meetings and work with the team & line manager to prepare an action plan and ensure timely implementation of identified defects/changes.
- Liaison with the Source System IT Team for Changes Impacting Conformance.
- SME Support for Changes to Conformance Architecture for both BAU and Project.
- Manage multiple stakeholders across global locations to address their queries and provide ad-hoc support to month / quarter close activities.
- Support all relevant financial and regulatory requirements at all times.
- Review the existing processes / activities and develop additional controls for smooth operations. Have an open mindset to learn and adopt changes quickly.
- Possess effective insurance and financial knowledge and data querying/analysis skills to support BAU and Project.
- Functional interpretation, maintenance of data, data accuracy, performing and reporting and data integrity checks.
- Root Cause analysis of data errors and resolution specific to critical internal and external data.
You will report to Manager, Chief Accounting and Capital Office.What you’ll bringWe’re looking for someone who has these abilities and skills:
Required Skills And Abilities
- Require MBA/Postgraduate for financial data management role.
- Experience with various database types (e.g. SQL Server, Databricks, Excel, etc.
- Sound knowledge of Insurance. Accounting knowledge a plus.
- Outstanding proficiency in querying and manipulating large data sets for analytical purposes using SQL.
- Support Data flow and reconciliation for any external or internal Finance as well as System audit.
- Experience with communication and analytical tools, such as MS PowerPoint, MS Excel; experience with cube analytics preferred.
- Mental flexibility to creatively extract actionable insights from massive, highly sophisticated, multi-dimensional datasets while ensuring data quality.
- High energy, good work ethic, willingness to do whatever it takes to get to the results.
- Comfort with ambiguity & ability to influence others and gain acceptance for your ideas.
- Excellent problem-solving skills and root cause analysis.
Desired Skills And Abilities
- Excellent communication & interpersonal skills.
- Robust Analytical skills.
- Maintain effective communication with onshore and offshore teams (both written and verbal) and manage expectations.
- Ability to prioritize work and work resiliently in fast paced working environment.
What we offer
Inclusion
AXA XL is committed to equal employment opportunity and will consider applicants regardless of gender, sexual orientation, age, ethnicity and origins, marital status, religion, disability, or any other protected characteristic. At AXA XL, we know that an inclusive culture and enables business growth and is critical to our success. That’s why we have made a strategic commitment to attract, develop, advance and retain the most inclusive workforce possible, and create a culture where everyone can bring their full selves to work and reach their highest potential.
It’s about helping one another — and our business — to move forward and succeed.
- Five Business Resource Groups focused on gender, LGBTQ+, ethnicity and origins, disability and inclusion with 20 Chapters around the globe.
- Robust support for Flexible Working Arrangements
- Enhanced family-friendly leave benefits
- Named to the Diversity Best Practices Index
- Signatory to the UK Women in Finance Charter
Learn more at axaxl.com/about-us/inclusion-and-diversity. AXA XL is an Equal Opportunity Employer.
Total Rewards
AXA XL’s Reward program is designed to take care of what matters most to you, covering the full picture of your health, wellbeing, lifestyle and financial security. It provides competitive compensation and personalized, inclusive benefits that evolve as you do.We’re committed to rewarding your contribution for the long term, so you can be your best self today and look forward to the future with confidence.
Sustainability
At AXA XL, Sustainability is integral to our business strategy. In an ever-changing world, AXA XL protects what matters most for our clients and communities. We know that sustainability is at the root of a more resilient future. Our 2023-26 Sustainability strategy, called “Roots of resilience”, focuses on protecting natural ecosystems, addressing climate change, and embedding sustainable practices across our operations.
Our Pillars
- Valuing nature: How we impact nature affects how nature impacts us. Resilient ecosystems - the foundation of a sustainable planet and society - are essential to our future. We’re committed to protecting and restoring nature - from mangrove forests to the bees in our backyard - by increasing biodiversity awareness and inspiring clients and colleagues to put nature at the heart of their plans.
- Addressing climate change: The effects of a changing climate are far-reaching and significant. Unpredictable weather, increasing temperatures, and rising sea levels cause both social inequalities and environmental disruption. We're building a net zero strategy, developing insurance products and services, and mobilizing to advance thought leadership and investment in societal-led solutions.
- Integrating ESG: All companies have a role to play in building a more resilient future. Incorporating ESG considerations into our internal processes and practices builds resilience from the roots of our business. We’re training our colleagues, engaging our external partners, and evolving our sustainability governance and reporting.
- AXA Hearts in Action: We have established volunteering and charitable giving programs to help colleagues support causes that matter most to them, known as AXA XL’s “Hearts in Action” programs. These include our Matching Gifts program, Volunteering Leave, and our annual volunteering day - the Global Day of Giving.
For more information, please see axaxl.com/sustainability.
Who we areAXA XL, the P&C and specialty risk division of AXA, is known for solving complex risks. For mid-sized companies, multinationals and even some inspirational individuals we don’t just provide re/insurance, we reinvent it.How? By combining a comprehensive and efficient capital platform, data-driven insights, leading technology, and the best talent in an agile and inclusive workspace, empowered to deliver top client service across all our lines of business − property, casualty, professional, financial lines and specialty.With an innovative and flexible approach to risk solutions, we partner with those who move the world forward.Learn more at axaxl.com
