Data Analyst-locals

Data Analyst with strong SQL

Must be willing to convert perm after 3 months.

Must have Strong Data background

Must Have Insurance Experience – Really Wants Property & Casualty

Title: Data Analyst

Location: 695 Atlantic Ave Boston, MA

Location Details: MUST work onsite 4 days a week. Office is located across the street from South Station. PTO doesn’t count towards the 1 day remote and they offer flex for illnesses. Must be onsite between 9am-3pm, but open to a start between 7am-9am and an end between 3pm-5pm.

Team: Data Warehouse | Data Services

Team Size: 4 ETL Developers + 5 Data Analysts

Start: asap in 2024

Duration: 3 months to hire

Subvending Allowed? YES – the manager wants to convert the resource to a perm employee in the future and will sponsor if the consultant is on a visa. Please obtain a 3 month release from the vendor. Our conversion terms with the client are 3 months, no fee

Important Skills

Technical – SQL, data mining, analyze requirements

Soft – excellent comm skills – able to command a room and not be meek and quiet. Also not a seasoned 30 yr data candidate – would prefer to see someone more junior than close to retirement for succession planning

Interview Process: 30 min with Director, meet ETL Manager + Data Analyst Manager onsite

Background Check + Drug Test (if applicable):

Must Haves

• SQL skills
• Mine data
• Strong SQL skills
• Analyze requirements
• P+C industry exp
  
  

Plus

Cloud environment like AWS

Day To Day

This team supports the regulatory insurance team and supplies data to state departments like the DMV on how and when they write insurance policies. They also report on losses of data and types of policies written. This data goes into a shared data source, and the company has approximately 2,000 submissions on a yearly basis. All of this is done in ETL. There is a datamart around previous year’s insurance data that can be audited, analyzed and edited over the previous 3 years. The company has ramifications, and is possibly fined, if the data is late or wrong, and each state has their own rules around these policies and data reporting.

The Data Analysts will be responsible for mining data, analyzing requirements, writing SQL queries, and some technical investigation. There is lots of QA work for their 2,000 submissions which requires the DAs to multi-task, create test plans, and analyze test conditions. They partner with the ETL Developer team and QA teams to get the data deployed out into the environment. The environment is on prem as of today and is hosted in their data center. The 5 year goal is to migrate these platforms and data to the cloud.