Data Analytics (SAS,SQL)

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.

Domains supported: Card, Auto

• 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 and Daily interactions with Marketers & project stakeholders  on multiple projects - required to communicate and clarify requirements, results, and timeline
• 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 and will need to validate, audit and test the output produced from their documents to ensure that the programs meets the original request.
• Adhere to the department’s code development and documentation procedures. Provide recommendations and feedback on how to improve or implement strong control procedures.
• The candidate may also direct efforts with internal and external stakeholders to coordinate end to end process delivery and provide support on Adhoc requests and special projects as assigned.

Qualifications

• 5+ years extensive of Data processing using SQL, SAS , Alteryx, Python and relational databases such as Oracle, Teradata
• Minimum 3 years’ experience with data visualization tools (Alteryx, Power BI, Tableau etc.)
• Experience as Business Analyst in related domains and in requirement gathering and interacting with off-shore partners
• A background in marketing operations, campaign execution or data analysis. 
• Strong analytical skills demonstrated by previous work experiences. 
• Solid understanding of credit card marketing programs is desired. 
• Proficiency with Microsoft office is required and advanced Microsoft Excel knowledge is desired.

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.