Associate Data Analyst

FedPoint; Portsmouth (NH); Hybrid; USD 56,000 - 75,000; Full time

Benefits offered by this job

401k match

Bonus program

Paid time off

Health benefits

Tuition reimbursement

Volunteer program

Parental leave

Job summary

FedPoint seeks a detail‑oriented Associate Data Analyst to support data health across business systems. You will perform data repairs, quality assurance, and reporting while partnering with IT and business teams in a collaborative, growth‑focused environment.

You will gain hands‑on experience with SQL, reporting tools, and system testing, enabling growth in data operations and business systems analysis within a hybrid Portsmouth, NH setting.

Qualifications

• Bachelor's degree or equivalent in business or systems analysis.
• 1+ year writing business procedures or documentation.
• 1+ year with BENEFEDS or FLTCIP systems or in a business analysis role.
• Experience with BI tools is a plus.
• Insurance or benefit administration experience preferred.

Responsibilities

• Data Repair & Quality Assurance: execute low‑complexity data fixes using SQL in production and test environments; validate outputs for business rules; document fixes; participate in peer reviews.
• Control Analysis & Systems Support: review Daily Data Duty reports; assist in building/testing SQL scripts; run data scans; support production promotions.
• Business Support & Issue Handling: gather details for business‑reported issues; research system behavior; catalog defects; maintain issue/workaround docs.
• Reporting & Data Requests: run approved queries for recurring and ad hoc reports; validate accuracy; document reporting logic.
• Special Projects & Testing: contribute to data inventory and QA; participate in testing for releases and programs; collaborate across teams.
• Training & Growth: receive mentorship; expand knowledge of systems and tools; seek feedback for improvement.

Skills

Data analysis

SQL

Attention to detail

Communication

Independent worker

Education

Bachelor's degree

Business analysis experience

BENEFEDS/FLTCIP experience

Tools

SQL

SSRS

Oracle

WebFocus

TOAD

Access

Excel

Visio

Job description

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 FedPoint
FedPoint creates and operates digital benefits marketplaces that make it easy forour millions of federal and military customersto 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

Join a Team Where Data Drives Impact

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.

About the Role

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.

What You’ll Do

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

What You Bring

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 attention to detail

Location: Portsmouth, NH

Schedule: Hybrid 2 days in the office, with up to 3 days telework - Monday-Friday

What to Expect on Pay:

The salary range for this role is $55,679 - $75,331 per year. We’ve shared the full range to stay transparent — but most new hires join us between the minimum and the midpoint, depending on skills and experience.

Final compensation is based on a mix of factors including qualifications, experience, and education, as well as internal equity and budget considerations.

Your Impact Within Our Team

The BSS team serves as the bridge between business stakeholders and IT, delivering high‑quality, cost‑effective system solutions. We operate as business and process consultants while maintaining strong technical rigor in reporting, controls, and data integrity.

You’ll be part of a supportive team that values initiative, continuous learning, and collaboration—while building technical expertise that directly impacts operational performance.

Why Join Us?

At FedPoint, our mission is to create and deliver world‑class benefits experiences for our customers, clients, and business partners.

We offer a dynamic work environment where innovation and collaboration are encouraged. You’ll have the opportunity to make a significant impact while honing your skills and advancing your career.

In addition to working for a company with great people and an excellent reputation, what’s in it for you?

• Generous 401k plan: 100% match of employee's contribution, up to a maximum of 6% salary, vests immediately.
• Bonus Opportunity: Qualifying employees can earn up to 7% of their salary, based on company performance. (Inquire about eligibility with our recruiter)
• Lots of paid time off:3 weeks’ vacation, 7 sick days, 3 personal days, and 12 paid holidays!
• Competitive benefits include health, dental, vision, disability, life, legal, flexible spending account (FSA) and Health Savings Account (HSA) options.
• 6 weeks fully‑paid parental leave
• Tuition reimbursement program to support career goals.
• Corporate giving and matching gifts program.
• Volunteer program: Paid time off to volunteer and company-organized volunteering opportunities.
• A wide variety of personal, professional, and career development programs.
• Comprehensive wellness program offering a variety of resources and activities to help support your well‑being in the following areas: career, financial, mental, emotional, physical, social and community.

All offers of employment with FedPoint are conditional upon satisfactory completion of a pre-employment background check.

FedPoint is an equal opportunity employer as to all protected groups under applicable federal, state and local laws, including protected veterans and individuals with disabilities.