Sql data analyst Jobs in Worcester, MA

Data Analyst

Key Responsibilities

Analyze, design, test, and implement data changes for regulatory and compliance submissions, including premium / loss reports, special audits, and market conduct exams.

Review and clarify business requirements, provide work effort estimates, and develop detailed functional and system specifications using SDLC methodologies.

Create accurate data mapping and transformation specifications to support regulatory reporting and discretionary projects.

Develop and execute comprehensive test plans, test cases, and perform unit, integration, user, and performance testing to ensure data accuracy and compliance.

Collaborate with development teams to support all SDLC phases, including query optimization and use case development.

Oversee assigned submissions and reports, ensuring timely delivery, accurate balancing, and resolution of internal / external inquiries.

Support audits, market conduct exams, and production validation processes with thorough documentation and tracking.

Evolve into a lead role, managing projects, resources, and driving team efforts to meet compliance objectives.

Required Skills and Qualifications

Data Analysis and Reporting (50%)

5-8 years of software development experience with a Bachelor’s degree in Computer Science or equivalent experience.

Strong expertise in querying relational databases (e.g., DB2, SQL Server) and writing SQL queries for analysis, testing, and developer support.

Proficiency in data mapping, transformation, and structured analysis to support regulatory reporting requirements.

Experience using SDLC methodologies, including project planning, estimation, and documentation.

Leadership and Collaboration (50%)

Ability to lead, direct, and motivate team members while managing multiple concurrent projects.

Strong organizational, analytical, and technical skills with a focus on attention to detail and quality.

Effective oral and written communication skills to collaborate with internal / external partners and build strong relationships.

Ability to work independently with minimal direction and drive efforts to meet project deadlines.

Additional Considerations

Knowledge of the Property & Casualty (P&C) insurance industry and statutory / compliance-related reporting is a plus.

Prior supervisory experience and proficiency with MS Office suite are highly valued.

Exposure to cloud technologies (e.g., AWS) and experience with DB2 or SQL Server databases are advantageous.

The ability to think innovatively and propose improvements to existing processes is highly desired.

Candidates must be local to Boston to facilitate collaboration and occasional on-site work.

Why Join Us?

This role offers an opportunity to lead critical regulatory and compliance initiatives within a dynamic team. You’ll evolve into a leadership position, work with cutting-edge data technologies, and collaborate with a forward-thinking group dedicated to delivering high-quality, compliant solutions that drive our company’s success in the regulatory landscape.

What is a Pipeline Job?

These roles represent future opportunities we've uncovered through our client discussions. We have stripped away the rigid “Must Haves,” “Mandatories,” and “Required” criteria to find the right fit for their needs. By applying for these future roles, we will complete our human-centered process to see if you are a fit while adding your profile to our database to be considered for additional openings. When you apply, rest assured a human will thoroughly review your resume and respond to you personally. We take pride in finding the right match for each job, valuing your unique talents and potential over just what's on your resume.