Senior Lead Data Engineer - AWS Redshift/Lake Formation

Job Description
As an AWS Redshift Expert you will drive business impact and tackle data engineering challenges that span multiple data pipelines, architectures, and consumers
Commercial Banking IT is looking for a Big Data Software Engineer with skills and experience implementing large-scale data lakes on internal as well as public cloud platforms. This individual will work with an existing development team to continue to enhance the internal data lake while setting up the foundation for the public cloud data lake migration.
Job Summary
As a Senior Lead Data Engineer at JPMorgan Chase, within the Commercial Bank IT, 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

• Provides recommendations and insight on data management, governance procedures, and intricacies applicable to the acquisition, maintenance, validation, and utilization of data
• Designs and delivers trusted data collection, storage, access, and analytics data platform solutions in a secure, stable, and scalable way
• 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
• Approves data analysis tools and processes
• Strong experience with AWS Redshift, including setup, configuration, administration, and troubleshooting.
• Experience with data warehousing and data modeling, including design and optimization of data structures for performance and scalability.
• Strong experience with SQL and a good understanding of database management systems.

Required 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
• Experience presenting and delivering visual data
• The ideal candidate for this role would have several years of experience working with AWS Redshift and a proven track record of 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
• Experience in Data governance, data lineage, data quality, and data cataloging

Preferred Qualifications, Capabilities, and Skills

• Working experience with both relational and NoSQL databases
• Working experience with data virtualization technologies like Starburst
• 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 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. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.
The health and safety of our colleagues, candidates, clients and communities has been a top priority in light of the COVID-19 pandemic. JPMorgan Chase was awarded the "WELL Health-Safety Rating" for all of our 6,200 locations globally based on our operational policies, maintenance protocols, stakeholder engagement and emergency plans to address a post-COVID-19 environment.
As a part of our commitment to health and safety, we have implemented various COVID-related health and safety requirements for our workforce. Employees are expected to follow the Firm's current COVID-19 or other infectious disease health and safety requirements, including local requirements. Requirements include sharing information including your vaccine card in the firm's vaccine record tool, and may include mask wearing. Requirements may change in the future with the evolving public health landscape. JPMorgan Chase will consider accommodation requests as required by applicable law.
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, discretionary incentive compensation which may be awarded in recognition of 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.
Equal Opportunity Employer/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.