IMS / DB2 Architect

Job Title : IMS / DB2 Architect

Location : Boston, MA (Onsite 4 days / week Local or Nearby Only)

Experience Level : 13+ Years

Interview : In-Person (F2F) Required

Job Description :

We are seeking a highly experienced Lead Data Analyst with strong expertise in Property & Casualty (P&C) Insurance, SQL, ETL, and data modeling. This is a senior role that requires someone confident, energetic, and capable of mentoring junior analysts while leading complex data initiatives. The ideal candidate will have deep hands-on experience in analyzing regulatory and compliance reporting requirements, designing data specifications, performing data testing, understanding new data sources, and supporting enterprise data operations. This role will evolve into a leadership position overseeing projects, deliverables, and team members.

Key Responsibilities :

• Analyze, review, and clarify business and regulatory requirements for compliance and discretionary projects.
• Lead data analysis, data mapping, transformation logic, and technical specification creation.
• Support developers with SQL queries, testing, and validation of data changes.
• Perform detailed test planning, test case creation, and execution across unit, integration, user, and performance testing.
• Investigate and understand new data sources, link and model tables, flatten structures, and perform end-to-end data validation.
• Manage assigned submissions and reports, ensuring accuracy, balancing, and timely delivery.
• Provide oversight of projects and junior team members as the role scales into leadership.
• Collaborate with business partners, IT teams, and external stakeholders to support audits, compliance, and market conduct needs.
• Support implementation tracking, production validation, and issue resolution.
• Contribute to SDLC processes, project planning, estimation, and cross-functional coordination.

Required Skills & Experience :

Highly Valued / Preferred Skills :