Lead Data Analyst with Insurance domain

SharpAtoms; Port Reading (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

SharpAtoms seeks a Lead Data Analyst to join the Data Warehouse team in Woodbridge, NJ. The role focuses on implementing a brand-new policy administration system, requiring P&C and Policy Admin experience, SQL testing, and collaboration with developers and users.

Ideal candidate has 5–8 years of software development and strong data analysis skills, with the ability to lead and manage multiple projects in a fast-paced environment.

Qualifications

• Bachelor’s degree in Computer Science (or equivalent experience) with 5–8 years of software development experience.
• Experience in querying relational databases.
• Experience in data mapping and transformation.
• Knowledge of structured analysis.
• Experience with SDLC methodologies including project planning and estimating.
• Experience with SQL and creating queries for analysis and testing; assist developers with queries.
• Excellent written and verbal communication skills.
• Strong organizational skills.
• Strong analytical and technical skills.
• Ability to work with minimal direction.
• Ability to lead, direct, and drive efforts of other team members.
• Ability to work on multiple concurrent projects.
• Ability to collaborate with internal and external partners.
• Attention to detail and quality.
• Strong motivational skills.

Responsibilities

• Analyze and clarify business requirements (internal and external).
• Provide work effort estimates to Project Managers.
• Develop detailed functional and system specifications using SDLC methodologies.
• Collaborate with Development team across all SDLC phases.
• Develop use cases.
• Support design, testing, and monitoring of changes for compliance-related reporting and discretionary projects.
• Create data and transformation mapping specifications.
• Develop test plans/cases and execute thorough testing.
• Participate in unit, integration, user, and performance testing.
• Manage requirements and testing accounts with business and IT partners.
• Support audits and market conduct exams as needed.

Skills

SQL querying

Data mapping

Transformation

SDLC knowledge

Project planning

Communication skills

Analytical skills

Team leadership

Multitasking

Collaboration

Attention to detail

Motivational skills

Education

Bachelor’s degree in Computer Science

Tools

MS Office

DB2

SQL Server

Cloud technologies

Job description

• Position is part of the Data Warehouse team that sits onsite in Woodbridge, NJ
• Need P& C exp and Policy Admin exp
• Will be responsible for implementing a brand-new policy administration
• Policy Administration knowledge
• Will require testing as well and SQL experience as candidate will be helping users with SQL.

Lead Data Analyst

Immediate need for a Senior/Lead Data Analyst position.

Knowledge, Skills and Education Required

• Bachelor’s degree in Computer Science (or equivalent experience), with 5-8 years of software development experience
• Experience in querying relational databases
• Experience in data mapping and transformation
• Knowledge of structured analysis
• Experience in using a software development life cycle (SDLC) methodology, including project planning and estimating
• Experience with SQL with ability to create SQL queries for analysis and testing as well as assist developers in creating queries
• Effective oral and written communication skills
• Strong organizational skills
• Strong analytical skills and technical skills
• Ability to work with minimal direction
• Ability to lead, direct, and drive efforts of other team members
• Ability to work on multiple, concurrent projects
• Ability to effectively collaborate and build strong relationships with internal and external partners
• Attention to detail and quality
• Strong motivational skills

Duties and Responsibilities

Specific responsibilities include:

• Analysis and clarification of business requirements both internal and external
• Provision of work effort estimates to Project Managers
• Development of detailed functional and system specifications using Software Development Life Cycle (SDLC) methodologies and software tools.
• Collaboration with the Development team in all phases of the SDLC
• Development of use cases
• Design support, testing and monitoring of all required changes needed to maintain all compliance-related reporting and discretionary projects
• Creation of data and transformation mapping specifications
• Development of test plans and test cases, and execution of accurate and thorough testing
• Involvement in unit, integration, user and performance testing.
• Management of requirement and testing accountabilities through working closely with business and IT partners
• Support of audits and market conduct exams as needed

Other highly valued skills include:

• Knowledge of the Property and Casualty Insurance industry desired
• Prior experience with statutory and compliance-related reporting a plus
• Proficiency with MS Office suite
• Exposure to DB2 and SQL Server databases
• Exposure to Cloud technologies
• Ability to think outside of the box and a strong desire to improve the status