Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Lead Data Engineer - ETL & SQL

AT JPMorgan Chase
JPMorgan Chase

Lead Data Engineer - ETL & SQL

Columbus, OH

Join us as we embark on a journey of collaboration and innovation, where your unique skills and talents will be valued and celebrated. Together we will create a brighter future and make a meaningful difference.

As a Lead Data Engineer at JPMorgan Chase within the Corporate Sector Enterprise Technology and Tech Reference Data, you are an integral part of an agile team that works to enhance, build, and deliver data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. As a core technical contributor, you are responsible for maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm's business objectives.

Job responsibilities

Want more jobs like this?

Get Data and Analytics jobs in Columbus, OH delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


  • 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.
  • Delivers data collection, storage, access, and analytics data platform solutions in a secure, stable, and scalable way.
  • Collaborates with team members across Columbus, Argentina, and Jersey City to ensure seamless integration and operation of the Fabric service within the Technology Reference Data (TRD) framework.
  • Develops and implements data federation strategies using APIs, RDMS, and Object Stores to facilitate unified data access for Business Analysts, Data Scientists, Data Engineers, and Software Developers.
  • Utilizes ANSI SQL to enable efficient data aggregation and manipulation across multiple data sources, enhancing analytical capabilities and decision-making processes.
  • Designs and maintains robust software solutions for authorization and key management, ensuring secure connectivity to both private and public cloud environments.
  • Constructs and optimizes data pipelines for ETL/ELT operations, ensuring efficient data processing and transformation to meet business needs.
  • Builds and manages container images for custom services and applications, as well as third-party open-source applications, to support scalable and reliable deployment in cloud environments.
  • Evaluates and reports on access control processes to determine effectiveness of data asset security with minimal supervision.
  • Adds to team culture of diversity, equity, inclusion, and respect.

Required qualifications, capabilities, and skills

  • Formal training or certification on data and software engineering concepts and 5+ years applied experience.
  • Strong experience with both relational and NoSQL databases.
  • Experience and proficiency across the data lifecycle.
  • Experience in building and deploying applications within containerized environments utilizing tools such as Kustomize, Kubernetes and Docker.
  • Expertise in designing and implementing scalable data architectures and pipelines.
  • Strong proficiency in programming languages such as Python, JAVA and SQL.
  • In-depth knowledge of data warehousing solutions and ETL processes.
  • Ability to work collaboratively with cross-functional teams, including data scientists, analysts, and business stakeholders.
  • Experience with data governance and ensuring data quality and integrity.
  • Excellent communication skills, with the ability to convey complex technical concepts to non-technical audiences.
  • Experience with version control systems like Git and CI/CD pipelines for data engineering workflows.

Preferred qualifications, capabilities, and skills

  • Experience with Trino / Presto and other SQL query engines.
  • Proficiency in Big Data technologies, with a strong focus on Performance Optimization using best practices.
  • Solid understanding of the Parquet, ORC and AVRO file formats.
  • Solid understanding of open table formats particularly iceberg.
  • Experience in building, maintaining and optimizing iceberg tables.
  • Proficiency in building and maintaining efficient container images,
  • Experience with orchestration tools such as Airflow.


ABOUT US

JPMorganChase, 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. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, 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.

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 & Co. is an Equal Opportunity Employer, including Disability/Veterans

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.

Client-provided location(s): Columbus, OH, USA
Job ID: JPMorgan-210623311
Employment Type: Full Time