Huntington National Bank Sr. Data Warehouse Developer in Columbus, Ohio

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.

Responsibilities:

  • 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: To demonstrate our commitment to health and wellness, Huntington will not hire any candidate who uses tobacco or any nicotine product including, but not limited to, cigarettes, cigars, pipes, smokeless tobacco, chewing tobacco, snuff or snus, nicotine gum, the nicotine patch or any other kind of nicotine replacement product (where permitted by applicable state law). Candidates applying for positions in those states will be notified of this practice during the recruitment process and, if offered a position, will be screened for cotinine (to check for use of tobacco and/or nicotine products and/or nicotine replacement therapy products) before they begin employment. If the position to which you're applying is covered by this practice, the job application will provide greater detail as to what constitutes tobacco use.

Huntington does not accept solicitation from Third Party Recruiters for any position.