Data Engineer III - ETL
JPMorgan Chase8 days ago
Base Salary
$119k - $160k/yr
Responsibilities
- Review controls to help protect enterprise data and meet security, resiliency, traceability, and auditability expectations.
- Develop, test, deploy, optimize, and maintain production ETL/ELT data pipelines and architectures.
- Update logical and physical data models for new use cases.
- Use SQL and work with Oracle and NoSQL databases, including performance tuning, schema design, partitioning, indexing, and statistics.
- Integrate Databricks Genie Spaces with ThoughtSpot and support data analysis and product configuration requests.
- Handle JSON and semi-structured data, including parsing, flattening, and schema evolution.
- Use Git-based workflows and validate AI-assisted queries, tests, documentation, and model-change summaries before use.
Requirements
- Formal training or certification in data engineering concepts and at least 3 years of applied data engineering experience.
- Demonstrated experience developing and deploying business-critical production data pipelines across the data lifecycle.
- Hands-on ETL/ELT experience, including performance tuning, partitioning, file sizing, and incremental loads.
- Advanced SQL proficiency, including joins, analytical and window functions, and query optimization.
- Experience with Databricks Genie Spaces, ThoughtSpot integration with Databricks, and strong Oracle development and performance-tuning skills.
- Experience with JSON and semi-structured data, Git workflows using Bitbucket or GitHub, and IntelliJ IDEA or a similar IDE.
- Strong debugging and problem-solving skills across ingestion, transformation, and serving layers.
- Experience with statistical data analysis and selecting appropriate tools and data patterns for analysis and product customization.
- Preferred experience administering Unity Catalog, including catalog and schema design, permissions, lineage, and metadata.
- Preferred understanding of data lake, data mesh, and lakehouse architectures; exposure to Docker or Kubernetes; familiarity with CI/CD and DevOps practices; and financial-services or regulated-industry experience.
Benefits
- Competitive total rewards package with benefits determined by eligibility, role, experience, skill set, and location.
- Health care coverage, on-site health and wellness centers, retirement savings plan, backup childcare, tuition reimbursement, mental health support, and financial coaching.
- Eligible roles may receive commission-based pay or discretionary incentive compensation, including cash or forfeitable equity.
- Equal opportunity employer providing reasonable accommodations 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.