Business Data Analyst Jobs in Connecticut

INTRODUCTION

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.

ROLE AND 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.

BASIC QUALIFICATIONS

- Communication: Excellent verbal and written communication skills, with the ability to articulate complex product features and technical details to diverse stakeholders.
- DBMS Knowledge: 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.
- Personal Attributes: Must be self-motivated, demonstrating accountability and a strong sense of complete ownership over their workstream and deliverables.
- Experience: A minimum of 5 years of experience as an IT Data Business Analyst, with proven experience in the life insurance and annuity industry.
- Financial Acumen: Strong understanding of financial terms, investment products, and the specific mechanics of life insurance and annuity policies, claims, and underwriting processes.
- Analytical Skills: Excellent analytical, critical thinking, and problem-solving skills to evaluate complex business challenges and recommend solutions.
- Technical Proficiency: Proficiency in industry-standard software and tools, such as Jira, SQL IDE, MS Excel, MS Word, Visio, and business intelligence platforms.
- Methodologies: Experience working within Agile or Waterfall software development life cycles (SDLC) and project management methodologies.

PREFERRED QUALIFICATIONS

- AWS Knowledge: 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 combination of compensation, benefits, and an entrepreneurial culture along with related experiences is key to recruiting and retaining talent. Our compensation system is designed to reward performance, support development and job growth, and compensate individuals relative to their contribution to our organization. The base salary for this position falls within Nassau’s salary band D: $90,000-$100,000 depending upon experience.

LOCATION

Based in Hartford, Connecticut, Nassau Financial Group is a growth focused and digitally enabled financial services company with a fully integrated platform across insurance and asset management. Nassau was founded in 2015 and has grown to $1.6 billion in total adjusted capital, $25.6 billion in assets under management, and 361,000 policies and contracts as of September 30, 2025.

As part of a young and growing financial services enterprise, our employees are tapping into a new entrepreneurial spirit while they build on a long track record of putting customers first, understanding the evolving income and protection needs, and developing quality products to meet those needs.

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 policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.