Quantitative Analytics [Multiple Positions Available]
About The Position
Design, develop and execute code to define customer population in servicing and marketing campaigns. Develop code based on the technical specification to extract and process large volumes of customer and account data. Maintain proper data control environment and work closely with Quality Validation and Control teams to ensure compliance with legal, marketing, and data use rules. Research data elements used for targeting using database metadata. Collaborate with business partners to gather targeting requirements for a campaign and establish strong business partnerships with other members of project teams. Develop and validate audit plan, such as data validations to ensure targeted populations meet requirements. Perform code quality reviews, suggest process improvements, and assist in updating the department's documentation. Identify relationships and trends in data, as well as any factors that could affect results of the campaign. Communicate impacts to business partners and provide sample sizes per category to validate all components extracted and derived fields created. Prepare campaigns for post-processing Analytics and Reporting teams.
Requirements
- Master's degree in Business Analytics, Economics, Statistics, Mathematics, or related field of study plus one (1) year of experience in the job offered or as Quantitative Analytics, Global Supply Chain Analyst, Market Research Analyst, or related occupation.
- Alternatively, a Bachelor's degree in Business Analytics, Economics, Statistics, Mathematics, or related field of study plus three (3) years of experience in the job offered or as Quantitative Analytics, Global Supply Chain Analyst, Market Research Analyst, or related occupation.
- Experience using SAS Data Step and SQL JOIN operations to combine data from different tables.
- Experience manipulating large amounts of data using SAS procedures including Proc Freq, Proc Format, Proc Sort, Proc SQL, and Proc Summary, as well as SAS data step programming.
- Experience working with millions of records, in relational databases including Oracle, Teradata, and Snowflake, to run and create code for campaign execution and understanding data.
- Experience extracting data from databases, flat files, and external APIs using SAS and SQL.
- Experience writing SQL queries to retrieve specific data sets from relational databases and integrating data from multiple sources to create comprehensive data sets for analysis.
- Experience utilizing PUTTY for secure remote access to Unix systems, facilitating the execution and monitoring of scripts related to campaign execution and data understanding.
- Experience employing Unix for running and creating scripts that support campaign execution and data analysis, including managing file systems and automating tasks.
- Experience using Excel with basic formulas, pivot tables, and charts for auditing and reviewing the results of campaigns, as well as providing insights into campaign execution.
- Experience writing technical specification documents using Word and excel, using basic page setup, editing, and text formatting functions.
- Experience managing pages, uploading, and editing documents in MS Teams to facilitate collaboration and document sharing among project team members.
- Experience implementing automation using Autosys to schedule and execute batch jobs related to campaign execution and data processing.
- Experience writing and executing shell scripts to automate processes and tasks related to campaign execution and data analysis.
Responsibilities
- Design, develop and execute code to define customer population in servicing and marketing campaigns.
- Develop code based on the technical specification to extract and process large volumes of customer and account data.
- Maintain proper data control environment and work closely with Quality Validation and Control teams to ensure compliance with legal, marketing, and data use rules.
- Research data elements used for targeting using database metadata.
- Collaborate with business partners to gather targeting requirements for a campaign and establish strong business partnerships with other members of project teams.
- Develop and validate audit plan, such as data validations to ensure targeted populations meet requirements.
- Perform code quality reviews, suggest process improvements, and assist in updating the department's documentation.
- Identify relationships and trends in data, as well as any factors that could affect results of the campaign.
- Communicate impacts to business partners and provide sample sizes per category to validate all components extracted and derived fields created.
- Prepare campaigns for post-processing Analytics and Reporting teams.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Number of Employees
5,001-10,000 employees
