Are you passionate about modernizing critical financial processes through technology and automation? Join the Reconciliation & Analysis Modernization team within the Controller Transformation Office, where you will help redesign and re-engineer how JPMorganChase reconciles, validates, and analyzes financial data at scale. This is your opportunity to build cutting-edge data solutions that drive measurable improvements in efficiency, transparency, and control across the firm.
As a Reconciliation & Analysis Modernization Analyst within the Controller Transformation Office, you will design, develop, and partner with engineering to deploy data pipelines, automated reconciliation logic, and analytical solutions using Databricks, Python, and SQL. You will partner closely with Controllers, Technology, and Operations stakeholders to migrate legacy reconciliation processes onto modern, scalable platforms. Your role will involve translating complex business requirements into robust technical solutions, ensuring data quality and accuracy, and driving measurable improvements in efficiency, transparency, and control. You will thrive in an environment that values technical rigor, intellectual curiosity, and a relentless focus on operational excellence.
Job Responsibilities
- Design, build, and maintain automated reconciliation and analysis workflows using Databricks, Python, and SQL to replace manual and legacy processes.
- Develop scalable data pipelines and transformation logic within the Databricks Lakehouse environment to support high-volume financial data processing.
- Write clean, well-tested Python code to automate break identification, root cause analysis, and exception reporting across reconciliation processes.
- Author and optimize complex SQL queries for data extraction, validation, and reconciliation across multiple source systems and ledgers.
- Collaborate with Controllers, Technology partners, and business stakeholders to gather requirements and translate them into technical design specifications.
- Perform data profiling, quality assessment, and remediation to ensure accuracy and completeness of reconciliation outputs.
- Build and automate dashboards, reporting, and monitoring solutions to provide transparency into reconciliation health and aging metrics.
- Support the migration of existing reconciliation processes from legacy tools onto the target-state Databricks platform, ensuring functional equivalence and control integrity.
- Participate in Agile ceremonies and contribute to sprint planning, backlog grooming, and iterative delivery of platform capabilities.
- Document technical designs, data lineage, and process flows to support auditability and knowledge transfer.
- Drive continuous improvement by identifying opportunities to enhance automation coverage, reduce manual touchpoints, and improve cycle times.
Required Qualifications, Capabilities, and Skills
- Demonstrate proficiency in SQL, including complex joins, window functions, CTEs, and performance optimization across large datasets.
- Apply data engineering concepts including ETL/ELT design patterns, data modeling, data quality frameworks, and pipeline orchestration effectively.
- Reconcile discrepancies programmatically across large, complex datasets spanning multiple source systems.
- Analyze complex problems with exceptional attention to detail and a strong commitment to data accuracy.
- Communicate technical concepts clearly to non-technical stakeholders and collaborate effectively across cross-functional teams.
- Manage multiple priorities simultaneously and deliver against tight deadlines in a fast-paced environment.
- Demonstrate working knowledge of Python for data manipulation, automation, and pipeline development in a collaborative engineering setting.
Preferred Qualifications, Capabilities, and Skills
- Experience in financial services, particularly within Controllership, Finance, or Operations functions involving reconciliation, subledger-to-general ledger analysis, or financial controls.
- Familiarity with banking products and accounting concepts such as Loans, Deposits, Derivatives, Securities, or Cash.
- Experience with Agile delivery methodologies and tools including JIRA and Confluence.
- Exposure to cloud platforms such as AWS in conjunction with Databricks.
- Experience with software development best practices in a collaborative engineering environment.
- Knowledge of data governance, lineage, and metadata management practices and passion for continuous learning, emerging technologies, and driving meaningful process transformation.
- Familiarity with data visualization & low code solution tools (e.g. Tableau, Alteryx, Sigma) for building operational dashboards.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
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.
JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans
Skills Required
- Proficiency in SQL, including complex joins, window functions, CTEs, and performance optimization across large datasets
- Knowledge of data engineering concepts, including ETL/ELT design patterns, data modeling, data quality frameworks, and pipeline orchestration
- Ability to reconcile discrepancies programmatically across large, complex datasets spanning multiple source systems
- Exceptional analytical and problem-solving skills with strong attention to detail and commitment to data accuracy
- Ability to communicate technical concepts clearly to non-technical stakeholders and collaborate cross-functionally
- Ability to manage multiple priorities and deliver against tight deadlines in a fast-paced environment
- Working knowledge of Python for data manipulation, automation, and pipeline development
- Experience in financial services, particularly Controllership, Finance, or Operations functions involving reconciliation, subledger-to-general-ledger analysis, or financial controls
- Familiarity with banking products and accounting concepts, including loans, deposits, derivatives, securities, or cash
- Experience with Agile delivery methodologies and JIRA and Confluence
- Exposure to AWS used with Databricks
- Experience with software development best practices in a collaborative engineering environment
- Knowledge of data governance, lineage, and metadata management practices
- Familiarity with Tableau, Alteryx, or Sigma for operational dashboards
JPMorganChase Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about JPMorganChase and has not been reviewed or approved by JPMorganChase.
-
Healthcare Strength — Medical, dental, vision, and mental-health coverage are broad, with wellness incentives, on-site or virtual care, and an EAP offering coaching and counseling. Plan materials emphasize accessible options, including multiple medical choices and tools to manage costs.
-
Parental & Family Support — Paid parental leave extends up to 16 weeks for all parents, supplemented by paid Critical Caregiver Leave. Family resources include backup childcare via Bright Horizons, lactation support and milk-shipping, family-building assistance, and even a free five-month SNOO rental for newborns.
-
Retirement Support — Retirement programs include a 401(k) with an annual company match and automatic pay credits for most employees, with a legacy pension available to earlier hires. An Employee Stock Purchase Plan at a 5% discount further supports long-term savings.
JPMorganChase Insights
Similar Jobs
What We Do
JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $3.7 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United States and many of the world’s most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands. Technology fuels every aspect of our company and is at the heart of everything we do. With over 50,000 technologists globally and an annual tech spend of $12 billion, we are dedicated to improving the design, analytics, development, coding, testing and application programming that goes into creating high quality software and new products. Learn more about technology at our firm, explore resources from our Distinguished Engineers, AI & ML researchers, and other experts; access the latest episode of our TechTrends podcast, and more at www.jpmorgan.com/technology. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com. ©2023 JPMorgan Chase & Co. All rights reserved. JPMorgan Chase is an Equal Opportunity Employer, including Disability/Veterans.
Why Work With Us
Our technologists work on a diverse range of solutions that include strategic technology initiatives, big data, mobile, electronic payments, machine learning, cybersecurity, enterprise cloud development, and other state-of-the-art technologies.
Gallery
