Job Title: Data Engineer

FLSA Status: Exempt

Department: Enterprise Data Analytics

Hours of Operation: Monday - Friday - 40 hours

General Job Summary:

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

Working Conditions: Works in office with occasional travel to bank locations, training seminars and conferences

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)

Benefits:

• 401(K) with a company match of up to 6%
• ESOP employer match
• Medical insurance
• Dental insurance
• Vision insurance
• Cancer/Disease insurance
• Accident insurance
• Flexible Spending Accounts
• Flexible Savings Accounts
• Health Savings Accounts
• Bank paid Life/AD&D insurance
• Voluntary Life/AD&D insurance
• Bank paid Short-Term and Long-Term Disability insurance
• Employee Stock Purchase Plan
• Employee Assistance Program