JP Morgan Chase & Co.

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

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

Qualifications

  • Bachelor’s degree in Engineering, Business Management, Statistics, or Accounting.
  • 5+ years of user acceptance testing or risk management experience.
  • Experience with database management systems like Databricks, Snowflake, Oracle, or SQL Server.
  • Proficient in Microsoft Office Suite, particularly Excel, PowerPoint, and Access.
  • Strong SQL skills, including complex queries and handling large datasets.
  • Demonstrated ability to analyze and mitigate risks, communicating effectively with senior stakeholders.
  • Organized and detail-oriented with strong multitasking capabilities.

Responsibilities

  • Execute end-to-end testing activities, covering planning to reporting.
  • Ensure compliance with internal policies through meticulous documentation of testing procedures.
  • Collaborate with business partners in meetings, drafting comprehensive test summaries.
  • Apply critical thinking skills to implement substantive testing techniques.
  • Adhere to regulatory standards and best practices in all testing activities.
  • Work with product owners to design effective test cases.
  • Develop and execute test scripts to identify system weaknesses.
  • Maintain high documentation standards for transparency and accountability.

Benefits

  • Collaborative and innovative work environment.
  • Opportunities for professional development and career growth.
  • Exposure to advanced data technologies and testing methodologies.
  • Access to a strong support network within a prestigious 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

  • Bachelors 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 ableto 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 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 Finance & Insurance Jobs

  • Accounting Manager
    St. Mary Development Corporations
    Dayton, OH 45402 (Montgomery County)
  • Controller
    $110K — $120K *
    I & A Recruiting
    Crystal Lake, IL 60014 (Mchenry County)
  • Partner
    $200K — $500K+*
    Confidential Company
    Los Angeles, CA 90001 (Los Angeles County)
  • Hub International Limited
    Producer, Vice President
    $85K — $150K *
    Hub International Limited
    Santa Barbara, CA 93101 (Santa Barbara County)
  • Financial Reporting Manager
    $80K — $95K *
    Episcopal Retirement Services
    Cincinnati, OH 45238 (Hamilton County)

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