IT Business Data Analyst - Life & Annuity

IT Business Data Analyst - Life & Annuity Job Category : Information Technology Requisition Number : DATAA002126 Posted: May 4, 2026 Full-Time On-site Locations Showing 1 location Hartford Office Hartford, CT 06102, USA Description Job Summary We are seeking an IT Business Data Analyst to join our Enterprise Data Warehouse (EDW) team, focusing on data initiatives within our life insurance and annuity product lines. This role requires subject matter expertise in life insurance and annuity products to drive critical data initiatives, including complex data mapping and data quality assurance. This role is pivotal in bridging the gap between actuarial, product, and operations stakeholders, and our IT data engineering teams which ensures our enterprise data platforms accurately capture the details of these financial products. Principal Duties and Responsibilities Lead and execute comprehensive source‑to‑target data mapping exercises for data ingestion into the Enterprise Data Warehouse, ensuring accuracy and integrity of data fields relating to life and annuity products. Apply in‑depth knowledge of life insurance and annuity products to ensure data models accurately reflect financial details and regulatory needs. Utilize and enforce ACORD data standards and models during data mapping and requirements gathering phases to ensure interoperability and consistency across systems. Analyze, document, and communicate detailed business requirements for data initiatives (e.g., data lineage, data quality rules, reporting needs) by collaborating with stakeholders and leveraging domain knowledge. Work closely with IT developers and architects to translate business strategies into clear system logic and ensure flawless delivery of solutions. Perform data analysis by writing SQL queries to validate data sets and support the design of reports and data extracts for downstream systems. Participate in project planning, provide estimates, and support testing cycles (UAT) to ensure deployed data solutions meet business requirements and quality standards. Assess operational impacts of changes, identify opportunities for process improvement or automation, and design solutions to enhance operational efficiency and customer experience. Oversee or participate in the testing process, including User Acceptance Testing (UAT), to ensure solutions meet business requirements and quality standards. Take ownership of assigned data projects and initiatives, proactively identifying risks, driving solutions, and delivering results with minimal supervision. Perform other duties as assigned. Knowledge, Skills and Abilities 5 years of experience as an IT Data Business Analyst, with proven experience in the life insurance and annuity industry. Excellent verbal and written communication skills, with the ability to articulate complex product features and technical details to diverse stakeholders. Utilize expertise in Database Management Systems (DBMS) to write and execute complex SQL queries for thorough data profiling, validation, testing, and ad‑hoc analysis directly within source systems and the data warehouse environment. Must be self‑motivated, demonstrating accountability and a strong sense of complete ownership over their workstream and deliverables. Strong understanding of financial terms, investment products, and the specific mechanics of life insurance and annuity policies, claims, and underwriting processes. Excellent analytical, critical thinking, and problem‑solving skills to evaluate complex business challenges and recommend solutions. Proficiency in industry‑standard software and tools, such as Jira, SQL IDE, MS Excel, MS Word, Visio, and business intelligence platforms. Experience working within Agile or Waterfall software development life cycles (SDLC) and project management methodologies. Preferred Qualifications Familiarity with Amazon Web Services (AWS) concepts and services (e.g., S3 for data storage, AWS Glue, Lambda and basic cloud architecture principles) is a significant advantage. Compensation Nassau maintains a holistic compensation philosophy focused on competitive base salaries, performance driven incentives, and unique professional development opportunities. The base salary for this position falls within Nassau’s salary band D: $90,000‑$100,000 depending on experience. Equal Opportunity Employer This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor. #J-18808-Ljbffr Nassau Financial Group