Drag

Data Analyst

Location : ,

Job Description

Data Analyst

 

This role is going to focus on data testing, data validation, SQL and Python query writing, data analysis. There will be an element of ETL in this role, but it is NOT an ETL role.

 

Job Summary

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

 

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.
  • 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
  • Knowledge of the Property and Casualty Insurance industry
  • 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