Actuarial Skills, Analysis Skills, Business Analysis, Business Development, Communication Skills, Consulting, Data Analysis, Data Structures, Data Warehousing, Documentation, Functional Requirements Document (FRD), Insurance, Metrics, Microsoft SQL Server, Microsoft Visual Basic for Applications (VBA), Product Requirements Document (PRD), Quality Assurance, Reinsurance, Reporting Skills, Requirements Management, SQL (Structured Query Language), Testing, User Documentation, Validation Testing
Lead Consultant Analytics Solutions (SQL Server Analytics)
Location: Farmington, CT 06030
Duration: 12 Months Contract
Target Start Date: June 23, 2026
Interview Process: Face-to-Face Interview Required
Position Overview
We are seeking an experienced Lead Consultant with strong expertise in Analytics, SQL Server, and actuarial reporting to support the modernization of reporting processes within a Segment Data Warehouse environment. The ideal candidate will work closely with business stakeholders and development teams to analyze existing actuarial reports, document requirements, and guide the transition from legacy Excel and SQL-based reporting solutions to scalable enterprise data warehouse solutions.
Key Responsibilities
- Analyze existing actuarial reports and measures, primarily developed using Excel and SQL.
- Collaborate with business stakeholders to understand report logic, calculations, and data dependencies.
- Translate business and actuarial reporting requirements into technical specifications for development teams.
- Provide clarification on complex calculations, methodologies, and underlying data structures.
- Develop business requirements documentation, functional specifications, and acceptance criteria when required.
- Support and guide developers in implementing reporting solutions within the Segment Data Warehouse.
- Perform Quality Assurance (QA) testing to validate that newly developed reports and metrics meet business requirements.
- Identify opportunities to improve reporting accuracy, efficiency, and scalability.
Required Skills & Experience
- 10+ years of experience in Data Analytics, Reporting, or Business Analysis.
- Strong expertise in SQL and SQL Server-based analytics solutions.
- Experience analyzing and documenting complex reporting processes and business calculations.
- Ability to communicate effectively with both business users and technical teams.
- Experience creating requirements documentation, user stories, and acceptance criteria.
- Strong analytical and problem-solving skills.
- Hands-on experience performing QA and validation testing.
Preferred Qualifications
- Experience in the Insurance or Reinsurance industry.
- Knowledge of actuarial reserving and actuarial reporting processes.
- Experience with Excel-based reporting solutions and report migration initiatives.
- VBA development experience.
- Familiarity with enterprise data warehouse environments and reporting modernization projects.
Top 3 Responsibilities
- Analyze existing Excel and SQL-based actuarial reports and guide their migration to the Segment Data Warehouse.
- Clarify business calculations, reporting logic, and underlying data requirements.
- Create requirements documentation, acceptance criteria, and perform QA testing to ensure reporting accuracy and compliance.
Nice-to-Have Skills
- SQL
- VBA
- Insurance/Reinsurance Domain Knowledge
- Actuarial Reporting Experience