Description

Join a modernization-focused team automating reporting and building scalable data products. Lead high-visibility BI and ETL delivery while shaping cloud migration patterns to AWS. Partner closely with stakeholders to create reliable, well-governed insights with real operational impact.

As an Associate within Operations Automation, you lead the automation and optimization of reporting workflows and deliver scalable, low-touch ETL/data integration solutions. You translate business needs into governed BI products, balancing strategic modernization with hands-on execution. You drive migration of legacy/manual processes and data workflows from on-premises platforms to AWS.

Job Responsibilities

• Own end-to-end delivery of BI and ETL initiatives across requirements, design, build, test, deploy, and production support.
• Lead stakeholder engagement by managing expectations, driving decisions, providing status updates, and escalating risks/issues.
• Design robust Pentaho ETL workflows optimized for reliability, performance, reusability, and maintainability.
• Develop Qlik Sense/Tableau dashboards, reporting layers, and automated refresh/validation routines.
• Drive on-prem to AWS workflow migration by recommending target-state patterns and optimizing for cloud operations.
• Implement documentation standards including process flows, runbooks, and data definitions, keeping artifacts current.
• Perform advanced SQL development and query performance tuning using T-SQL and/or PL/SQL.
• Deliver ad-hoc data analysis and production support with strong reconciliation and data integrity checks.
• Identify process gaps, control/risk issues, and automation opportunities, proposing solutions with measurable impact.
• Coordinate cross-functionally to meet deliverables and support change management for new reporting requirements.
• Mentor junior team members through code/design reviews, knowledge sharing, and engineering best practices.

Required qualifications, capabilities and skills

• Bring at least 8 years of hands-on experience in ETL development and BI/reporting delivery.
• Demonstrate strong experience with Oracle and/or SQL Server in enterprise environments.
• Apply advanced SQL and query optimization skills in T-SQL and/or PL/SQL to troubleshoot complex data issues.
• Build BI solutions using Qlik Sense and/or Tableau, including dashboard development and data validation.
• Execute on-premises to AWS migration for data workflows with attention to design, operations, and risk controls.
• Use Unix/Linux effectively, including shell scripting to automate and schedule workflows.
• Deliver strong ownership and execution skills while communicating clearly with technical and non-technical stakeholders.

Preferred qualifications, capabilities and skills

• Use Python for automation, data processing, and tooling.
• Leverage experience implementing CI/CD and release controls for ETL/BI assets.
• Apply knowledge of cloud-native AWS services to improve monitoring, resiliency, and cost efficiency.
• Strengthen data governance through metadata, lineage, and data quality controls.
• Optimize performance across ETL, database, and BI layers using systematic tuning approaches.
• Automate operational checks, reconciliations, and alerting to enable low-touch production support.
• Contribute domain expertise from financial services or consulting to translate business needs into scalable solutions.

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

J.P. Morgan's Commercial & Investment Bank is a global leader across banking, markets, securities services and payments. Corporations, governments and institutions throughout the world entrust us with their business in more than 100 countries. The Commercial & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world.