Software Engineer III - Athena Python, Databricks, SQL and Reporting
JPMorganChase
We are seeking a highly skilled Associate-level developer to join our Risk Reporting development team, specializing in Athena Python and Databricks SQL. The ideal candidate will have a strong background in Python and SQL, with proven experience in developing and performance tuning major SQL dialects (such as Oracle). Experience with third-party SQL-based reporting platforms (e.g., Cognos, Tableau) is a plus.
This role focuses on sourcing data from various internal to Market Risk and Firmwide systems, integrating it into robust reporting solutions, and applying controls to ensure the accuracy and reliability of risk data used in reporting. The successful candidate will demonstrate the ability to think beyond routine approaches, proactively identify hidden problems, and contribute to a culture of innovation and inclusion.
Job responsibilities
- Design, develop, and maintain risk reporting solutions using Athena Python and Databricks SQL.
- Optimize and tune SQL queries for performance, scalability, and reliability.
- Collaborate with risk analysts and business stakeholders to gather requirements and deliver robust reporting solutions.
- Integrate and automate data pipelines for risk data aggregation and reporting.
- Troubleshoot and resolve issues related to data quality, performance, and reporting accuracy.
- Document technical solutions and provide knowledge transfer to team members.
Required qualifications, capabilities, and skills
- Bachelor’s degree in Computer Science, Engineering, or related field.
- Strong proficiency in Python, with experience in data processing and automation.
- Extensive experience in SQL, including development and performance tuning in at least one major SQL dialect (e.g., Oracle, SQL Server, PostgreSQL).
- Hands-on experience with Athena and Databricks SQL environments.
- Solid understanding of data modeling, ETL processes, and reporting best practices.
- Experience with third-party SQL-based reporting platforms such as Cognos or Tableau.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration abilities
Preferred qualifications, capabilities, and skills
- Familiarity with risk management concepts and financial data.
- Experience working in Agile development environments.
- Knowledge of cloud data platforms (e.g., AWS, Azure).
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
Associate-level developer to join our Risk Reporting development team, specializing in Athena Python and Databricks SQL