firstPRO is now accepting resumes for a Senior Data Analyst role in Woodbridge, NJ. This is a 6+month contract to hire and onsite 4 days per week.
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. This role will report to the Data Warehouse Manager, but on some projects may report directly to the Director.
Knowledge, Skills and Education Required
- 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
Duties and Responsibilities
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.
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
