Senior / Data Analyst (analytics) Job in Ally Executive

JOB DESCRIPTION

The Data Analyst 2 is responsible for conducting data analyses using SAS/SQL and other tools in support of a variety of
analytic solutions.

The Analytic Consulting Group partners with both internal and external clients, and data providers, leveraging various analytics to drive strategic thought and effective decision making.

Roles & Responsibilities
Collaborate with internal/external stakeholders to manage data logistics including data
specifications, transfers, structures, and rules
Access and extract data from a variety of sources of all sizes (including client marketing
databases) via SAS Access, SQL, etc.
Master and perform all steps required to create analysis-ready data sets; including data
integration/merging (SAS data step), variable preparation, and quality control (QA/QC)
Develop and execute SAS/SQL (or related) programs with minimal direction and supervision
Provide problem solving and data analysis, derived from programming experience
Demonstrate proficiency with desktop and UNIX toolsets (SAS, SAS ODS, SQL, MS Office) to
create pivot tables and/or report content such as tables, reports, graphs, etc. (some positions
require proficiency in digital analytic tools including Google and/or Adobe Analytics and
familiarity with digital data, in addition to or in lieu of SAS/SQL)
Document and articulate steps taken in an analysis to project managers
Answer questions about data sets and analyses
Follow all policies and procedures for programming, project documentation, and system
management
Become familiar with
all offerings outlined in the Insider s Guide to ACG
various statistical offerings and methods (CHAID, logistic/multiple regression, cluster
analysis, factor analysis)
Client data assets
the SAS macro library
Participate in the design, planning & execution of projects
Effectively manage time and resources in order to deliver on time / correctly on a limited number
(1-4) of concurrent projects
Proactively communicate with supervisor regarding workload and the status of assignments
Prepare basic report content (Word, Excel, PowerPoint) in support of deliverables
Perform two tasks related to the role of Sr. Data Analyst during the year

QUALIFICATIONS

Minimum Qualifications:
Bachelor s degree in a quantitative discipline (e.g., Statistics, Economics, Mathematics, Marketing
Analytics) or significant relevant coursework
5-7 years of experience in the marketing analytics field
Some positions require a minimum of 1 year of experience conducting digital analytics
Demonstrated proficiency in SAS/SQL programming; minimum 2 years of experience
Strong analytic thought process and ability to interpret findings
Acute attention to detail (QA/QC)
Working knowledge of MS Office; including PowerPoint, Word, Excel and Outlook
Ability to work on multiple assignments concurrently
Excellent verbal and written communication skills
Highly motivated and collaborative team player with strong interpersonal skills
Effective organization and time management skills

Desirable Qualifications:
Advanced degree (Master s/PhD) in Statistics, Economics or other quantitative discipline
Database marketing experience/knowledge
Ability to program in newer and emerging languages such as R and Python; working knowledge
of Hadoop and other big data technologies