Controller Transformation Analyst

Job Description

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.

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

About the Team

Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we’re setting our businesses, clients, customers and employees up for success.