Lead Software Engineer - Data

J.P. MORGAN; Glasgow; On-site; GBP 50,000 - 80,000; Full time

Job summary

A global financial services leader based in Glasgow is seeking a talented Software/Data Engineer to join their Capital Analytics team. In this role, you will design and maintain scalable data processing solutions utilizing Databricks, Python, and AWS. Key responsibilities include implementing ETL pipelines, collaborating with cross-functional teams, and ensuring data quality throughout processing phases. The ideal candidate will have strong skills in SQL, Python, and data management. Join the team and contribute to transforming data into actionable insights.

Qualifications

• Proven experience in data management and large-scale data processing.
• Proficiency in SQL, Python, and PySpark.
• Hands-on experience with cloud migration using data lake platforms.

Responsibilities

• Design and implement data pipelines for large-scale data processing.
• Develop fact and dimension data models for analytics.
• Collaborate with stakeholders to develop data management strategies.

Skills

Data management

ETL/ELT pipeline development

SQL

Python

PySpark

Data quality

Problem-solving

Cloud-based data solutions

Tools

Databricks

Spark

Job description

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 Capital Analytics 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 Capital Technology 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 and implement data pipelines and scalable data processing workflows using Python, PySpark, SQL, and Databricks or Spark for large-scale, complex data environments.
• Develop fact and dimension data models for reporting and analytics.
• Write secure, high-quality production code, and review and debug code written by others.
• Identify and automate remediation of recurring issues to improve the operational stability of software applications and systems.
• Lead evaluation sessions with external vendors, startups, and internal teams to assess architectural designs, technical credentials, and applicability within existing systems.
• 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.
• Collaborate with business stakeholders to develop data management strategies, transforming data into insights that drive strategic decisions.
• Ensure data quality, consistency, security, and lineage throughout all stages of data processing and transformation as well as supporting data migration and modernization initiatives, transitioning legacy systems to cloud-based data warehouses.
• Document data flows, logic, and transformation rules to maintain transparency and facilitate knowledge sharing.
• Troubleshoot and resolve performance and quality issues in both batch and real-time data pipelines. Deliver comprehensive solutions to data challenges by applying appropriate data strategies and tools.

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.
• Hands-on experience with data lake platforms (Databricks, Spark, or similar).
• Strong understanding of data quality, security, and lineage best practices.
• Experience with cloud-based data warehouse migration and modernization.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and documentation abilities.
• Ability to collaborate effectively with business and technical stakeholders.

About Us

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.

About The Team

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.