Associate Data Analyst

Our goal at FedPoint is to foster an engaging environment for our employees that promotes career growth and supports a work-life balance. From professional development to wellness programs to volunteer opportunities, we have created a culture that puts our employees on a positive pathway to success.

About Fed Point
FedPoint creates and operates digital benefits marketplaces that make it easy forour millions of federal and military customers to understand, select, and use their benefits.

A subsidiary of John Hancock Life & Health Insurance Company, FedPoint was founded in 2002 and is headquartered in Portsmouth, NH.

Our mission
Create and deliver world-class benefits experiences for our customers, clients, and business partners.

Associate Data Analyst
Department: Business Systems Support (BSS)
Location: Portsmouth, NH
Schedule: Hybrid – 2 days per week in office (Portsmouth, NH)
FLSA Status: Exempt

FedPoint is seeking a detail-oriented, technically curious Associate Data Analyst to join our Business Systems Support (BSS) team. This role is ideal for someone who enjoys solving data challenges, supporting business partners, and strengthening system integrity in a collaborative environment.

This is a hybrid position requiring two days per week onsite in our Portsmouth, NH office
, offering flexibility while maintaining strong in-person collaboration with the team.

The Associate Data Analyst plays a key role in maintaining data health across business systems. You will execute data controls, perform quality assurance checks, support reporting needs, and assist with system inquiries and issue tracking. This position offers hands‑on experience with SQL, reporting tools, and system testing while working alongside experienced analysts and IT partners.

You will gain exposure to both technical and business‑facing responsibilities, making this an excellent opportunity for growth in business systems analysis and data operations.

Data Repair & Quality Assurance

Execute routine and low‑complexity data fixes using SQL in production and test environments

Validate correction outputs to ensure compliance with business rules

Document fixes and contribute to the team knowledge base

Participate in peer reviews and quality control processes

Control Analysis & Systems Support

Review Daily Data Duty reports and identify inconsistencies

Assist in building and testing SQL scripts

Execute data scans to confirm downstream impacts

Support production promotions under guidance

Business Support & Issue Handling

Gather and document details for business‑reported issues

Research system behavior and help catalog change requests or defects

Maintain documentation of known issues and workarounds

Reporting & Data Requests

Run approved queries for recurring and ad hoc reports

Validate report accuracy and completeness

Maintain documentation of reporting logic and delivery methods

Special Projects & Testing

Contribute to documentation clean‑up and data inventory efforts

Participate in QA and production testing for system releases and seasonal programs

Engage in team initiatives and cross‑program collaboration

Training & Growth

Receive mentorship and coaching from experienced analysts

Enhance technical knowledge of systems and tools

Actively seek feedback and contribute to continuous improvement efforts

Education & Experience

Bachelor’s degree or equivalent experience in business analysis or systems analysis

1+ year of experience writing business procedures or documentation

1+ year experience with BENEFEDS or FLTCIP systems, or in a business analysis role

Experience with business intelligence tools a plus

Insurance or benefit administration experience preferred

Technical & Professional Skills

Strong technical aptitude and foundational knowledge of relational databases

Experience with Excel, Word, Outlook (Visio or Access a plus)

Familiarity with reporting tools such as SSRS, Oracle, Webfocus, TOAD, or Access

Understanding of KPIs and business reporting metrics

Excellent communication, organization, and prioritization skills

Ability to work independently and collaboratively

Customer‑focused mindset with strong…