Data Analyst
Selective Insurance Group Inc
Contract Branchville, New Jersey, United States Posted 8 months ago
About Position
Data Analyst (Contract)
$70.00 / Hourly
Branchville, New Jersey, United States
Data Analyst
Contract Branchville, New Jersey, United States Posted 8 months ago
Skills
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 teamDescription
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 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.
Responsibilities
- 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
Educational Requirements
- Knowledge of Data Warehousing Methodologies including Snowflake & AWS S3. Cloud
- Knowledge of Informatica or similar ETL tools to assist with researching the code
By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.
