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 FedPoint FedPoint creates and operates digital benefits marketplaces that make it easy for our 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. 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 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 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 Location: Portsmouth, NH 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 parantal 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. #J-18808-Ljbffr