Data Analyst 2

Job Description

Summary:

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. The Data Analyst 2 is responsible for conducting data analyses using SQL and other tools in support of a variety of analytic solutions.

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 Python, Excel, 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 SQL (or related) programs with detailed 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)

Epsilon 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

Minimum Qualifications:

Bachelor's degree in a quantitative discipline (e.g., Statistics, Economics, Mathematics, Marketing Analytics) or significant relevant coursework

1-2 years of experience in the marketing analytics field

Some positions require a minimum of 1 year of experience conducting digital analytics

Demonstrated proficiency in 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