Data Warehouse Consultant

Title:- Data Warehouse Consultant
Location: Woodbridge, NJ
12 months

Must be local and available to interview in person

Goal of the project: One key initiative that will be in the near future for this role is participation of migrating and modernizing the current day Data Warehouse: migrating it to AWS within Snowflake/ Redshift.
Need someone with:
Strong testing skills (this is not a QA)
SQL query
PYTHON (able to read, write and troubleshoot)
Migrating to Snowflake/RedShift, so knowledge and experience in this area is desired
P+C exp would be IDEAL
Knowledge of Informatica or similar ETL tools to assist with researching the code

Personality- needs someone strong voice, pro-active, and some skills around automation, SQL and Snowflake

Data Warehouse Data Analyst

The Senior Data Analyst position will be responsible for the management, design, testing and implementation of Data Warehouse projects for Policy, Claims, Quotes, Billing, Agency, ancillary components and Data Mart insurance application data.

Primary duties will include requirements review, estimating, analysis, data modeling, development of technical specification documents, development team support and guidance, significant quality assurance, implementation tracking, downstream application support and monitoring of data in production databases.

This role also requires the ability to internally manage the project from Analysis through Post-Implementation phases. One key initiative that will be in the near future for this role is participation of migrating and modernizing the current day Data Warehouse; migrating it to AWS within Snowflake/RedShift, so knowledge and experience in this area is desired

Skills/Knowledge
Bachelor s degree in Computer Science (or equivalent experience), with 7+ years of software development experience (ideally SQL)
7+ years of Data Analyst Experience
Experience in relational databases
Experience in data mapping and transformations
Experience using a software development life cycle (SDLC) methodology, including project planning and estimating. Experience with Jira.
Experience with AWS components in the cloud (ie. S3, Sagemaker, Python, etc)
Experience with Snowflake/RedShirt Data platform(s)
Experience AIX/DB2 & Windows/Sql Server
Experience with Effective oral & written communication skills must have the ability to be heard
Strong data modeling skills
Analytical Skills
Significant quality assurance skillset
Project Management skills
Ability to multi-task and be self-motivated
Attention to detail and quality
Must be a team player and contribute to the overall synergy in the team
Specific responsibilities include:
Internal management of projects throughout the project life cycle.
Analysis and clarification of Business Requirements
Develop system specifications, including data transformations, using Software Development Life Cycle (SDLC) methodologies and templates.
Unit testing and involvement in integration, user and performance testing as well as support of downstream IT and business applications utilizing the Data Warehouse data.
Data Modeling
Directing/Partnering with development
Strong relationships with key Data Warehouse business and IT users
Supporting users and members of the Data Warehouse team with direction and mentoring
Performance tuning
Working independently on both assigned tasks as well as have the initiatives to identify and complete needed tasks without being specifically assigned.
Proactive approach to all work and the initiative to jump in to assist wherever needed
Ability to prioritize with little assistance.
Strong Problem Solving skills
Ability to learn new data sources and patterns quickly
Ability to take on a very large project solely if warranted
Be an expert in data analyst tasks and continue to seek out areas that need improvement
Other highly valued skills would include:
Knowledge of the Property and Casualty Insurance industry is desired
Knowledge of the full life cycle of a Policy and Claim within the P&C world
Knowledge of Data Warehousing Methodologies including Snowflake & AWS S3. Cloud
Knowledge of Informatica or similar ETL tools to assist with researching the code