SQL Developer - Associate

Job Description

You are a strategic thinker passionate about driving solutions in Regulatory Reporting. You have found the right team.

As a Regulatory Reporting Test Associate within the Finance team, you will focus on ensuring the accuracy and compliance of regulatory reports submitted to governing bodies. You will test, analyze, and remediate issues within the reporting process, collaborating with technology teams to automate and improve processes. You will identify and escalate potential risks, ensuring the integrity of the reporting framework. You will work independently, thrive in a fast-paced environment, handle multiple projects, and communicate effectively with all levels of management.

Job Responsibilities

• Development of test documentation to include Test plans, Test schedules and test cases/scripts
• Collaborate with business analysts, developers, and other stakeholders to understand regulatory requirements and translate them into test scenarios. Review project documents to understand requirements, data, and desired outcome
• Regularly report status to Controls/Test Manager for consolidated status reporting.
• Perform data validation and reconciliation to ensure the accuracy and completeness of regulatory reports.
• Identify, document, and track defects and issues, and work with stakeholders to resolve them.
• Participate in the review and analysis of regulatory changes and assess their impact on reporting processes.
• Support the implementation of automated testing tools and frameworks to enhance testing efficiency.
• Maintain detailed documentation of testing activities, results, and issues for audit and compliance purposes.
• Assist in the preparation and submission of regulatory reports as needed.
• Serve as a subject matter expert and participate in Go/No Go decisions
  
  

Required Qualifications, Capabilities, And Skills

• Bachelor's degree in Finance, Accounting, Information Technology, or a related field
• Minimum 5+ years of experience with planning and coordinating test activities, overseeing test case development and defect resolution.
• Advance knowledge of testing/application development workflow tools HP Quality Center/qTest
• Strong analytical skills and attention to detail.
• Familiarity with regulatory requirements and reporting standards.
• Proficiency in data analysis and validation techniques.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a team.
• Experience working in manual & automated testing
• Working knowledge in writing complex SQL queries joining multiple tables
• Ability to present effectively to both business and technical audiences at all levels of the organization
  
  

Preferred Qualifications, Capabilities, And Skills

• Experience in regulatory reporting, testing, or a related area is preferred.
• Working knowledge of Tableau and Python is a plus
• Experience with Jira/Agile Central.
• Experience in working with large datasets, derive insights and present information through visualization and reports.
  
  

ABOUT US

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.

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.