Data Engineer

Stock Yards Bank & Trust is seeking a skilled and detail-oriented Data Engineer to support the bank’s data analytics initiatives. The selected candidate will work closely with data analysts, data scientists, and key stakeholders across the bank to design, develop, and maintain scalable data pipelines and infrastructure. This role involves designing and implementing ETL processes, ensuring data quality and integrity, and developing robust data models to support comprehensive reporting and analytics needs. The ideal candidate will have a strong technical background in data engineering, experience with various database architectures and ETL tools, and a passion for leveraging data to drive business value. This is an onsite position with no relocation assistance provided.

Organizational Duties and Responsibilities:

Supports the mission, vision and philosophy of the bank. Complies willingly with all organizational policies and procedures.

Supports all functions that maintain compliance with regulatory agencies.

Essential Duties and Responsibilities:

Design, develop, and maintain scalable data pipelines to support the bank’s data analytics initiatives

Implement and optimize ETL processes to ensure efficient data flow and integration from various sources, including APIs, SFTP, cloud and on-prem systems

Collaborate and communicate effectively with analysts and business stakeholders to empower self-service analytics, facilitate the discovery of insights, and create intuitive visual representations of data

Develop and maintain data models to support reporting, analytics, and data visualization needs

Developing and implementing data security measures to protect sensitive information

Ensure data quality and integrity by implementing data governance practices, including data validation, cleansing, and classification

Monitor and troubleshoot data pipeline performance to ensure reliability, efficiency and cost optimization

Maintain healthy code repositories and leverage source control systems (e.g., Git) to ensure efficient version management, seamless collaboration, and adherence to best practices in code management

Develop and maintain an understanding of the bank’s data sources and how they can be used to provide business value for the bank

Stay up to date with emerging technologies and industry trends to drive innovation and maintain a competitive edge in data engineering

Develop and maintain documentation for data pipelines, processes, and data models

Education: Bachelor’s degree in Data Analytics, Statistics, Mathematics, Computer Science, Business Administration or related field

Experience:

5+ years of experience working in an analytics/data engineering role

Track record of success in developing and deploying creative insights, services and solutions that drove increased business value

Financial services background is a plus

3+ years working on maintaining databases with a focus on improving data ingestion pipelines

Expertise in designing and implementing star schema dimensional models, establishing a single source of truth for analytical reporting, dashboards and insights discovery

Experience with various database architectures (e.g. SQL Server, Snowflake, Databricks, Azure)

Experience with various visualization solutions (e.g. Tableau, PowerBI, Sigma, MicroStrategy)

Experience with various ETL and orchestration solutions (e.g. Informatica, Fivetran, DBT, Matillion)

Proficient in writing advanced SQL to handle complex data transformations

Specific Skills:

Motivated, self-starter

Track record of working autonomously with organizational and time management skills

Proven ability to manage multiple projects simultaneously while maintaining high standards of quality and meeting deadlines

Enjoy supporting team members by sharing technical knowledge and helping solve problems

Ability to develop and follow documented policies and procedures to ensure proper compliance

Strong technical acumen and decision-making skills

Strong problem-solving skills with the ability to troubleshoot and resolve complex technical issues efficiently

Exhibit a professional appearance and demeanor

Ability to work flexible work schedules, after-hours as required

Professional verbal and written communication skills

Ability to use the Microsoft Office M365 suite of products

Physical requirements:

The physical demands described here are representative of those that must be met by an employee in order to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Primarily sedentary work performed in an office environment

Ability to sit for extended periods of time while working at a computer

Frequent use of hands and fingers to operate a computer, keyboard, mouse, and other office equipment

Ability to speak clearly and hear well enough to communicate with clients, team members, and vendors via phone, video, and in person

Visual acuity sufficient to read computer screens, printed documents, and financial data

Occasional standing, walking, bending, or reaching

Ability to lift and carry up to 10-15 pounds occasionally (e.g., files, office supplies)

Place of Work