Data Engineer

  • Andover, MA
  • Posted 4 days ago | Updated 2 days ago

Overview

Hybrid
Up to $155,000
Full Time
No Travel Required

Skills

ETL
data integration
data pipelines
data warehousing
SQL
SSIS
Informatica
Talend
Apache NiFi
T-SQL
Microsoft SQL Server
data modeling
data quality
data transformation
business intelligence
data architecture
performance tuning
troubleshooting
data engineer
Snowflake
Power BI
Tableau
Apache Airflow
Apache Spark

Job Details

Location: Andover, Massachusetts (On-site with the possibility of up to 5 remote days per month)

Job Type: Contract-to-Hire

Pay: Up to $87/hour W-2 or up to $97/hour IC/1099. The conversion salary is up to $155k per year.

Benefits:

  • During the contract phase, benefits include medical, dental, vision, LTD/STD, HSA/FSA, term life, and supplemental health insurances (e.g., Aflac) for all employees (and their families if needed).
  • Upon conversion to a permanent employee, the company pays 100% of employee health benefits, and employees receive PTO and 401(k).

Summary of the Role:

A technical, hands-on Data Engineer is needed to design, develop, and maintain modern ETL pipelines. This is a "builder" role that requires the ability to create robust data pipelines from the ground up, with a focus on sourcing, transforming, and delivering data to targets like AWS Redshift. The ideal candidate will be an expert in the Informatica Data Management Cloud (IDMC) platform and will be responsible for building reusable, version-controlled integration components and optimizing existing workflows.

Responsibilities:

  • Design, develop, and maintain modern data pipelines on the Informatica Data Management Cloud (IDMC) platform.
  • Implement complex, reusable IDMC integration pipelines using modules like Mass Ingestion, Application Ingestion, and API-based integration.
  • Develop high-quality ETL pipelines to source, transform, and deliver data into AWS Redshift and other targets.
  • Write and manage reusable, version-controlled integration components.
  • Optimize and refactor mappings and workflows for performance and efficiency.
  • Perform root cause analysis on failed jobs and provide production support.
  • Participate in code reviews and technical design discussions.
  • Support data lifecycle management and deployment pipelines.
  • Collaborate with the Data Services team to ensure integrated and reliable data solutions.

Required Experience:

  • Minimum of 5+ years of data or ETL experience.
  • Expertise in Informatica Data Management Cloud (IDMC).
  • Strong proficiency in solutions design.
  • Strong SQL and AWS Redshift familiarity.
  • Expertise in engineering, optimizing, and troubleshooting ETL solutions.
  • Experience with DevOps tools like Git and CI/CD.
  • Strong problem-solving, critical thinking, and debugging skills.

Preferred Skills:

  • An insurance industry background is highly desirable.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Agile