Senior Lead Software Engineer

JPMorgan Chase JPMorgan Chase · Banking · Jersey City, NJ +1 · Commercial & Investment Bank

Senior Lead Software Engineer at JPMorgan Chase focused on building and enhancing cloud-based BI and analytics solutions for Commercial and Investment Banking. The role involves designing and delivering solutions on large datasets, improving data performance, and leveraging AI-assisted development practices to speed up delivery. Responsibilities include managing ETL/ELT pipelines, data warehousing, query optimization, and developing dashboards, while also providing technical guidance and driving product design.

What you'd actually do

  1. Regularly provides technical guidance and direction to support the business and its technical teams, contractors, and vendors
  2. Builds and evolves cloud-based BI and analytics solutions that turn large, complex datasets into reliable decision-ready insights
  3. Designs and owns managed ETL/ELT pipelines (e.g., AWS Glue, Airflow) with clear SLAs, monitoring, and cost/performance controls
  4. Models and maintains data warehouse structures that scale to very large volumes while staying easy to query and extend
  5. Delivers performant data products by applying query optimization, profiling, and performance monitoring techniques

Skills

Required

  • Formal training or certification on software engineering concepts and 5+ years applied experience
  • 5+ years of strong experience in the Business Intelligence domain with 5+ years of strong experience in Cloud Technologies (e.g. AWS/Azure/Google Cloud)
  • Hands-on practical experience delivering system design, application development, testing, and operational stability
  • Strong experience in managed ETL modern skills (e.g. Amazon Glue/Airflow).
  • Highly proficient and knowledge about data warehousing concepts.
  • Experience in designing BI solutions on large datasets with a hands-on experience on modern data visualization tools (e.g. Tableau)
  • Understanding data and query optimization, query profiling, and query performance monitoring tools and techniques.
  • Extensive knowledge on database design techniques and experience on working with extremely large data volumes at scale.
  • Proficient in leveraging AI technologies to enhance coding practices, including the development and deployment of intelligent agents and automation solutions
  • Advanced knowledge of software applications and technical processes with considerable in-depth knowledge in one or more technical disciplines (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)
  • Ability to tackle design and functionality problems independently with little to no oversight

Nice to have

  • Modern data stack experience (e.g., Lakehouse patterns, Delta/Iceberg/Hudi)
  • Streaming/near-real-time data pipelines (e.g., Kafka, Kinesis)
  • Infrastructure as Code and automated environment provisioning (e.g., Terraform, CloudFormation)
  • CI/CD for data and analytics workloads, with automated testing and release gates
  • Observability for data pipelines (metrics, logging, lineage, data quality monitoring)
  • Containerization and orchestration (Docker, Kubernetes)
  • Experience with modern query engines and performance tuning (e.g., Spark, Trino/Presto)

What the JD emphasized

  • 5+ years of strong experience in the Business Intelligence domain
  • 5+ years of strong experience in Cloud Technologies (e.g. AWS/Azure/Google Cloud)
  • Proficient in leveraging AI technologies to enhance coding practices, including the development and deployment of intelligent agents and automation solutions