Senior Data Warehouse Analyst - P&C, Snowflake & ETL

Plymouth Rock Assurance; Port Reading (NJ); On-site; USD 105,000 - 136,000; Full time

Benefits offered by this job

4 weeks accrued paid time off

Tuition Reimbursement

Health insurance options starting on Day 1

Robust health and wellness program

401(k) Employer Contribution

Paid Family leave options

Job summary

Plymouth Rock Assurance is seeking a Senior Data Analyst in Port Reading, New Jersey. The candidate will manage data warehouse projects, requiring over 10 years of experience in software development and data analysis. Responsibilities include project management, data modeling, and supporting users. A Bachelor's degree in Computer Science is required, along with expertise in SQL and AWS cloud applications. Benefits include paid time off, health insurance, and professional development resources.

Qualifications

• 10+ years of software development experience, ideally in SQL.
• 10+ years of Data Analyst experience.
• Experience in relational databases.

Responsibilities

• Internal management of projects throughout the project life cycle.
• Analysis and clarification of Business Requirements.
• Support users and the Data Warehouse team.

Skills

Data modeling

SQL

ETL tools

Data mapping and transformation

Project management

Performance tuning

Education

Bachelor’s degree in Computer Science or equivalent

Tools

Snowflake

Informatica

AWS

SQL Server

Oracle

Job description

Plymouth Rock Assurance is seeking a Senior Data Analyst in Port Reading, New Jersey. The candidate will manage data warehouse projects, requiring over 10 years of experience in software development and data analysis. Responsibilities include project management, data modeling, and supporting users. A Bachelor's degree in Computer Science is required, along with expertise in SQL and AWS cloud applications. Benefits include paid time off, health insurance, and professional development resources.