JP Morgan Chase & Co.

Testing Senior Associate - SQL & Data Analysis

JP Morgan Chase & Co. • $95K — $115K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Engineering, Business Management, Statistics, or Accounting.
  • 5+ years in user acceptance testing, risk management assessment, or related field.
  • Experience with database management systems like Databricks, Snowflake, Oracle, or SQL Server.
  • Proficient in Microsoft Office Suite including Word, Excel, Access, and PowerPoint.
  • Strong SQL skills for complex queries on large datasets.
  • Ability to analyze issues and communicate insights to senior stakeholders effectively.
  • Detail-oriented with skills in managing multiple priorities in fast-paced environments.

Responsibilities

  • Execute end-to-end testing activities, including planning and reporting.
  • Ensure compliance with internal policies and document testing results meticulously.
  • Collaborate with business partners in meetings to draft comprehensive test summaries.
  • Utilize critical thinking to apply substantive testing techniques.
  • Adhere to regulatory requirements and industry best practices.
  • Support product owners in designing effective test cases.
  • Automate testing procedures and adopt innovative technologies.

Benefits

  • Comprehensive healthcare plans
  • 401(k) plan with company match
  • Generous paid time off
  • Professional development opportunities
  • Potential for remote work options
Full Job Description
Job Description

As a Senior Associate in the Regulatory External Data Services team, you will be entrusted with upholding the highest standards of data accuracy, completeness, and transparency, which is mission-critical to JPMorgan Chase External Reporting Controllers. Your role will be pivotal in executing the testing process to ensure reporting is materially accurate, complete, and timely for external data filings. You will be tasked with developing and executing the testing cases, as well as maintaining documentation and control procedures. You will ensure successful testing by collaborating closely with product owners, and technology developers, and data owners.

Job responsibilities
  • Execute end-to-end testing activities, including planning and reporting.
  • Ensure compliance with internal policies and procedures including executing testing procedures, meticulously documenting results, drawing informed conclusions.
  • Participate in business meetings to collaborate with business partners which includes drafting comprehensive final test summaries to ensure alignment and clarity.
  • Utilize advanced critical thinking skills to apply substantive testing techniques and
  • Adhere to firm standards, regulatory requirements, and industry best practices.
  • Collaborate with product owners to support the design and effectiveness of test cases.
  • Develop and execute robust test scripts aimed at identifying weaknesses.
  • Document test steps and results in a comprehensive and organized manner, ensuring sufficient support and justification for testing conclusions.
  • Maintain a high standard of documentation to facilitate transparency, traceability, and accountability.
  • Automate testing procedures wherever possible and proactively adopt AI tools and technologies, in alignment with firm expectations for innovation and efficiency.

Required qualifications, capabilities, and skills
  • Bachelor's degree in Engineering, Business Management, Statistics, Accounting.
  • 5+ years of experience or equivalent expertise in user acceptance testing, risk management assessment, control evaluations, or a related field.
  • Experience with database management systems (e.g., Databricks, Snowflake, Oracle, SQL Server, etc.).
  • Proficiency in MS (Microsoft Suite) Office such as Microsoft Word, Excel, Access, and PowerPoint.
  • Proficiency with SQL (complex queries and working with large datasets).
  • Demonstrated ability to analyze issues, develop and implement effective risk mitigation strategies, and communicate insights and recommendations clearly to senior stakeholders.
  • Ability to develop and communicate recommendations based on regulatory guidance and standards, ensuring alignment with organizational goals and compliance requirements.
  • Organized and detail-oriented, with the ability to manage multiple priorities and deliver results in a fast-paced environment.
  • Strong analytical and communication skills, with the ability to convey information in a clear and concise manner.

Preferred qualifications, capabilities, and skills
  • Experience within the financial services industry.
  • A background in auditing and the ability to understand of internal controls is beneficial.
  • Knowledge of data analytical tools such as Tableau, Alteryx or Python is a plus.
  • Experience with cloud-based data solutions (e.g., AWS, Azure, Google Cloud).
  • Experience with Java.


