Lead Data Analyst

ZealHire Inc.; Port Reading (NJ); On-site; USD 95,000 - 130,000; Full time

Job summary

ZealHire Inc. in Woodbridge, NJ, seeks a Senior/Lead Data Analyst to implement a brand-new policy administration system and drive data quality efforts. 4 days/week onsite; strong P&C policy administration and SQL/Snowflake skills required.

The role includes defect tracking, testing, and collaborating with IT and business stakeholders to ensure successful delivery and regulatory compliance.

Qualifications

• Bachelor’s degree in Computer Science or equivalent with 5-8 years software development experience.
• Experience querying relational databases.
• Data mapping and data transformation experience.
• Knowledge of structured analysis.
• SDLC methodology experience including planning and estimating.
• Proficient SQL for analysis and testing; assist developers with queries.
• Strong written and oral communication skills.
• Excellent organizational and analytical abilities.
• Ability to work with minimal direction and lead others.
• Ability to manage multiple concurrent projects and collaborate effectively.
• Experience with internal/external partner relationships and quality focus.

Responsibilities

• Analyze business requirements and provide effort estimates.
• Develop functional and system specifications using SDLC.
• Collaborate with development teams across SDLC phases.
• Develop use cases and support design, testing, and monitoring of changes.
• Create data transformation mappings and test plans; execute tests.
• Support audits and exams as needed; assist in defect tracking and resolution.

Skills

Leadership

SQL

Data mapping

Data transformation

SDLC

Relational databases

Communication

Organization

Analytical skills

Self-motivation

Multitasking

Collaboration

Attention to detail

Team player

Motivation

Education

Bachelor’s degree in Computer Science

Tools

SQL Server

Snowflake

Job description

Woodbridge, NJ – 4 days/week onsite Need locals

F2F interview is required

Need P& C exp and Policy Admin exp
Candidate needs to have excellent communication skills

• Will be responsible for implementing a brand-new policy administration


• Policy Administration knowledge - new systems - fix the bad data - what came in today whats the balance who is going to get the defect and track it to completion


• Log in defect tracking tool. Will require testing as well and SQL exp as candidate will be helping users with SQL.Knowledge of Snowflake ++

Immediate need for a Senior/LeadData 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 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


• Team player


• Strong motivational skills

Duties and Responsibilities

• 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


• Prior Supervisory experience


• 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 quo

$000,000 – $000,000 Salary range is not shown on the candidate portal