Quant Analytics Associate - Audience Management (SAS/SQL)

Next Frontier Capital; Metro Manila; On-site; PHP 600,000 - 900,000; Full time

Job summary

JPMorganChase in the Audience Management team is seeking a Quant Analytics Associate to partner with marketers, gather requirements, and design targeting and segmentation for complex campaigns using Base SAS and SQL.

You will develop code for data extraction, deploy audiences to production, perform business analysis across banking domains, and collaborate with offshore partners to ensure timely delivery.

Qualifications

• Minimum of 3 years experience developing Base SAS codes for data manipulation and report creation using procedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary.
• Experience as a Business Analyst in related domains.
• Experience in requirement gathering and interacting with offshore partners.
• Experience in database querying (Teradata/Snowflake).
• Background in marketing operations, direct marketing, or data analysis.
• Strong analytical skills demonstrated by previous work experiences.
• Proficiency with Microsoft Office.

Responsibilities

• Develop and execute code to define customer populations for complex marketing campaigns
• Design functional specification documents for campaign execution
• Communicate and clarify requirements, results, and timelines with marketers and project stakeholdersAssess information from multiple data sources, resolve inconsistencies, and transform high-level information into detailed technical specifications
• Adhere to process requirements and checkpoints for campaign execution
• Distinguish between requestors' wants and needs, challenge assumptions, and recommend alternative solutions
• Develop code based on technical specifications to extract and process large volumes of customer and account data
• Validate, audit, and test outputs to ensure programs meet original requests
• Adhere to code development and documentation procedures, providing recommendations for improvement
• Coordinate end-to-end process delivery with internal and external stakeholders
• Provide support on ad hoc requests and special projects

Skills

Base SAS

SQL

Teradata

Snowflake

Marketing ops

Business Analyst

MS Office

Job description

Join our Audience Management team and be at the heart of transforming marketing strategies through data-driven audience targeting. Bring your expertise in business analysis and database marketing to drive impactful campaigns across various domains. Unlock your potential in a role that offers growth and collaboration opportunities.

Job Summary: As a Quant Analytics Associate in the Audience Management team, you will partner with marketers to gather requirements, propose designs for targeting and segmentation, and execute the delivery of final audiences. You will be responsible for developing code for data extraction and transformation, deploying audiences into production, and performing business analysis and database marketing functions for complex portfolio marketing campaigns using Base SAS programming and SQL querying. You will support domains including card, auto, home lending, retail, and wealth management.

Job Responsibilities:

• Develop and execute code to define customer populations for complex marketing campaigns
• Design functional specification documents for campaign execution
• Communicate and clarify requirements, results, and timelines with marketers and project stakeholdersAssess information from multiple data sources, resolve inconsistencies, and transform high-level information into detailed technical specifications
• Adhere to process requirements and checkpoints for campaign execution
• Distinguish between requestors' wants and needs, challenge assumptions, and recommend alternative solutions
• Develop code based on technical specifications to extract and process large volumes of customer and account data
• Validate, audit, and test outputs to ensure programs meet original requests
• Adhere to code development and documentation procedures, providing recommendations for improvement
• Coordinate end-to-end process delivery with internal and external stakeholders
• Provide support on ad hoc requests and special projects

Required Qualifications, Capabilities, and Skills:

• Minimum of 3 years experience in developing Base SAS codes for data manipulation and report creation using procedures such as Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary.
• Experience as a Business Analyst in related domains
• Experience in requirement gathering and interacting with offshore partners
• Experience in database querying (Teradata/Snowflake)
• Background in marketing operations, direct marketing, or data analysis
• Strong analytical skills demonstrated by previous work experiences
• Proficiency with Microsoft Office

Preferred Qualifications, Capabilities, and Skills:

• Solid understanding of retail marketing programs
• Familiarity or experience in operations, direct marketing, and data analysis in a banking or financial institution environment
• Advanced Microsoft Excel knowledge

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.

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. Partner with marketers to design and execute audience targeting and segmentation for complex marketing campaigns across domains.