IT Business Data Analyst

Nassau•Hartford, CT

53d

About The Position

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. Key Responsibilities Ownership & Initiative: Take ownership of assigned data projects and initiatives, proactively identifying risks, driving solutions, and delivering results with minimal supervision. Data Mapping & Analysis: 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. Industry Standards: Utilize and enforce ACORD data standards and models during data mapping and requirements gathering phases to ensure interoperability and consistency across systems. Requirements Management: 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 Domain Expertise: Apply in-depth knowledge of life insurance and annuity products to ensure data models accurately reflect financial details and regulatory needs. System Collaboration: Work closely with IT developers, and architects to translate business strategies into clear system logic and ensure flawless delivery of solutions. Data Analysis & Reporting: Perform data analysis by writing SQL queries to validate data sets and support the design of reports and data extracts for downstream systems. Project Support: Participate in project planning, provide estimates, and support testing cycles (UAT) to ensure deployed data solutions meet business requirements and quality standards. Process Improvement & Optimization: Assess operational impacts of changes, identify opportunities for process improvement or automation, and design solutions to enhance operational efficiency and customer experience. Testing & Quality Assurance: Oversee or participate in the testing process, including User Acceptance Testing (UAT), to ensure solutions meet business requirements and quality standards.

Requirements

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.
A minimum of 5 years of experience as a IT Data Business Analyst, with proven experience in the life insurance and annuity industry.
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.

Nice To Haves

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.

Responsibilities

Take ownership of assigned data projects and initiatives, proactively identifying risks, driving solutions, and delivering results with minimal supervision.
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.
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
Apply in-depth knowledge of life insurance and annuity products to ensure data models accurately reflect financial details and regulatory needs.
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.