Data Analyst 2

    • Epsilon
  • Southfield, MI
  • Posted 12 days ago | Updated 10 hours ago

Overview

On Site
Full Time

Skills

Policies and procedures
Attention to detail
Time management
Decision-making
Data Analysis
Data integration
Quality control
Problem solving
SAS/ODS
Pivot table
Adobe Analytics
SAS/SQL
Project documentation
Cluster analysis
SAS/MACROS
Marketing analytics
Analytics
SQL
Database marketing
Big data
Digital media
Real-time
Data
Analytical skill
Collaboration
Management
Logistics
Specification
Marketing
Database
Python
Microsoft Excel
SAS
Quality assurance
Supervision
Software development
Unix
Reporting
Articulate
Decision trees
Regression analysis
Design
Planning
Statistics
Economics
Mathematics
Microsoft Outlook
Communication
R
Apache Hadoop
Advertising
Leadership
Privacy
Value engineering
SAFE
Messaging
Patents
Modeling
MRC
Epic
Corporate social responsibility
Expect
Policies
Law

Job Details



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. TheData Analyst2 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 marketinganalytics 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


Additional Information

About Epsilon

Epsilon is a global advertising and marketing technology company positioned at the center of Publicis Groupe. Epsilon accelerates clients' ability to harness the power of their first-party data to activate campaigns across channels and devices, with an unparalleled ability to prove outcomes. The company's industry-leading technology connects advertisers with consumers to drive performance while respecting and protecting consumer privacy. Epsilon's people-based identity graph allows brands, agencies and publishers to reach real people, not cookies or devices, across the open web. For more information, visit epsilon.com.

When you're one of us, you get to run with the best.For decades, we've been helping marketers from the world's top brands personalize experiences for millions of people with our cutting-edge technology, solutions and services. Epsilon's best-in-class identity gives brands a clear, privacy-safe view of their customers, which they can use across our suite of digital media, messaging and loyalty solutions. We process 400+ billion consumer actions each day and hold many patents of proprietary technology, including real-time modeling languages and consumer privacy advancements. Thanks to the work of every employee, Epsilon has been consistently recognized as industry-leading by Forrester, Adweek and the MRC. Positioned at the core of Publicis Groupe, Epsilon is a global company with more than 8,000 employees around the world. Check out a few of these resources to learn more about what makes Epsilon so EPIC:
  • Our Culture: ;/li>
  • Life at Epsilon: ;/li>
  • DE&I: ;/li>
  • CSR: ;/li>

Great People Deserve Great Benefits

We know that we have some of the brightest and most talented associates in the world, and we believe in rewarding them accordingly. If you work here, expect competitive pay, comprehensive health coverage, and endless opportunities to advance your career.

Epsilon is an Equal Opportunity Employer. Epsilon's policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information, or any other characteristic protected by applicable federal, state or local law. Epsilon also prohibits harassment of applicants and employees based on any of these protected categories. Epsilon will provide accommodations to applicants needing accommodations to complete the application process.

#LI-WK1

REF231423H