Lead Software Engineer - Python, Databricks, AWS

Next Frontier Capital; Glasgow; On-site; GBP 90,000 - 120,000; Full time

Job summary

JPMorgan Chase in the United Kingdom is seeking a Lead Software Engineer to design, develop, and maintain scalable data processing solutions using Databricks, Python, and AWS. You will collaborate with cross-functional teams to turn data into actionable insights that support strategic decisions.

You will mentor associates, guide SDLC, ensure data quality and security, implement monitoring, and drive modernization of data warehouses.

Qualifications

• Proven experience in data management, ETL/ELT pipelines, and large-scale data processing.
• Proficiency in SQL, Python, and PySpark, with query optimization and performance tuning.
• Hands-on experience with data lake platforms (Databricks, Apache Spark, or similar).
• Experience with AWS cloud services (S3, ECS, SNS/SQS, Lambda, etc.).
• Strong understanding of data quality, security, and lineage best practices.
• Experience with cloud-based data warehouse migration and modernization.
• Proficient in CI/CD, delivery methods, the SDLC, and Agile methodologies.
• In-depth knowledge of the financial services industry and their IT systems.
• Excellent problem-solving, troubleshooting, and analytical skills.
• Strong communication and documentation abilities.

Responsibilities

• Execute creative, data-driven software solutions, including design, development, and troubleshooting, with the ability to think beyond routine approaches.
• Design, develop, and maintain scalable data pipelines and processing workflows using Python, PySpark, SQL, and Databricks on AWS.
• Develop fact and dimension data models for reporting and analytics.
• Write secure, high-quality production code, and review code written by others.
• Ensure data quality, security, and lineage throughout data processing and transformation; implement monitoring and alerting.
• Support data migration and modernization initiatives, transitioning legacy systems to cloud-based data warehouses.
• Lead communities of practice across Software Engineering to promote adoption of new technologies; foster diversity and inclusion.
• Mentor Associate-level engineers, supporting their development and delivery standards.
• Collaborate with stakeholders to transform data into insights for strategic decisions.
• Document data flows, logic, and transformation rules for transparency and knowledge sharing.
• Lead and participate in the full SDLC, including requirements, design, development, testing, deployment, and maintenance.
• Identify and automate remediation of recurring issues to improve operational stability; act as Production Support and SRE for pipelines and services.
• Utilise AI tools to accelerate development and testing of data pipelines.

Skills

SQL

Python

PySpark

Databricks

AWS

CI/CD

Agile methods

Data modeling

SRE basics

Tools

Airflow

Jenkins

Spinnaker

SonarQube

GitHub Copilot

Job description

We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible. Join our innovative External Regulatory Financial Control (ERFC)/Strategic Data team at JPMorganChase where we leverage cutting-edge technology to drive data-driven decision-making and enhance business performance. We are seeking a talented and motivated Software/Data Engineer to join our team and contribute to our mission of transforming data into actionable insights.

As a Lead Software Engineer at JPMorgan Chase within the External Regulatory Financial Control (ERFC)/Strategic Data team, you will play a crucial role in designing, developing, and maintaining scalable data processing solutions using Databricks, Python, and AWS. You will collaborate with cross-functional teams to deliver high-quality data solutions that support our business objectives.

Job responsibilities

• Execute creative, data-driven software solutions, including design, development, and technical troubleshooting, with the ability to think beyond routine approaches to solve technical problems.
• Design, develop, and maintain scalable data pipelines and processing workflows using Python, PySpark, SQL, and Databricks on AWS, processing and transforming large-scale financial datasets for analytics and reporting.
• Develop fact and dimension data models for reporting and analytics.
• Write secure, high-quality production code, and review and debug code written by others.
• Ensure data quality, consistency, security, and lineage throughout all stages of data processing and transformation, implementing monitoring and alerting mechanisms to maintain pipeline reliability.
• Support data migration and modernization initiatives, transitioning legacy systems to cloud-based data warehouses.
• Lead communities of practice across Software Engineering to promote awareness and adoption of new technologies. Foster a team culture of diversity, opportunity, inclusion, and respect.
• Mentor and guide Associate-level engineers, supporting their technical development and ensuring consistent delivery standards across the team.
• Collaborate with business stakeholders to develop data management strategies, transforming data into insights that drive strategic decisions.
• Document data flows, logic, and transformation rules to maintain transparency and facilitate knowledge sharing.
• Lead and Participate in the full Software Development Life Cycle (SDLC), including requirements gathering, design, development, testing, deployment, and maintenance
• Identify and automate remediation of recurring issues to improve operational stability, acting as both Production Support and SRE function for data pipelines and platform services.
• Utilise AI tools to accelerate development and testing of data pipelines (e.g. GitHub CoPilot, Claude Code).

Required qualifications, capabilities, and skills

• Proven experience in data management, ETL/ELT pipeline development, and large-scale data processing.
• Proficiency in SQL, Python, and PySpark, with experience in query optimization and performance tuning.
• Hands-on experience with data lake platforms (Databricks, Apache Spark, or similar).
• Experience with AWS cloud services (S3, ECS, SNS/SQS, Lambda, etc.).
• Strong understanding of data quality, security, and lineage best practices.
• Experience with cloud-based data warehouse migration and modernization.
• Proficient in CI/CD, continuous delivery methods (Jules/Jenkins, Spinnaker, Sonar), the full Software Development Life Cycle, and Agile methodologies.
• In-depth knowledge of the financial services industry and their IT systems.
• Excellent problem-solving, troubleshooting, and analytical skills with ability to investigate data issues, identify root causes, and implement solutions.
• Strong communication and documentation abilities, with the ability to collaborate effectively with business and technical stakeholders.

Preferred qualifications, capabilities, and skills

• Knowledge of regulatory reporting and financial data aggregation techniques.
• Experience with data orchestration tools (Airflow, Step Functions, etc.).
• Databricks or AWS certifications.
• Demonstrated proficiency in cloud-native development (e.g., cloud, artificial intelligence, machine learning).
• Experience with Parquet, JSON, CSV, Avro, Delta Lake file formats.

J.P. Morgan is a global leader in financial services, providing strategic advice and products to the world’s most prominent corporations, governments, wealthy individuals and institutional investors. Our first-class business in a first-class way approach to serving clients drives everything we do. We strive to build trusted, long-term partnerships to help our clients achieve their business objectives.

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.

Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we’re setting our businesses, clients, customers and employees up for success. Maintain critical data pipelines and architectures across multiple technical areas as an integral part of an agile team