Data Engineer III

Be part of a dynamic team where your distinctive skills will contribute to a winning culture and team. 

As a Data Engineer III at JPMorgan Chase within the Audit Technology, you serve as a seasoned member of an agile team to design and deliver trusted data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. You are responsible for developing, testing, and maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm’s business objectives.   We are building the next generation of applications through a multi-year technology transformation that will automate the audit flows into best in class technologies and frameworks, delivering an improved user experience. We are looking for hands on Data Management experts and Oracle PL/SQL developers who will be responsible for design and development of business critical enterprise applications using Oracle, SQL, PL/SQL, Shell Scripts and Scheduling frameworks.

Job responsibilities

• Supports review of controls to ensure sufficient protection of enterprise data
• Advises and makes custom configuration changes in one to two tools to generate a product at the business or customer request
• Updates logical or physical data models based on new use cases
• Frequently uses SQL and understands NoSQL databases and their niche in the marketplace
• Adds to team culture of diversity, equity, inclusion, and respect
• Design, build, deploy and maintain software applications for Internal Audit functions in close collaboration with our business/customer stakeholders.
• Contribute towards technical business analysis to enrich the requirements produced by business and product owners.
• Ensure focus on excellent data architecture, data management principles and system performance.
• Research new technologies, create proof of concepts, identify best practices, adapt quickly and provide technical guidance to other team members

 

Required qualifications, capabilities, and skills

• BS/BA university degree, specialized training or equivalent work experience.
• 8 years of Experience across the data lifecycle.
• 5+ years of strong experience with data management activities, that includes : Relational and Dimensional data modeling, SQL querying, DB / Query Performance Tuning, hands on development using PL / SQL, experience in writing Oracle Packages, Stored procedures, Functions, Triggers, including working with scheduling tools like Autosys.
• Advanced Knowledge at SQL (e.g., joins and aggregations)
• Working understanding of NoSQL databases
• Significant experience with statistical data analysis and ability to determine appropriate tools and data patterns to perform analysis
• Database Management skills including Data Analysis & Comparison, Data Quality Management, Reference and Master Data Management.
• Excellent knowledge of DB technologies including Oracle, Autosys, Shell Scripting and writing complex queries using SQL.
• Practical experience with unit testing and troubleshooting PL/SQL code.
• Experience with Oracle system tables, Data Privacy, Access and Security

Preferred qualifications, capabilities and skills 

• Familiarity and experience with Data Lakes, Data Lakehouses (Databricks), ETL, Data Mesh, AI / ML Concepts, LLM etc.
• Knowledge of Data warehousing and Business Intelligence concepts.
• Hands on experience in working with tools like ERWIN, Oracle SQL Developer, TOAD etc.
• Cloud - Experience with both Private and Public clouds.
• Knowledge on cloud-based application architectures, micro services, and distributed systems.
• Knowledge of build tools, source control like Git/Bitbucket with CI/CD.

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 car