Senior Data Engineer (ETL)

The Hartford



Wayne, PA


Position summary

You are a driven and motivated problem solver ready to pursue meaningful work. You strive to make an impact every day & not only at work, but in your personal life and community too. If that sounds like you, then you've landed in the right place.

The Senior Data Engineer (ETL) will be responsible for the analysis, design, and development of a highly efficient, highly scalable ETL process to address Hartford Funds’ data movement needs. This senior resource will draw on their past experience and ability to think big-picture to create the most optimal solution to meet the business requirements. The resource will be a team player and will use their strong communications skills in everyday interaction with business analysts, the Business Intelligence team, and the project manager.  The resource will be responsible for hands-on development as well as troubleshooting and will also provide ETL mentorship and feedback to other ETL developers, as needed.

This position requires at least 5 years of proven ETL experience with an enterprise-grade ETL tool (eg.  Informatica, SSIS, Talend, Matillion, Pentaho).

*This position will adhere to Hartford Funds’ hybrid work model, in which employees are expected to work in our Wayne, PA office location 3 days per week (Tuesdays, Wednesdays and Thursdays).  Employees have the option of working remotely on Mondays and Fridays if they choose.


  • Conduct data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
  • Provide business and technical analysis for initiatives focusing on Data Warehouse and Business Intelligence solutions
  • Influence and provide input on data warehouse design with (experienced based) recommendations for optimal structuring of data to support efficient processing
  • Develop detailed technical specifications and ETL documentation in collaboration with data warehouse architect and Business Intelligence developers
  • Lead developers (both onshore and offshore) to ensure efficient delivery of quality solution
  • Provide mentorship to ETL developers
  • Perform peer reviews and provide feedback on ETL design and implementation
  • Design and develop ETL code, ETL audit control and scheduling processes
  • Develop testing strategy and conduct appropriate testing to identify and resolve data quality issues
  • Collaborate with Business Intelligence Developers through dashboard and application development process for requirements gathering, feedback on proposed designs and models, and acceptance testing
  • Build custom? Complex? Advanced? solutions independently, sometimes without documented/concrete requirements to work from or specific guidance from other developers


  • 5 years’ experience, with both hands-on and lead experience in supporting data warehousing solutions
  • This position requires at least 5 years of proven ETL experience with an enterprise-grade ETL tool (eg.  Informatica, SSIS, Talend, Matillion, Pentaho)
  • Bachelor's degree in computer science, information technology or another computer-based discipline
  • Must possess the following technical skills:
    • ETL Tools: Enterprise class ETL tool (Talend is plus)
    • Databases & Utilities: Experience with enterprise relational databases (Snowflake experience preferred)
    • Platforms: Microsoft / Unix
  • Expertise and fluency in SQL language is required
  • Knowledge of scripting languages and job schedulers is required (Powershell, etc.)
  • Experience with various integration patterns (https://e.g., Flat Files, Web Services, etc. is required
  • Knowledge of fundamental data modeling concepts (https://e.g., ER Diagrams, normalization, etc.) is required
  • Knowledge of data warehousing techniques (dimensional modeling / star schema, etc.) is required
  • Experience writing technical documentation is required
  • Must be comfortable/excited working in a fast-paced, high impact environment, with
  • Excellent troubleshooting and problem-solving skills; able to root cause and debug complex code in and efficient manner/with appropriate urgency
  • Ability to obtain a good understanding of the business context of a problem in order to ensure the solution is optimal in solving the business need


  • Familiarity with Python is a plus
  • XML/XSLT experience is a plus
  • Snowflake / Talend
  • Cloud platform experience (AWS/Azure)


The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford’s total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is:

$120,000 - $150,000

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us | Culture & Employee Insights | Diversity, Equity and Inclusion | Benefits

Application Dev Consultant - 87ID5E

Why you should apply for a job to The Hartford:

  • 4.5/5 in supportive management

  • 77% say women are treated fairly and equally to men

  • 88% would recommend this company to other women

  • 95% say the CEO supports gender diversity

  • Ratings are based on anonymous reviews by Fairygodboss members.
  • The Professional Women’s Network (PWN) provides professional support, growth, advancement and networking to enable greater gender balance.

  • The Hartford offers diversity awareness training known as Appreciating Differences and Managing Inclusion.

  • Employees will be provided with leave of up to four weeks and paid at a rate of 100 percent of their base pay.