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 directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans