Lead Software Engineer - AWS Redshift

Job Description
We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible.
As a Lead AWS Redshift Engineer at JPMorgan Chase within the Commercial Bank - Global Banking team, you are an integral part of an agile team that works to enhance, build, and deliver data collection, storage, access, and analytics in a secure, stable, and scalable way. Leverage your deep technical expertise and problem solving capabilities to drive significant business impact and tackle a diverse array of challenges that span multiple data pipelines, data architectures, and other data consumers.
Job responsibilities

• Executes creative software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems
• Designs and delivers trusted data collection, storage, access, and analytics data platform solutions in a secure, stable, and scalable way and maintain the cloud data lake environment.
• Identifies opportunities to eliminate or automate remediation of recurring issues to improve overall operational stability of software applications and systems
• Leads evaluation sessions with external vendors, startups, and internal teams to drive outcomes-oriented probing of architectural designs, technical credentials, and applicability for use within existing systems and information architecture
• Leads communities of practice across Software Engineering to drive awareness and use of new and leading-edge technologies
• Provides recommendations and insight on data management, governance procedures, and intricacies applicable to the acquisition, maintenance, validation, and utilization of data
• Defines database back-up, recovery, and archiving strategy
• Generates advanced data models for one or more teams using firm wide tooling, linear algebra, statistics, and geometrical algorithms

Required qualifications, capabilities, and skills

• Formal training or certification on software engineering concepts and 5+ years applied experience
• Highly skilled in the data space especially in Big Data technologies (Spark, Impala, Hive, Redshift, Kafka, etc.) and well versed in AWS
• Hands-on practical experience delivering system design, application development, testing, and operational stability
• Experience presenting and delivering visual data
• Proven track record working with AWS Redshift delivering high-performing, scalable data warehousing solutions in the AWS cloud
• Experience in migrating on-premise data warehousing solutions to cloud-based solutions, such as AWS Redshift
• Expertise in Data governance, data lineage, data quality, and data cataloging
• Advanced understanding of agile methodologies such as CI/CD, Application Resiliency, and Security

Preferred qualifications, capabilities, and skills

• Working experience with both relational and NoSQL databases
• Advanced understanding of database back-up, recovery, and archiving strategies
• Advanced knowledge of linear algebra, statistics, and geometrical algorithms
• Strong communication and collaboration skills, including the ability to work effectively with cross-functional teams.

About Us
JPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set, and location. For those in eligible roles, we offer discretionary incentive compensation which may be awarded in recognition of firm performance and individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
JPMorgan Chase is an Equal Opportunity Employer, including Disability/Veterans
About the Team
Commercial Banking is focused on helping our clients succeed and making a positive difference in our communities. We provide credit and financing, treasury and payment services, international banking and real estate services to clients including corporations, municipalities, institutions, real estate investors and owners, and nonprofit organizations.