This site uses cookies. To find out more, see our Cookies Policy
Skip to navigation
Skip to main content
Skip to footer

Senior ETL Developer - Regulatory Reporting in Columbus at Huntington

Date Posted: 1/12/2019

Job Snapshot

Job Description

Brief Description:
This role is on the Enterprise Information Management (EIM) team, which is responsible for supporting Huntington's (HNB) Enterprise Data Warehouse, ETL and Business Intelligence tools. The role will ensure that the data assets of HNB are designed in accordance to HNB data architecture that comply with data management strategies, policies, and standards. The candidate will apply knowledge of data architecture and ETL practices to Business and Information Management solutions in the areas of data quality, data integration, data modeling, data governance and data integration. The role will promote and educate data management best practices throughout the Technology & Conversions community

Detailed Description:
This position will model databases and create automated processes of extracting data from source systems and apply business rule transformation and load the data into the target environments. This is a key/core skill for Enterprise Information Management (EIM) as team's primary objects is to build/support the Enterprise Data Warehouse which is used for Regulatory Reporting, Analytical Reporting, and Advanced Analytics.


  • Architect, design and implement enterprise solutions and analytical business solutions.
  • Integrate multiple data sources, via custom developed utilities and standard ETL tools.
  • Design and deploy complex data integration solutions. Provide leadership to offshore development resources to ensure ETL development meets specifications.
  • Experience with Data Modeling - Dimensional and Normalized Relational.
  • Partner with technology teams that support business specific operational systems.
  • Partner with Capital Plan Reporting team to deliver required regulatory reporting.
  • Implement Data Quality processes and drive remediation with Data Stewards.
  • Follow standard project development processes as defined by HNB.
  • Educate business analysts and Data Warehouse developers on the use and benefit of data management best practices including the use of logical and physical data models. Help ensure consistent data modeling practices.
  • Keep up to date with Industry trends, best practices, and industry tools.
  • Follow best practice regarding risk and audit policies.

Basic Qualifications

  • Bachelor's degree or an additional 4 years of experience in IT in lieu of the Bachelor's degree
  • Minimum of 5 years of experience in IT
  • Minimum of 3 years of experience with SQL, ETL development and performance tuning
  • Minimum of 2 years of experience designing and working with star schemas
  • Minimum of 2 years of experience in SQL/Stored Procedure development

Preferred Qualifications

  • Strong understanding of relevant data architecture methodologies and practices, data model methodologies, master data management, data quality, and data integration
  • Experience with ETL tools such as Data Stage, SSIS
  • Experience with standard databases such as DB2, SQL server, and Oracle
  • Experience with Business Intelligence tools such as MicroStrategy, Business Objects, and Cognos
  • Proficiency in data modeling, data enrichment, data consolidation, change data capture and transformation
  • Strong understanding of Data Quality, remediation of errors and exception handling
  • Experience creating test plans and leading testers in the execution of test plans. Able to develop mitigation strategies for managing data integrity issues.
  • Strong ability to partner with other technical professionals and in working collaboratively with Business Analysts, Data Analysts, Architects and Business Intelligence developers
  • Excellent oral and written communication, planning and decision-making skills
  • Possess analytical and problem-solving skills
  • Able to work with people at all levels, including outside consultants and vendors. Able to build and maintain relationships and facilitate collaboration and communication
  • Banking / Financial Services experience
  • Ability to work/manage a multi-vendor environment
  • Ability to work/manage off shore development organizations
  • Experience in data governance is a plus
  • DB2
  • SQLServer
  • MicroStrategy
  • IBM InfoSphere
  • Infogix
EEO/AA Employer/Minority/Female/Disability/Veteran/Sexual Orientation/Gender Identity Tobacco-Free Hiring Practice: Visit Huntington's Career Web Site for more details. Huntington does not accept solicitation from Third Party Recruiters for any position.