To be eligible for this role, you must be authorized to work in the United States. We do not offer any type of employment-based immigration sponsorship for this role. Likewise, JPMorgan Chase & Co. will not provide any assistance or sign any documentation in support of any other form of immigration sponsorship or benefit, including optional practical training (OPT) or curricular practical training (CPT).

About the Team

Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions - all while ranking first in customer satisfaction.

The CCB Data & Analytics team responsibly leverages data across Chase to build competitive advantages for the businesses while providing value and protection for customers. The team encompasses a variety of disciplines from data governance and strategy to reporting, data science and machine learning. We have a strong partnership with Technology, which provides cutting edge data and analytics infrastructure. The team powers Chase with insights to create the best customer and business outcomes.

About JP Morgan Chase & Co.

JP Morgan Chase & Co. stands at the forefront of the global financial services industry. They offer an expansive array of products and services to a diverse clientele, including individuals, corporations, governments, and institutions. Ever since the merger of J.P. Morgan & Co. and Chase Manhattan Corporation in 2000, this industry-leading entity has become renowned for its comprehensive portfolio encompassing consumer and community banking, corporate and investment banking, commercial banking, as well as asset and wealth management. Headquartered in the vibrant city of New York, JP Morgan Chase & Co. boasts a formidable presence across over 100 countries worldwide.

Unveiling Employment Opportunities at JP Morgan Chase & Co.

Vacancies and Hiring Initiatives

JP Morgan Chase & Co. is continuously on the lookout for talented individuals eager to contribute to its legacy of excellence. The company's recruitment efforts are geared towards identifying candidates with the right blend of skills and qualifications to drive forward its various business segments. Whether you are a seasoned professional or a recent graduate, JP Morgan Chase offers a plethora of job openings across multiple disciplines.

High-Demand Positions

Among the myriad of roles, certain positions stand out for their attractive compensation packages and career advancement prospects. Notably, high-paying jobs at JP Morgan Chase & Co. include Relationship Manager, Branch Manager, and Software Engineer. These roles are critical to the firm's operations and offer lucrative opportunities for those with the requisite expertise.

Navigating the Job Market at JP Morgan Chase & Co.

Leveraging Job Portals and Job Alerts

For job seekers aiming to tap into the opportunities at JP Morgan Chase, staying updated through job portals and subscribing to job alerts is crucial. These tools can provide timely information about job openings, job fairs, and recruitment events, enabling candidates to apply promptly and prepare adequately for interviews.

Preparing Your Job Application

Your job application, comprising your resume and cover letter, is your ticket to securing an interview at JP Morgan Chase. Highlight your qualifications, skills, and experiences that align with the job listing, ensuring you stand out in the competitive job market.

Acing the Interview

Preparation is key to succeeding in your interview with JP Morgan Chase. Familiarize yourself with the company's business segments, values, and recent achievements. Demonstrating how your background and aspirations match the company's goals can significantly increase your chances of employment. A World of Job Opportunites in the Financial Services Industry JP Morgan Chase & Co. offers a world of job opportunities for those seeking to make their mark in the financial services industry. With competitive salaries, comprehensive benefits, and endless possibilities for growth, positions at JP Morgan Chase are highly coveted. By staying informed through job sites, tailoring your applications, and preparing thoroughly for interviews, you can enhance your prospects of joining the esteemed ranks of JP Morgan Chase employees. Explore the job board, seize the job opportunities, and embark on a rewarding career journey with one of the world's leading financial institutions.
Learn more about JP Morgan Chase & Co.
Size
661 employees
Market Cap
$384.5 billion
Industry
Net Income
$29.1 billion
Founded
1823
5 Year Trend
+0.7%
Revenue
$261.5 million
NASDAQ

Similar Jobs

More Jobs at JP Morgan Chase & Co.

More Information Technology Jobs

Find similar Testing Senior Associate - SQL & Data Analysis jobs: