Associate Data Analyst
FedPoint is seeking a detail-oriented, technically curious Associate Data Analyst to join their Business Systems Support team. This role involves maintaining data health across business systems, executing data controls, performing quality assurance checks, and supporting reporting needs.
Responsibilities
- 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
- 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
- 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
- Run approved queries for recurring and ad hoc reports
- Validate report accuracy and completeness
- Maintain documentation of reporting logic and delivery methods
- 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
- Receive mentorship and coaching from experienced analysts
- Enhance technical knowledge of systems and tools
- Actively seek feedback and contribute to continuous improvement efforts
Skills
- 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 (Visio or Access a plus)
- 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
- Familiarity with reporting tools such as SSRS, Oracle, Webfocus, TOAD, or Access
- Understanding of KPIs and business reporting metrics
Benefits
- 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.
- 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.
Company Overview
- FedPoint is to build and administrate long-term care insurance programs for the federal family. It was founded in 2002, and is headquartered in Portsmouth, New Hampshire, USA, with a workforce of 201-500 employees. Its website is