Data Engineering Associate
JPMorgan Chase4 days ago
Responsibilities
- Design, develop, and deliver scalable software and data engineering solutions aligned with business and technical requirements.
- Build and optimize Databricks ETL/ELT pipelines, including performance tuning, partitioning, file sizing, and incremental loads.
- Create and maintain data models, database schemas, SQL queries, and Oracle PL/SQL procedures, functions, and packages.
- Handle JSON and semi-structured data across ingestion, transformation, and serving layers.
- Contribute to software development lifecycle activities including design, coding, testing, deployment, debugging, documentation, and peer reviews.
- Support continuous integration and continuous delivery pipelines and participate in planning, estimation, and retrospectives.
- Work with Databricks Genie Spaces and ThoughtSpot integration to Databricks.
- Use enterprise-authorized AI-assisted development tools while validating generated outputs for correctness, performance, security, and data sensitivity.
- Collaborate with product, architecture, operations, and other cross-functional teams to resolve technical issues and improve engineering practices.
Requirements
- Formal training or certification in software engineering concepts and 3+ years of applied experience.
- Strong data modeling experience using ERwin, including normalization and dimensional modeling.
- Hands-on Databricks data engineering experience building and optimizing ETL/ELT pipelines.
- Strong SQL proficiency, including joins, analytic and window functions, and query optimization.
- Strong Oracle experience with DDL/DML, schema design, PL/SQL, execution plans, indexes, partitioning, and statistics.
- Experience parsing, flattening, and managing schema evolution for JSON and semi-structured data.
- Experience with Databricks Genie Spaces and ThoughtSpot integration to Databricks.
- Experience with Git-based workflows using Bitbucket and/or GitHub and familiarity with IntelliJ IDEA or similar IDEs.
- Strong debugging and problem-solving skills across ingestion, transformation, and serving layers.
- Hands-on experience with enterprise-authorized AI-assisted software development tools and the ability to critically evaluate and refine their outputs.
- Understanding of responsible AI use, data sensitivity, secure input/output handling, resiliency, and security expectations.
- Preferred experience administering Unity Catalog, including catalog and schema design, permissions, lineage, and metadata patterns.
- Preferred exposure to Docker or Kubernetes, CI/CD tooling, DevOps practices, and financial services or regulated environments.
Benefits
- Competitive total rewards package with base salary determined by role, experience, skill set, and location.
- Eligible roles may receive commission-based pay or discretionary incentive compensation in cash and/or forfeitable equity.
- Benefits may include comprehensive health care coverage, on-site health and wellness centers, retirement savings, backup childcare, tuition reimbursement, mental health support, and financial coaching.
- Equal opportunity employer with reasonable accommodation support for religious practices, mental health needs, and physical disabilities.
Tech Stack
Categories
Data Engineering
About JPMorgan Chase
JPMorgan Chase provides consumer and commercial banking, payments, credit card, wealth management, and corporate and investment banking services to individuals, businesses, institutions, and governments. The public company (NYSE: JPM) earns revenue from interest, fees, trading, and asset management across operations in more than 100 markets. Headquartered in New York City with roots dating to 1799, it serves retail customers and prominent corporate and government clients through brands including Chase and J.P. Morgan.