Data Engineer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Agile, is seeking the following. Apply via Dice today! 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.