JP Morgan Chase & Co.

Regulatory External Data Services - Testing Senior Associate - SQL & Data Analysis

JP Morgan Chase & Co. • $88K — $105K *
Columbus, OH 43230In-Person
Finance & Insurance
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Engineering, Business Management, Statistics, or Accounting.
  • 5+ years of experience in user acceptance testing, risk management assessment, or a related field.
  • Experience with database management systems like Databricks, Snowflake, Oracle, or SQL Server.
  • Proficiency in Microsoft Office Suite (Word, Excel, Access, PowerPoint) and SQL for complex queries.
  • Strong analytical skills with the ability to communicate insights effectively to senior stakeholders.
  • Detail-oriented with capability to prioritize and manage multiple tasks in a fast-paced environment.

Responsibilities

  • Execute comprehensive end-to-end testing activities and report findings.
  • Ensure adherence to internal policies and testing protocols, documenting outcomes carefully.
  • Collaborate with business partners in meetings and draft detailed final test summaries.
  • Apply advanced critical thinking in conducting substantive testing.
  • Maintain compliance with firm standards and regulatory requirements throughout testing processes.
  • Support product owners in designing effective test cases for data accuracy.
  • Develop and execute test scripts to identify weaknesses and ensure data integrity.

Benefits

  • Collaborative environment in a leading financial services organization.
  • Opportunity to work with cutting-edge data and analytics technologies.
  • Exposure to diverse projects across the Consumer & Community Banking division.
  • Potential for career growth within a renowned global financial institution.
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.


Additional Information

Applicants must be authorized to work for any employer in the U.S. We are not able to provide immigration sponsorship or take over sponsorship of an employment Visa at this time. Final Job Grade level and corporate title will be determined at time of offer and may differ from this posting. This role does not provide relocation assistance so all candidates must be local to the work locations listed in the job posting or willing to relocate on their own immediately upon hiring.

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
Finance & Insurance
Net Income
$29.1 billion
Founded
1823
5 Year Trend
+0.7%
Revenue
$261.5 million
NASDAQ
CCF
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at JP Morgan Chase & Co.

More Finance & Insurance Jobs

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

NationwideColumbus, OH