UMB Bank NA seeks three Sr. Data Engineers for Kansas City, MO, with option to telecommute or work from anywhere within US.

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 a part of UMB’s data team during an exciting time of growth and modernization. As part of this job, you will be working to implement cloud strategies, modernizing legacy systems, and coding for the future of data processing at UMB. As you grow in technical expertise in one or more areas of specialization as well as leadership capabilities, your position and role within the team would advance and reflect this growth accordingly. If you have a passion for new technology, love to solve complex problems, aren’t afraid to learn technology and love change, we want to talk to you!

The Enterprise Data Warehouse & Analytics team is a close-knit group of data engineers coming from diverse backgrounds and experiences. We share a strong commitment of providing high quality enterprise data solutions and we believe in fully supporting each other to achieve this goal. Trust and open communication are the cornerstones of how we roll, and we have plenty of fun while doing it! Self-education, peer consultation, mentor guidance, and formal training/seminars are some of the methods that we share information and knowledge.

How you’ll spend your time:

The Sr. Data Engineer will be responsible for building and maintaining optimal data pipelines, architectures and data sets required for extraction, transformation, and loading of data from a wide variety of data sources using SQL and integration technologies. Leverage existing data infrastructure to fulfill all data-related requests, perform necessary data housekeeping, data cleansing, normalization, hashing, and implementation of required data model changes. Build and utilize appropriate data platform structures to organize and store data in a particular manner. Work with big data technologies on-prem, cloud and hybrid. Implement data lifecycle management strategies around the flow of data within the organization implementing policy and automated approaches. Implement BI (business intelligence) platforms such as Power BI both on-premises and cloud. Establish governance and strategies around visualization of creating reports and dashboards to help improve upon operational and analytical reporting. Examine, assess, translate, and classify data; recognize, collect and analyze data to encourage the advancement, execution and application of data platform systems. Analyze data to spot anomalies, trends and correlate similar data sets. Design, develop and implement natural language processing software modules. Create models and standards to govern which data is collected, and how it is stored, arranged, integrated, and use in data systems and in organizations. Perform major tasks, deliverables, and formal application delivery methodologies; deliver new or enhanced applications. Perform additional database administrator duties, as assigned.

We’re excited to talk if you have:

Bachelor’s degree in Computer Science or a closely related field.

Five years’ progressive experience in job offered or related which must include experience in the following, concurrently:

• 5 years in a technical role supporting or designing application technologies;

• 5 years in data development or engineering;

• Experience serving as technical lead or project management (formal or informal);

• 5 years with Data Pipeline Development or Business Intelligence Implementation, and subject matter expertise in Modem Data Platform Implementation.

• Experience in the following:

• Analyzing, re-architecting and re-platforming on-premise data warehouses to data platforms on AWS cloud or similar using AWS or similar or 3rd party services;

• Designing and building production data pipelines from ingestion to consumption within a big data architecture, using Java, Python, and Scala or similar technologies;

• Designing and implementing data engineering, ingestion and curation functions on AWS cloud or similar using AWS native or similar or custom programming;

• 3 years of experience designing and developing solutions using AWS or similar services such as Lamdba, Glue, SQS, SNS, Redshift, or similar;

• Architecting and implementing very large-scale data intelligence solutions around Snowflake Data Warehouse or similar technologies;

• Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes Snow SQL;

• Writing SQL queries against Snowflake or similar technologies.

Demonstrated ability to design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS or similar data and analytics services in combination with 3rd parties - Spark, EMR, DynamoDB, RedShift, Kinesis, Lambda, Glue, Snowflake, or similar. Up to 10% local travel required.

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

UMB offers competitive and varied benefits to eligible associates, such as Paid Time Off; a 401(k) matching program; annual incentive pay; paid holidays; a comprehensive company sponsored benefit plan including medical, dental, vision, and other insurance coverage; health savings, flexible spending, and dependent care accounts; adoption assistance; an employee assistance program; fitness reimbursement; tuition reimbursement; an associate wellbeing program; an associate emergency fund; and various associate banking benefits. Benefit offerings and eligibility requirements vary.

Are you ready to be part of something more?

You're more than a means to an end—a way to help us meet the bottom line. UMB isn't comprised of workers, but of people who care about their work, one another, and their community. Expect more than the status quo. At UMB, you can expect more heart. You'll be valued for exactly who you are and encouraged to support causes you care about. Expect more trust. We want you to do the right thing, no matter what. And, expect more opportunities. UMBers are known for having multiple careers here and having their voices heard.

UMB and its affiliates are committed to inclusion and diversity and provide employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex (including gender, pregnancy, sexual orientation, and gender identity), national origin, age, disability, military service, veteran status, genetic information, or any other status protected by applicable federal, state, or local law. If you need accommodation for any part of the employment process because of a disability, please send an e-mail to talentacquisition@umb.com to let us know the nature of your request.

If you are a California resident, please visit our Privacy Notice for California Job Candidates (https://p1.aprimocdn.net/umb/cdbf5f22-8f7a-43b9-bd03-b09f014a39c3/Privacy_Notice_for_California_Candidates_Original_file.pdf) to understand how we collect and use your personal information when you apply for employment with UMB.

Who we are

We are more than a company. We are advisors, consultants, problem solvers, friends, community members, experts, and we are here to help you make the best of every moment with a financial foundation that can help you succeed.

Learn more about UMB's vision (https://p1.aprimocdn.net/umb/8cf58ce2-e9d6-4621-b60a-b09f01638943/UMB_Tuce_Book_Original_file.pdf)

Check out the road to a career at UMB