Software Engineer II Business Intelligence - Oracle

You’re ready to gain the skills and experience needed to grow within your role and advance your career — and we have the perfect software engineering opportunity for you.

As a Software Engineer II Business Intelligence at JPMorgan Chase within the Corporate & Investment Bank - Reporting and Regulatory team, you will play a pivotal role in an agile team tasked with the enhancement, design, and delivery of software components for our advanced technology products. Your responsibilities will include the execution of software solutions through the design, development, and troubleshooting of various elements within a technical product, application, or system. This role offers a great opportunity to acquire valuable skills and experience to advance your development within your position.

Job responsibilities

• Executes standard software solutions, design, development, and technical troubleshooting
• Writes secure and high-quality code using the syntax of at least one programming language with limited guidance
• Designs, develops, codes, and troubleshoots with consideration of upstream and downstream systems and technical implications
• Applies knowledge of tools within the Software Development Life Cycle toolchain to improve the value realized by automation
• Applies technical troubleshooting to break down solutions and solve technical problems of basic complexity
• Gathers, analyzes, and draws conclusions from large, diverse data sets to identify problems and contribute to decision-making in service of secure, stable application development
• Learns and applies system processes, methodologies, and skills for the development of secure, stable code and systems
• Adds to team culture of diversity, equity, inclusion, and respect

Required qualifications, capabilities, and skills

• Formal training or certification on ETL process design and development concepts and 2+ years applied experience
• Strong knowledge in designing, developing, optimizing, and maintaining ETL processes for operational and analytical applications.
• Highly proficient in writing complex SQL statements and interpreting results for accuracy and performance. 
• Work with Business and Operations to gather requirements and business process knowledge to design, transform the data and deliver high quality data. 
• Hands-on experience working with Oracle DB
• Experience with Jenkins CI/CD, Git, Maven
• Hands-on practical experience in system design, application development, testing, and operational stability
• Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages
• Demonstrable ability to code in one or more languages
• Experience across the whole Software Development Life Cycle
• Emerging knowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)

Preferred qualifications, capabilities, and skills

• Knowledge of ETL - Pentaho Data Integration (PDI) tool and familiarity with Unix shell scripting
• BI Analytical experience and Reporting Tools: IBM Cognos, Tableau and Alteryx
• Familiar with Investment Banking domain and equity derivatives. 
• Familiarity with API development experience and AWS platforms such as S3, Athena, RedShift, and Glue

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