The Business Analyst role will develop and generate list reports to support Marketing/Servicing campaigns for Card, Auto and Mortgage. The analyst will be using the following: SQL, Excel, SAS, MS Office or equivalent reporting tools to assist the business in meeting operational objectives. This role will be working with program/channel managers to gather business requirements and will create program specifications that will capture the overall flow and details of the campaign. The analyst will follow standard procedures set by the line of business to ensure audit/reports are compliant with process adherence.
ROLES and RESPONSIBILITY
Primary responsibility is the development and execution of SAS/SQL code to define customer populations to be targeted in marketing campaigns.
Research data elements to be used for targeting using database metadata.
Audit campaign populations to insure marketing requirements are met.
Work with business contacts to gather requirements needed for the campaign.
Establish strong business partnerships with other members of project teams.
Suggests process improvements and assists in updates of department’s documentation as needed.
Identify relationships and trends in data, as well as any factors that could affect result of the campaign.
Prepare data for processing, check for inaccuracies and create campaign tactics when applicable.
Provide sample sizes per category to validate all components extracted and derived fields created.
Bachelors or higher degree. A concentration in relevant technical fields is preferred (e.g., Computer Science, Statistics, etc.)
Advanced knowledge of SAS or demonstrated ability to quickly learn SAS.
1-2 years of experience with SQL and relational databases such as Oracle, Teradata.
Experience with other programming languages (e.g.,VB, VBA, Java, Perl, Python, C++, Unix shell scripting) is a plus
Excellent analytical skills.
Ability to manage multiple tasks effectively.
A background in marketing operations, direct marketing or data analysis is preferred.
Experience with Teradata is helpful but not required
Experience with Unix or Linux.
Excellent verbal communication and correspondence skills.
Result oriented with proactive approach to resolving problems.
Ability to multi-task in fast paced environment.
Ability to listen/observe/acknowledge/lead by example and provide recommendations.
Ability to articulate the causes of issues and comfortable to escalate concerns when necessary.
Planning and Organizing
Good time management and ability to prioritize.
Plan and organize with clarity and attention to detail; quality oriented.
Proactively raises concerns when timelines are in jeopardy of not being met.
Adaptability to changing information systems environment.
This position is anticipated to require the use of one or more High Security Access (HSA) systems. Users of these systems are subject to enhanced screening which includes both criminal and credit background checks, and/or other enhanced screening at the time of accepting the position and on an annual basis thereafter. The enhanced screening will need to be successfully completed prior to commencing employment or assignment.