Responsible for the development of ETL solutions with a strong understanding of ETL concepts and the ability to apply those concepts broadly across multiple technologies. The ability to work with business users to help integrate data from multiple sources and technologies and make that data available for use in reporting and system integration.

Essential Functions:

  • Maintain existing ETL solutions while looking for opportunities to improve them
  • Ability to translate business requirements into actual solutions while maintaining a high level of accuracy and data integrity
  • Strong ability to translate business requirements into technical terms for other team members
  • Collaborate with other team members to consolidate the data landscape to reduce the development time and increase consistency among ETL solutions
  • Lead complex projects and ensure their complete and accurate execution with emphasis on delivering business value
  • Train and coach less experienced staff members in ETL best practices

Knowledge & Skills:

  • 10+ Years of experience using ETL Tools
  • 5+ Years SSIS experience
  • 10+ Years of strong experience troubleshooting stored procedures and other TSQL code
  • .Net programming in C# development experience
  • Objectivity and openness to others views, providing solutions and creative input
  • Provides and welcomes feedback
  • Must be able to adjust when there is a shift in priorities
  • Excellent communicator with individuals and groups at all levels
  • Detail oriented, organized and able to manage user expectations
  • Good organizational, time management, and listening skills
  • Self-motivated
  • Understanding of ETL concepts and ability to apply those concepts to multiple technologies

Training & Experience:

  • Experience working with SSIS
  • Other ETL experience (Informatica, Talend, C#)
  • Microsoft SQL server 2008 R2 or later
  • Bachelor’s degree or equivalent experience
  • Strong analytical skills