Sr. Data Engineer (AWS)
Role details
Job location
Tech stack
Job description
As a Sr. Data Engineer , you will be responsible for building and optimizing data architecture, data pipelines in support of UMB's Alternative Investments web applications including various other applications. You will work closely with the team to design and build enterprise-level solutions. You will look for ways to assist in improving development efficiency and implementing best practices. This is a subset of the overall responsibilities which involves other multiple initiatives as assigned by IT leadership., * Design and develop cloud native data systems and architecture for application, API and reporting needs.
- Build resilient data pipelines (ETL/ELT) for incremental and initial data loads into OLTP and OLAP databases using tools such as Glue, Airflow, Step functions.
- Ability to optimize SQL queries for performance and evangelize best practices to the team.
- Troubleshoot data pipeline, integration, and deployment issues.
- Implement monitoring and observability to ensure data timeliness and correctness into destination systems.
- Become a domain expert on the Alternative Investments business and systems.
- Provide mentorship to members of the team and help foster a learning environment.
Requirements
- Bachelor's degree in computer science, Data Engineering or similar discipline including at least 5 years of industry experience.
- Proficiency in SQL and programming languages like Python, Spark etc.
- Expertise in cloud technologies such as AWS or Azure including experience implementing cloud-based solutions using Serverless, Containers, Observability, and Security.
- Understanding of data systems and have optimized pipelines for cost efficiency and performance.
- Experience with relational (PostgreSQL) and non-relational databases (DynamoDB), and comfortable with writing SQL and NoSQL queries.
- Working knowledge of CI/CD or DevOps.
Bonus Points if you have:
- Data Engineering Certifications or done data engineering courses.
- Built pipelines that process large volumes of data.
- Experience in building real time or near real time data pipelines.
- Experience using Gen AI tools for Code Generation and SDLC Processes.
Applicants must have legal authority to work in the United States. Work Visa sponsorship is not available for this position.
Benefits & conditions
$83,200.00 - $178,800.00
The posted compensation range on this listing represents UMB's standard for this role, but the actual compensation may vary by geographic location, experience level, and other job-related factors. In addition, this range does not encompass the full earning potential for this role. Please see the description of benefits included with this job posting for additional information
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.
