Testing Senior Associate, SQL & Data Analysis
Overview
Join the Regulatory External Data Services team at JPMorgan Chase in Philadelphia to own end-to-end testing for critical bank filings. You will drive data quality and process optimization, directly impacting the accuracy and completeness of external data submissions. Work alongside product owners, technology developers, and data owners in a collaborative, innovation-focused environment. This role offers the chance to adopt AI tools and automate testing procedures, making a tangible difference in regulatory reporting.
What You'll Do8
- 1Execute end-to-end testing activities, including planning, execution, and reporting for external data filings.
- 2Design and implement robust test scripts with SQL to identify weaknesses in data processes.
- 3Document test steps and results meticulously, ensuring full traceability and audit readiness.
- 4Collaborate with product owners and developers to refine test cases and validate data quality.
- 5Automate repetitive testing tasks using Python or other scripting tools to boost efficiency.
- 6Analyze complex datasets using Databricks, Snowflake, or Oracle to uncover data anomalies.
- 7Present test findings and recommendations to senior stakeholders, ensuring alignment with regulatory standards.
- 8Maintain comprehensive documentation of control procedures and testing methodologies.
Requirements7
- 15+ years of experience in user acceptance testing, risk management, or control evaluation.
- 2Proficiency in SQL for complex queries and large dataset manipulation.
- 3Hands-on experience with Databricks, Snowflake, or Oracle database systems.
- 4Advanced skills in Microsoft Excel, Access, and PowerPoint.
- 5Bachelor's degree in Engineering, Business, Statistics, or Accounting.
- 6Strong analytical and communication skills, with a track record of presenting to senior leaders.
- 7Ability to manage multiple priorities in a high-stakes regulatory environment.
Salary Insight
Salary not disclosed in listing
Location
Required Skills
Similar open positions
Explore active roles that match your skills and interests.
JPMorganChase
VerifiedBusiness Analysis Associate I - Fraud Strategy & Analytics
Lead data-driven fraud detection solutions within JPMorgan Chase's Fraud Strategy and Payments Operations team. Drive fraud prevention strategies by analyzing complex datasets and proposing innovative analytical approaches. Collaborate cross-functionally to align technical initiatives with business objectives. Impact team performance through actionable insights and process improvements.
JPMorganChase
VerifiedSoftware Engineer III - Big Data, Databricks, Python/Java
You own the build-out of JPMorgan Chase's global Know Your Customer (KYC) and Risk Assessment Data Platform, processing petabytes of data at enterprise scale. You join an agile data engineering team within Corporate Technology, working on secure, stable, and scalable systems that power critical compliance decisions. Collaborate with cross-functional teams across the firm to drive best-in-class outcomes in Python, Java, and Databricks environments. Your work directly enhances a market-leading platform used by millions of consumers and top-tier institutions. This role centers on crafting durable, reusable frameworks while leveraging AI-assisted coding tools to accelerate delivery.
94-1687665 Bank of America, National Association
VerifiedSenior Data Analyst, Regulatory Reporting & Data Governance
As a Senior Data Analyst at Bank of America, you will own data validation, reconciliation, and controls for regulatory reporting across capital markets products like equities, bonds, options, and swaps. You will join the CFO Data Management team, collaborating with global business and technology partners to ensure operational data is fit for purpose. Your work directly supports accurate downstream reporting and data governance, making you a key point of contact for data compliance. This role stands out for its focus on trade-level analysis and remediation of complex data issues, offering a path to impact financial lives at scale.
JPMorganChase
VerifiedSenior Quant Analytics Associate Fraud Risk JPMorganChase
Lead development of analytical insights for point-of-sale fraud risk analytics and intelligent reporting. Build automated solutions to meet compliance standards and provide actionable intelligence to stakeholders. Drive identification of emerging fraud trends and collaborate with cross-functional teams to enhance risk mitigation strategies.
JPMorganChase
VerifiedSenior Associate, Data Science & Research
As a Senior Associate on the Morgan Health team at JPMorgan Chase, you will own the end-to-end analytics lifecycle for employer-sponsored health care data, from querying and cleaning to synthesizing insights that shape industry strategy. You will work across investments, benefits, and policy teams to design novel methodologies and data products that drive decisions at scale. This role sits at the intersection of data science and health care research, offering the chance to publish externally and influence the broader market. With 4+ years of applied analytics experience, you will collaborate with data scientists, engineers, and business leaders to solve complex problems using SQL, Python, and R.
94-1687665 Bank of America, National Association
VerifiedSr Business Control Specialist, Risk & Controls
Own the internal control environment for Client Operational Services at Bank of America, driving adherence to enterprise-wide standards and enabling Responsible Growth. You will partner with cross-functional teams across the Line of Business (LOB) to design, test, and optimize controls, ensuring operational excellence and audit readiness. This role blends governance, data evaluation, and quality assurance, with significant visibility into regulatory exams and internal audits. You will implement QA improvements and automation opportunities across multiple control processes, directly enhancing control effectiveness and reducing operational risk.