What are the responsibilities and job description for the Software Engineer II - Database Developer/BI Analyst position at JPMorgan Chase?
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 at JPMorganChase within the Corporate Sector, you are part of an agile team that works to enhance, design, and deliver the software components of the firm’s state-of-the-art technology products in a secure, stable, and scalable way. As an emerging member of a software engineering team, you design, build, and optimize data solutions that drive actionable insights, while gaining the skills and experience needed to grow within your role.
Job Responsibilities
- Design and optimize scalable data models, ETL/ELT pipelines, and stored procedures for analytics and reporting
- Build robust SQL across OLTP/OLAP systems; tune queries, indexes, and execution plans for performance
- Develop BI dashboards and reports; translate business questions into metrics, KPIs, and visualizations
- Partner with product and operations to define data requirements, ensure quality, and deliver self-serve insights
- Implement data validation, lineage, and documentation; uphold governance and best practices
- Conduct exploratory analysis to identify trends, anomalies, and drivers; present clear, actionable findings
Required qualifications, capabilities, and skills
- Formal training or certification on software engineering and database concepts and 3 years applied experience
- Advanced SQL and database engineering (e.g., performance tuning, partitioning, indexing, query optimization)
- Experience with ETL/ELT tools and scripting (e.g., Python, shell) and data warehousing concepts.
- BI development with at least one enterprise visualization tool
- Strong understanding of data modeling (star/snowflake), metadata, and KPI design
- Excellent stakeholder communication and the ability to translate business needs into technical solutions
Preferred qualifications, capabilities, and skills
- Experience with ServiceNow data model/domain knowledge (tables, CMDB, incidents/changes/problems)
- Proficiency with Tableau expertise (LOD expressions, performance optimization, data blending).
- Experience with Cloud data platforms (e.g., Snowflake, Databricks) and version-controlled analytics workflows (Git, CI/CD)