Research Modernization - Business Intelligence Developer

We are seeking a detail-oriented Business Intelligence Developer to design, build and maintain interactive dashboards and reporting solutions that drive data-informed decision-making across the organization.

As a Business Intelligence Developer within the Business Intelligence team, you will be responsible for designing, building and maintaining interactive dashboards and reporting solutions that support data-informed decision-making. You will leverage SQL/RDBMS expertise, Amazon QuickSight and Python for data transformation to deliver reliable and scalable BI solutions. You will partner with stakeholders to translate requirements into actionable BI solutions. You will also work with engineering teams to ensure data availability, quality and performance.

Job Responsibilities

• Design, develop, and maintain interactive dashboards and visualizations using Amazon QuickSight.
• Write and optimize complex SQL queries involving multiple joins and large datasets across RDBMS platforms.
• Use Python to transform, clean, and manipulate data for reporting and analytics purposes.
• Partner with stakeholders to gather requirements and translate them into actionable BI solutions.
• Ensure data accuracy, consistency, and performance across dashboards and underlying data pipelines.
• Monitor and troubleshoot dashboard/report performance issues, optimizing queries and data models as needed.
• Document data sources, query logic, and dashboard specifications for maintainability.
• Collaborate with engineering teams to ensure data availability and quality for BI use cases.

Required Qualifications, Skills and Capabilities

• 1 year of minimum experience in building Business Intelligence applications
• Strong knowledge of RDBMS (e.g., MySQL, PostgreSQL, Oracle, SQL Server) with demonstrated ability to write complex queries involving large volumes of data and multiple joins.
• Proficiency in Python for data transformation, manipulation, and automation (e.g., pandas, NumPy).
• Solid understanding of data modeling and BI best practices.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to communicate technical findings clearly to non-technical stakeholders.

Preferred Qualifications

• Experience with AWS data services (e.g., Redshift, Athena, S3, Glue).
• Familiarity with data warehousing concepts and ETL pipelines.
• Proven experience building dashboards and reports in Amazon QuickSight (or similar BI tools, with QuickSight preferred).

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 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.

J.P. Morgan’s Commercial & Investment Bank is a global leader across banking, markets, securities services and payments. Corporations, governments and institutions throughout the world entrust us with their business in more than 100 countries. The Commercial & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world.