Lead Software Engineer - ETL, Databricks and Data Modeling

    • JPMorgan Chase & Co.
  • Chicago, IL
  • Posted 60+ days ago | Updated 6 hours ago


On Site
Full Time


Software design
Information architecture
Software engineering
Systems design
Application development
Star schema
Electronic Health Record (EHR)
Amazon Web Services
Amazon S3
Amazon EC2
Software development
Continuous integration
Continuous delivery
Cloud computing
Artificial intelligence
Machine Learning (ML)
Financial services
Data integration
Data warehouse
Data modeling
Big data
Meta-data management
IBM Cognos
Qlik Sense
Business analysis
Business analytics
Management information systems
Computer science
Investment banking
Corporate banking
Asset management
Health care

Job Details

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 Software Engineer at JPMorgan Chase within the Corporate Technology's Chief Administrative Office Technology team, you are an integral part of an agile team that works to enhance, build, and deliver trusted market-leading technology products in a secure, stable, and scalable way. As a core technical contributor, you are responsible for conducting critical technology solutions across multiple technical areas within various business functions in support of the firm's business objectives.

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
  • Develops secure high-quality production code, and reviews and debugs code written by others
  • 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
  • Adds to team culture of diversity, equity, inclusion, and respect

Required qualifications, capabilities, and skills
  • Formal training or certification on software engineering concepts and 5+ years of applied experience
  • Hands-on practical experience delivering system design, application development, testing, and operational stability
  • Experience with ETL tools (design and development) including Informatica, Star Schema data models, AWS Glue, and Databricks
  • Advanced in one or more programming language(s) such as PL/SQL, Python, and Java
  • Expert knowledge in AWS Lake Formation, AWS Glue, AWS Athena, EMR, AWS ECS, AWS EKS, AWS Fargate, Kubernetes, AWS S3, AWS EC2
  • Proficiency in automation and continuous delivery methods
  • Proficient in all aspects of the Software Development Life Cycle including advanced understanding of agile methodologies such as CI/CD, Application Resiliency, and Security
  • Demonstrated proficiency in software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)
  • Knowledge of the financial services industry and their IT systems
  • Experience in large scale data integration and data warehouse solutions and data modeling
  • Experience with Oracle 11g or Higher database including partitioning and NoSQL databases

Preferred qualifications, capabilities, and skills
  • Strong experience with Databricks, Datalakes, data products, Big data technologies and handling Metadata
  • Exposure to reporting tools such as Cognos, Qlik Sense, QlikView,
  • BS/BA in related discipline strongly preferred (i.e., IT, MIS, Computer Science, Technology, etc.).

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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.