Data Engineer

Global insurance firm located in Springfield, MA has an immediate contract opportunity for a Data Engineer.

Find out exactly what skills, experience, and qualifications you will need to succeed in this role before applying below.

• 6+ month contract
• If not local, must be open to relocation

This role is currently work-from-home and will move to the office environment after the COVID-19 restrictions are lifted.

Design, build, and measure complex ELT jobs to process disparate data sources and form a high integrity, high quality, clean data asset.

Executes and provides feedback for data modeling policies, procedure, processes, and standards.

Assists with capturing and documenting system flow and other pertinent technical information about data, database design, and systems.

Develop data quality standards and tools for ensuring accuracy.

Work across departments to understand new data patterns.

Translate high-level business requirements into technical specs.

Required skills :

5+ years of experience with data analytics, data modeling, and database design.

3+ years of coding and scripting (Python, Java, Scala) and design experience.

3+ years of experience with Spark framework.

Experience with ELT methodologies and tools.

Experience with Vertica

Expertise in tuning and troubleshooting SQL.

Advanced level experience with SQL

Strong data integrity, analytical and multitasking skills.

Excellent communication, problem solving, organizational and analytical skills.

Able to work independently.

Additional / preferred skills :

Familiar with agile project delivery process.

Knowledge of SQL and use in data access and analysis.

Experience with Airflow.

Ability to manage diverse projects impacting multiple roles and processes.

Able to troubleshoot problem areas and identify data gaps and issues.

Ability to adapt to fast changing environment.

Experience with Python.

Basic knowledge of database technologies (Vertica, Redshift, etc.).

Experience designing and implementing automated ETL processes.