Associate Data Analyst

Posted 4 Days Ago
Portsmouth, NH, USA
In-Office
56K-75K Annually
Junior
HR Tech • Insurance • Professional Services • Software
The Role
Maintain data health across business systems by executing routine SQL fixes, performing QA and control analysis, supporting reporting and issue tracking, documenting processes, and participating in testing and special projects while collaborating with stakeholders and receiving mentorship.
Summary Generated by Built In

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 executing SQL queries preferred

  • 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.

If you believe you need a reasonable accommodation in order to search for a job opening or to submit an online application, please call (603) 433-4500. Equal Employment Opportunity (EEO) Poster Family and Medical Leave Act (FMLA) Poster Employee Polygraph Protection Act Poster

Skills Required

  • 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
  • Strong technical aptitude and foundational knowledge of relational databases
  • Experience with Excel, Word, Outlook
  • 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
  • Experience executing SQL queries
  • Experience with business intelligence tools
  • Insurance or benefit administration experience
  • Visio or Access experience (a plus)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
425 Employees

What We Do

FedPoint is a leading third-party administrator of large-scale insurance and health benefit programs for federal civilian and uniformed services markets. A wholly owned subsidiary of John Hancock Life & Health Insurance Company, it provides secure digital benefits marketplaces and administrative infrastructure, including the BENEFEDS platform, to power critical federal benefit programs for millions of individuals.

Similar Jobs

Wipfli Logo Wipfli

Tax Senior Manager - Real Estate

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
142K-192K Annually

Wipfli Logo Wipfli

Tax Manager

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
106K-160K Annually

Wipfli Logo Wipfli

Manager, Accounting Advisory - Behavioral Health Industry

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
107K-160K Annually

Wipfli Logo Wipfli

Payroll Support Specialist

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
21-28 Hourly

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account