Nassau Financial Group is seeking an IT Business Data Analyst to drive critical data initiatives for life insurance and annuity products, bridging the gap between actuarial, product, and operations stakeholders and IT data engineering teams.
Requirements
- 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.
- 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.
- 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.
- 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.
- Experience with data mapping and data quality assurance
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.
- Perform data analysis by writing SQL queries to validate data sets and support the design of reports and data extracts for downstream systems.
- Oversee or participate in the testing process, including User Acceptance Testing (UAT), to ensure solutions meet business requirements and quality standards.
Other
- Excellent verbal and written communication skills, with the ability to articulate complex product features and technical details to diverse stakeholders.
- 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.
- Nassau provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
- This employer is required to notify all applicants of their rights pursuant to federal employment laws.
