Data Analyst – Operations

Department: Business Systems Support (BSS)

Location: Portsmouth, NH

Schedule: Hybrid – 2 days per week in office (Portsmouth, NH)

FLSA Status: Exempt

Lead with Data. Influence with Insight. Elevate the Team.

FEDPOINT is seeking a skilled and collaborative Data Analyst to join our Business Systems Support (BSS) team. This role is ideal for a technically strong analyst who thrives on solving complex data challenges, partnering with business and IT stakeholders, and mentoring others to elevate team performance.

This is a hybrid position requiring two days per week onsite in our Portsmouth, NH office, balancing flexibility with meaningful in-person collaboration.

About The Role

The Data Analyst plays a critical role in maintaining data integrity, strengthening system controls, and delivering actionable business insights. You will design and execute complex data updates, investigate system behaviors, build operational reporting, and lead analytical problem-solving efforts.

Beyond technical expertise, this role serves as a team champion, supporting junior analysts through mentorship, peer review, and knowledge sharing.

What You’ll Do

Data Repair & Quality Assurance

Perform moderate to complex data repairs across staging and production environments using structured SQL
Conduct root cause analysis on data anomalies and recommend preventative solutions
Lead end-to-end testing in mirror environments, validating outputs and scanning for unintended impacts
Conduct peer reviews of data fixes to ensure quality and compliance with team standards

Controls & Analytical Ownership

Own execution and analysis of control reports (DDD), identifying trends and recurring issues
Develop and refine SQL syntax to address systemic root causes
Evaluate and enhance existing data controls to improve monitoring accuracy and efficiency
Partner with leadership to maintain operational dashboards and performance reporting

Business Issue Triage & System Analysis

Independently investigate business-reported issues and assess system behavior in coordination with IT
Log and document defects and change requests with detailed current and future state analysis
Support system build validation and confirm scope of technical issues

Reporting & Business Insights

Design and maintain operational reports using SQL, SSRS, and Excel
Translate business requirements into scalable, maintainable reporting solutions
Partner with business units to interpret results, identify trends, and drive data-informed decisions

Cross-Functional Initiatives

Participate in new program rollouts, campaign preparation, and systems testing efforts
Lead workflow improvement initiatives and refine data correction procedures
Support seasonal programs such as Open Season with data pulls, rate table updates, and validation processes

Team Leadership & Knowledge Sharing

Mentor junior analysts and assist with onboarding
Facilitate knowledge-sharing discussions and mini-training sessions
Maintain and enhance shared documentation and reference materials
Contribute to a collaborative, high-performance team culture

What You Bring

Education & Experience

Bachelor’s degree or equivalent experience in business or systems analysis
3+ years gathering and documenting business requirements
2+ years developing and executing moderate to high complexity SQL queries
2+ years developing and executing data update scripts with full testing and validation
Experience with KPIs and business performance reporting
Experience coaching or training team members
Insurance or benefit administration experience preferred

Technical & Professional Strengths

Strong working knowledge of relational databases and reporting tools (SSRS, Oracle, Webfocus, TOAD, Access)
Ability to identify risks, assess trade-offs, and recommend practical solutions
Strong facilitation and stakeholder communication skills
High attention to detail and excellent prioritization skills
Ability to work independently while fostering collaboration
Customer-focused mindset with sound business judgment
Flexibility to shift priorities as business needs evolve

Your Impact Within The Team

The BSS team serves as the critical link between business stakeholders and IT, delivering cost-effective, high-quality system solutions. We act as business consultants while maintaining strong technical rigor in data controls, reporting, and systems integrity.

This role offers the opportunity to influence operational excellence, mentor others, and drive meaningful system improvements in a collaborative, forward-thinking environment.

Location: Portsmouth, NH

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

Compensation: The typical starting salary is between $73,000 and $85,882/year based on qualifications and experience as it relates to requirements listed for this role. This position is eligible for an annual employee bonus plan based on company metric performance as well as a full suite of benefits, listed below.

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. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, or protected veteran status and will not be discriminated against on the basis of disability. 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

FedPoint jobs

UX Research and Data Analyst Intern

Customer Service Call Center Representative

Data Analyst

Claims Processor