Data Analyst

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 is responsible for conducting data analyses using SAS/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 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 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 are taken in 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

• Day-to-day management of internal clients for select lines of business

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 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 disciplines

• 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