Controller Transformation Analyst

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 profici...