Senior ETL Developer

Application Dev Consultant - 87ID5E

We're determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals - and to help others accomplish theirs, too. Join our team as we help shape the future.

As Hartford Funds continues to leverage offshore data engineering talent to optimize costs and scale delivery, it is critical to establish a Senior ETL Developer role to ensure technical excellence, operational efficiency, and adherence to corporate standards. This role will be hands-on, directly contributing to development while also collaborating with offshore resources to ensure standards.

This role requires a strong foundation in SQL, ETL processes, and cloud data platforms, along with a proactive mindset for identifying and resolving data bottlenecks and inefficiencies.

Responsibilities:

• Project Execution
  • The senior ETL developer should be able to translate business requirements into technical specifications.
  • Ensure timely and high-quality execution of data projects.
  • Design, build, and maintain scalable data pipelines and ETL processes.
  • Develop and optimize data models for analytics and reporting.
  • Stay current with emerging technologies and recommend adoption where appropriate.
  • Conduct code reviews, enforce best practices, and ensure adherence to corporate standards.
• Collaboration & Advisory
  • Partner with data operation engineer, system analysts, and data architect to design scalable data solutions.
  • Provide guidance on best practices for data architecture, storage, and processing.
  • Contribute to documentation, standards, and knowledge sharing across the team.

• Bachelor's or master's degree in computer science, Data Engineering, or related field
• 5+ years of experience in ETL development
• Experience managing offshore or distributed teams is strongly preferred
• Strong proficiency in SQL and experience with ETL/ELT tools (e.g., DBT, Talend, Matillion, Informatica, custom Python scripts)
• Hands-on experience with cloud data platforms (e.g., Snowflake, Azure Synapse, Redshift)
• Knowledge of CI/CD practices and version control (e.g., Git)
• Strong understanding of ETL/ELT processes, data warehousing, and data modeling
• Strong problem-solving skills and a proactive approach to identifying and resolving issues
• Excellent communication skills to manage cross-functional and cross-cultural teams

• Knowledge of Python or other scripting languages for automation
• Familiarity with monitoring tools
• Experience working in Agile or DevOps environments