What are the responsibilities and job description for the Data Analyst position at FedPoint?
Lead with Data. Influence with Insight. Elevate the Team.
FEDPOINT is seeking a skilled and collaborative Data Analyst to join our FEDVIP Business Analysis and Quality Assurance 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
Education & Experience
Schedule: Hybrid 2 days in the office, with up to 3 days telework - Monday-Friday
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?
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 is seeking a skilled and collaborative Data Analyst to join our FEDVIP Business Analysis and Quality Assurance 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
- 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
- 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
- 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
- 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
- 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
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
- 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
Schedule: Hybrid 2 days in the office, with up to 3 days telework - Monday-Friday
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.
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