Job Description
DESCRIPTION:
Duties: Develop and create SAS, SQL code from scratch using SAS/SQL/Python or Alteryx by reviewing simple business requirements across multiple Lines of Business (LOB) including credit card, consumer and business banking, and merchant services. Work on LOB executed cases that require knowledge of Credit Card pricing, Credit Card laws and regulations and where there is limited documentation and independently work with PM, BA and LOB partners to gather the business requirements, and proof of evidence for any third party data limitations needed. Validate various types of data and multiple data sources that may need unarchiving the data from tapes, depending on assigned correction case. Write complex queries and run frequencies using SAS/SQL/ Python or Alteryx to validate population and output files. Effectively identify the issues and troubleshoot, document and communicate the findings to Business Analyst/Developer (BA) and Project Manager (PM). Document data validation plans aka test plans along with technical requirement documents (TRD). Ensure correct formatting and logic of all output files and corresponding SAS/SQL datasets that were created by the developers. Assist in the development and maintenance of the overall Data Validation strategy for the Correction function to make sure the customers harm is addressed in a timely manner. Actively engage in process adherence and improvement discussions.
QUALIFICATIONS:
Minimum education and experience required: Master's degree in Information System, Computer Engineering, or related field of study plus 2 years of experience in the job offered or Quant Analyst, Software Engineer, Business Intelligence and Analytics Analyst, or related occupation. The employer will alternatively accept a Bachelor's degree in Information System, Computer Engineering, or related field of study plus 4 years of experience in the job offered or Quant Analyst, Software Engineer, Business Intelligence and Analytics Analyst, or related occupation.
Skills Required: Requires experience in the following: developing SAS and SQL code to identify impacted data or customer; utilizing coding to confirm data and provide data validation; working with multiple lines of business or multiple functions or departments; performing calculations through a database query and posting the reports; importing external input files into SAS; analyzing business requirements; extracting data from a data warehouse; database partitioning system and how it functions; complex querying in SAS, SQL and TERADATA environment; pulling data in SQL using multiple joins, sub-queries and advanced functions in an enterprise scale database environment or Hadoop environment; Hadoop, Database development, coding best practices, QA testing and Excel; Tableau or other MIS reporting systems.
Job Location: 300 N King St, Wilmington, DE 19801. Telecommuting permitted up to 40% of the week.
About Us
Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.
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 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.
Equal Opportunity Employer/Disability/Veterans
About the Team
Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions - all while ranking first in customer satisfaction.
Top Skills
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
JPMorganChase Teams
JPMorganChase Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.