Senior Data Engineer DataStage

Job Title: Senior Data Engineer DataStage

Location: Cincinnati, Ohio 45202, Hybrid

Duration: 10+ Months with possible extensions

Technical Skills - Must Have

• 3 + years of experience in ETL space
• Business Intelligence - Data Engineering
• Strong SQL development skills

Nice To Have

• 3+ years experience in the banking or financial industry.
• Ascential DataStage
• Data Build Tool (DBT) for Development & Maintenance of Data Models
• IBM Db2
• Python

Job Description:

• As a senior data engineer within the Enterprise Data Office, you will help build and support Fifth Third s Regulatory Reporting ecosystem by migrating our legacy ETL and DB2 systems to modern ETL systems and Snowflake. This involves analyzing data as it flows through the Bancorp's systems, designing data solutions, and authoring ETL to implement those designs. The data within the Bancorp's Warehousing solutions is extensively used to support virtually every Line of Business, and is a critical component of all major initiatives. Primary technologies include DB2, DataStage, dbt, and Snowflake; the ideal candidate will be team-oriented, possess a strong ETL background, and have a passion for digging into data and self-initiated learning.
• 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:

• Lead migration efforts from Legacy tools of DataStage and DB2 to modern tools of modern ETL tools and Snowflake.
• Act as a liaison between Data Engineer teams and Business Stakeholders ensuring communication is clear and concise.
• Responsible for design, Development, and Support of data solutions, APIs, tools, and processes to enable rapid delivery of business capabilities.
• Work closely with IT application teams, Enterprise architecture, infrastructure, information security, and LOB stakeholders to translate business and technical strategies into data-driven solutions for the Bank.
• Act as a technical Expert addressing problems related to system and application design, performance, integration, security, etc.
• Conduct research and Development based on current trends and technologies related to the banking industry, data engineering and architecture, data security, and related topics.
• Work with developers to Build CI/CD pipelines, Self-service Build tools, and automated deployment processes.
• Evaluate software products and Provide documented recommendations as needed.
• Provide Support and troubleshooting for data platforms. Must be willing to Provide escalated on-call Support for complicated and/or critical incidents.
• Participate in the planning process for hardware and software.
• Plan and work on internal projects as needed, including legacy system replacement, Monitoring and analytics improvements, tool Development, and technical documentation.
• Provide technical guidance and mentoring for other team members.
• Manage and prioritize multiple assignments.

Minimum knowledge, Skills And Abilities required:

• Bachelor's degree in Computer Science/Information Systems or equivalent combination of education and experience.
• Must be able to communicate ideas both verbally and in writing to management, business and IT sponsors, and technical resources in language that is appropriate for each group.
• At least 4 years of related experience as a Data Engineer.
• Experience with migrating from legacy DB2 systems to modern Snowflake systems is extremely beneficial.
• Experience in one or more of the following disciplines preferred: big data technologies and distributions, metadata management products, Bi and reporting tools, messaging systems, data warehousing, and virtualization tools, major cloud, or rest API design and development.
• Financial industry experience is a plus
• Experience using dbt or a like software and Snowflake is required.
• Experience in mentoring Junior Engineers is a plus.
• Experience in using Data Visualization tools is a plus.