Associate - Data Analytics (Sas & SQL)

**JOB DESCRIPTION** Job Summary**:
Audience Targeting partners with the Marketers to gather requirements, propose a design for targeting, segmentation and execute on the delivery of final audience. The team is also responsible for the development of code for data extraction and transformation, and deploying the audience into production.

This role involves performing Business Analysis and Database Marketing functions for the execution of complex portfolio marketing campaigns and projects, using Base SAS programming and SQL querying.

**Job Responsibility**:
**Domains supported**: Home Lending, Retail Banking
- Responsible for the development and execution of code to define customer populations to be targeted in complex marketing campaigns.
- Responsible for design of functional specification document used for execution of the campaigns
- Daily interactions with Marketers & project stakeholders on multiple projects - required to communicate and clarify requirements, results, and timelines
- Requires the ability to assess information extracted from multiple data sources, resolve inconsistencies, and transform high-level information into a detailed technical specification document.
- Adhere to process adherence requirements and checkpoints for campaign execution
- Develop code based on technical specifications to extract and process large volumes of customer and account data.
- Adhere to the department’s code development and documentation procedures. Provide recommendations and feedback on how to improve or implement strong control procedures.
- Provide support on Adhoc requests and special projects as assigned.

**Required Qualifications, Skills and Capabilities**:

- 5+ years extensive experience in developing Base SAS codes for manipulating large amounts of data and creating reports using procedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary as well as traditional SAS data step programming.
- Experience as Business Analyst in related domains
- Experience in requirement gathering and interacting with off-shore partners
- Experience in database querying (Oracle/Teradata)
- A background in marketing operations, direct marketing or data analysis.
- Strong analytical skills demonstrated by previous work experiences.
- Familiarity or experience in operations, direct marketing, and data analysis in a banking or financial institution environment a strong plus.

**ABOUT US**

JPMorgan Chase & Co., 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**

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.

The CCB Data & Analytics team responsibly leverages data across Chase to build competitive advantages for the businesses while providing value and protection for customers. The team encompasses a variety of disciplines from data governance and strategy to reporting, data science and machine learning. We have a strong partnership with Technology, which provides cutting edge data and analytics infrastructure. The team powers Chase with insights to create the best customer and business outcomes.