Software Engineer III- ETL/ELT Pipelines / Python / Pyspark/ AWS

Job Description

We have an exciting and rewarding opportunity for you to take your software engineering career to the next level.

As a Software Engineer III- ETL/ELT Pipelines / Python / Pyspark / AWS at JPMorganChase within the Asset and Wealth Management Technology Team, you serve as a seasoned member of an agile team to design and deliver trusted market-leading technology products in a secure, stable, and scalable way. You are responsible for carrying out critical technology solutions across multiple technical areas within various business functions in support of the firm’s business objectives.

Job responsibilities

• Design and implement scalable data solutions that align with business objectives and technology strategies and technical troubleshooting with ability to think beyond routine or conventional approaches to build and support solutions or break down technical problems
• Design, develop, and optimize robust ETL/ELT pipelines using SQL, Python, and PySpark for large-scale, complex data environments
• Develop and support secure high-quality production code, and review and debug code written by others
• Support data migration and modernization initiatives, transitioning legacy systems to cloud-based data warehouses
• Identify opportunities to eliminate or automate remediation of recurring issues to improve overall operational stability of software applications and systems
• Collaborate with cross-functional teams to understand data requirements and translate them into technical specifications
• Monitor and tune ETL processes for efficiency, resilience and scalability, including alerting for data quality issues
• Work closely with stakeholders to identify opportunities for data-driven improvements and efficiencies
• Document data flows, logic, and transformation rules to maintain transparency and facilitate knowledge sharing across teams
• Stay current on emerging ETL and data engineering technologies with industry trends to drive innovation

Required qualifications, capabilities, and skills

• Formal training or certification in software engineering with 3+ years of applied experience
• Proficient in coding in one or more languages including Python
• Strong hands-on coding proficiency in Python, PySpark, Apache Spark, SQL, and with AWS cloud services such as AWS EMR, S3, Athena, Redshift
• Hands-on experience with AWS cloud and data lake platforms, Snowflake, Databricks etc
• Proven experience in ETL/ELT pipeline development and with large-scale data processing with SQL
• Practical experience implementing data validation, cleansing, transformation, and reconciliation processes to ensure high-quality, trustworthy datasets
• Experience with cloud-based data warehouse migration and modernization
• Proficiency in automation and continuous delivery methods and understanding of agile methodologies such as CI/CD, Application Resiliency, and Security
• Excellent problem-solving and troubleshooting skills, with ability to optimize performance and troubleshoot complex data pipelines
• Strong communication and documentation abilities
• Ability to collaborate effectively with business and technical stakeholders

Preferred qualifications, capabilities, and skills

• Knowledge of Apache Iceberg
• Knowledge of the financial services industry and IT systems

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

J.P. Morgan Asset & Wealth Management delivers industry-leading investment management and private banking solutions. Asset Management provides individuals, advisors and institutions with strategies and expertise that span the full spectrum of asset classes through our global network of investment professionals. Wealth Management helps individuals, families and foundations take a more intentional approach to their wealth or finances to better define, focus and realize their goals.​

Our Asset and Wealth Management division is driven by innovators like you who are driven to create technology solutions that make us work more efficiently and help our businesses grow. It’s our mission to efficiently take care of our clients’ wealth, helping them get, and remain properly invested. Our team of agile technologists thrive in a cloud-native environment that values continuous learning using a data-centric approach in developing innovative technology solutions.