Lead Data Engineer : Fifth Third Bank

Job Title

Designs and implements software & support solutions as a member of an agile squad. Software in scope are 3rd party software applications which support finance and regulatory reporting business functions. Technical support functions include ETL, file transfer services, job scheduling, multiple environment support, data quality, upgrades, incident & problem resolution, etc.

Duration

6-month long Contract with the potential for extension

Schedule

Hybrid schedule- must be on-site 2-3 days a week

Location

Cincinnati, OH visa: all

FYI- The end client is NOT accepting relocation candidates. Please send candidates who are local to the Cincinnati, Oh area. Within a 45-minute commute, as this role is 2-3 days a week onsite in Cincinnati.

General Function

Designs and implements software & support solutions as a member of an agile squad. Software in scope are 3rd party software applications which support finance and regulatory reporting business functions. Technical support functions include ETL, file transfer services, job scheduling, multiple environment support, data quality, upgrades, incident & problem resolution, etc. Being assigned to an agile squad means this role also participates in all agile ceremonies driving activities from design to delivery. Follows best practices and standards and participates in communities of practice to continuously refine and document these standards, following any required compliance & governance requirements. Responsible and accountable for risk by openly exchanging ideas and opinions, elevating concerns, and personally following policies and procedures as defined. Accountable for always doing the right thing for customers and colleagues and ensures that actions and behaviors drive a positive customer experience. While operating within the Bank's risk appetite, achieves results by consistently identifying, assessing, managing, monitoring, and reporting risks of all types.

Essential Duties and Responsibilities

• Provide technical knowledge, leadership and collaboration as an ETL developer & designer
• Develop and maintain data transfer jobs & schedulers, as required, including to identify & execute opportunities to automate
• Achieve operational excellence by automating processes and writing maintainable, supportable, and testable code
• Assist with problem resolution for end users and customers, including incident & problem management
• Support both application and environment upgrades, new implementations & patches, as required.
• Develop software meeting code quality standards and metrics
• Participate in communities of practice by contributing to and following standards, test driven development, reviewing others code, and sharing knowledge
• Maintain effective partnerships with operations and engineering teams to drive service improvement
• Remain current on IT trends pertaining to their area of practice
• Contribute to the definition of operational procedures for software development
• Maintain appropriate controls and documentation to ensure compliance of audit requirements

Minimum Knowledge, Skills and Abilities Required

• Bachelor's degree in Computer Science/Information Systems
• Understanding of Object-Oriented Programming Languages
• Understanding of Software Development Lifecyle
• Strong SQL Skills with ability to perform ETL
• Familiarity with relational database architecture techniques like EDW, Postgres, etc.
• Demonstrated practice for scripting languages, like Python, Java, PowerShell
• Strong Windows Server Experience and/or Application Support Experience
• Prior experience with Alation, Snowflake, NIFI/KAFKA, PowerBI, Tableau, & Git is a plus
• Understanding of Agile Software Development methodologies
• Understanding of data management and info security best practices
• Demonstrated problem solving skills
• Demonstrated collaboration skills
• Excellent verbal and written communication skills
• Prior experience working for a financial institution or with Debit Cards a plus

Must Haves

• Apache Kafka
• Ability to write complex procedures/views/SQL
• Apache NIFI & SQL
• ETL
• Scripting languages for automation (Java, Python, PowerShell); Experience working in Data Management framework; Experience in platform engineering activities (platform standup, software upgrades, patching, etc.); and proficiency in admin operating systems (Linux, CLI)
• Cloud data warehousing – Snowflake preferred