Job Description

Act in a support role for Data Balance & Controls monitoring, Data Quality, Testing, and Documentation under the direction of Source System to EE Data SME Lead and/or Sr. Analysts. DISCOVER your opportunity What will your essential responsibilities include Refresh and maintain data quality SSAS cubes. Assist in defect tracking and build data quality tools using SQL and SSAS. Support resolution of data quality issues either through the definition of required source system changes or recommending workflow/process changes. Monitor the Data Quality cubes built on EFR and address inconsistencies with the assistance of the Lead as needed. Utilize SQL skills to provide data to users for testing (Extracts and Cubes). Draft test plans and perform testing for Business Validation Testing (BVT), UAT support, and Regression testing of the sources system changes. Log defects with thorough descriptions and evidence. Communicate testing statuses. Support Lead and Sr. Analysts in ensuring the source systems data nuances are accurately reflected within the EE logical data models and the broader AXA XL logical data models. Monitor balance and control reports, perform table-level reconciliations, maintain documentation, research out-of-balances, work with business and the IT department to triage and resolve straightforward issues, and escalate complex items to the Lead. Make sure the Lead is kept abreast of statuses. Under the direction of the Lead or Sr. Analyst, support data anomaly research and resolution. May require coordination with other EE Finance Operations teams as well as with users outside of the EE team. SHARE your talent We\'re looking for someone who has these abilities and skills: Required Skills and Abilities: Expertise in SQL, SSAS, SSIS, and Excel(required). Working knowledge of Microsoft SQL server 2012 and above. Build and maintain SSAS cubes. SQL query optimization. Maintain Stored Procedures. Ability to develop and run SSIS packages to refresh month-end cubes. Insurance and/or Reinsurance knowledge (preferred) preferably gotten through experience at an insurance company, reinsurance company, agency, or consulting firm. Experience with one or more data management disciplines such as Data Governance, Master Data Management, Data Quality, Data Warehousing, Reporting, etc. (preferred). Desired Skills and Abilities: Robust analytical skills (required). Ability to take direction from US or UK onshore resources, work self-directly and be accountable for assigned work (required). Robust organization and multi-tasking skills (required). Good written and verbal communication skills (required). Ability to work in a fast-paced Agile environment. FIND your future AXA XL, the P&C and specialty risk division of AXA, is known for solving complex risks. For mid-d 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 Inclusion & Diversity 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 a diverse workforce enable business growth and are critical to our success. That\'s why we have made a strategic commitment to attract, develop, advance, and retain the most diverse workforce possible, and create an inclusive culture where everyone can bring their full selves to work and can reach their highest potential. 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 . AXA XL is an Equal Opportunity Employer. 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

foundit