Sr. Data Engineer

The Enterprise Data Warehouse & Analytics team provides support of our data warehouse environment and analytics tools. This allows our business leaders access to business intelligence data in order to develop strategies for our organization to grow.

As a Sr. Data Engineer, you will be involved in implementing Snowflake cloud strategies, modernizing legacy systems, building real-time reporting solutions, and coding for the future of data processing using technologies included but not limited to AWS, Confluent Kafka, Aurora PostgreSQL, Snowflake, Matillion and Informatica. This is a subset of the overall responsibilities which will include multiple initiatives assigned by IT leadership.

• Designing, building and maintaining optimal cloud data pipelines, architecture and data sets for ETL, real-time architecture, and data sets for streaming and ETL using Kafka and Precisely, alongside Snowflake structures.
• Building and optimizing PySpark ETL jobs for S3-to-Aurora data loading using metadata-driven mappings and field validation along with collecting performance metrics.
• Develop and maintain AWS Lambda functions and Event Bridge schedules and rules to orchestrate pipeline workflows, handle operational status, and send alerts.
• Develop and optimize Aurora PostgreSQL schemas, stored procedures, Real time and batch-load processes, indexes, and queries; troubleshoot database and data-processing issues.
• Building and managing high-performance relational database structures, focusing on PostgreSQL DB replication, optimization, and real-time reporting pipelines.
• Implementing governance and data lifecycle management strategies around the flow of data within UMB which includes policy and automated approaches.
• Implementing organizational models to oversee data collection, storage, and utilization.
• Design and support Kafka topics, partitions, retention policies, and access controls to meet data-volume and availability needs.
• Build and maintain producers and consumers that publish and process events reliably, preserving key-based ordering where required.
• Mentoring team members in collaboration with the senior architect while applying cloud expertise to modernize technologies and evaluate complex data trends.
• Evaluating, assessing and translation of data including identifying anomalies, trends and correlation of similar data sets.
• Creating models and standards to govern which data is to be collected, how it is stored, arranged, and utilized in data systems and within the organization.

• Bachelor’s Degree in Information Technology and at least 5 years of experience in a technical role supporting and designing application technologies OR at least 8 years of relevant work experience in a technical role supporting and designing application technologies.
• At least 5 years of experience in cloud data development / engineering, specifically utilizing Azure or AWS, with hands‑on experience deploying and managing Snowflake data platforms.
• At least 5 years of experience with Data Pipeline Development and Business Intelligence implementations, featuring subject matter expertise in Modern Data Platform architectures including Apache Kafka for streaming, PostgreSQL DB management, and Precisely for data integration and replication.
• A business first mindset and comfortable with change as well as having a passion to learn and use new modern technologies, including databases, code sets, and integration best practices.

• Banking or financial services industry experience.

Applicants must have legal authority to work in the United States. Work Visa sponsorship is not available for this position.

This position was posted on 10/16/2026. The Final date to…