Data Analyst 2

Job Description

The Analytic Consulting Group collaborates with both internal and external clients, data providers, utilizing various analytics to guide strategic thought and efficient decision making. The Data Analyst 2 is in charge of executing data investigations utilizing SQL and other tools to aid a range of analytic solutions.

Roles & Responsibilities:

• Work closely with internal/external stakeholders to oversee data logistics – including data specifications, transfers, structures, and rules
• Access and retrieve data from various sources of all sizes (including client marketing databases) via Python, Excel, SQL, etc.
• Master and execute all steps required to make data sets ready for analysis; including data integration/merging (SAS data step), variable preparation, and quality control (QA/QC)
• Construct and execute SQL (or similar) programs with detailed direction and supervision
• Provide problem-solving and data analysis, stemming from programming experience
• Show 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 necessitate proficiency in digital analytic tools including Google and/or Adobe Analytics and familiarity with digital data, in addition to or in place of SAS/SQL)
• Document and describe steps undertaken in an analysis to project managers
• Answer queries about data sets and analyses
• Adhere to all policies and procedures for programming, project documentation, and system management
• Become acquainted 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
• Take part in the design, planning & execution of projects
• Effectively manage time and resources 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) to aid deliverables
• Perform two tasks associated with the role of Sr. Data Analyst during the year

Minimum Qualifications:

• Bachelor’s degree in a quantitative field (e.g., Statistics, Economics, Mathematics, Marketing Analytics) or significant related 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
• Sharp attention to detail (QA/QC)
• Working knowledge of MS Office; including PowerPoint, Word, Excel and Outlook
• Ability to manage multiple assignments concurrently
• Excellent verbal and written communication skills
• Highly driven 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 located at the center of Publicis Groupe. Epsilon enhances clients’ ability to utilize the power of their first-party data to initiate campaigns across channels and devices, with a unique ability to prove outcomes. The company’s leading technology connects advertisers with consumers to drive performance while respecting and protecting consumer privacy. Epsilon’s people-based identity graph enables 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 several decades, we’ve been helping marketers from the world’s top brands personalize experiences for millions of people with our innovative technology, solutions and services. Epsilon’s superior identity gives brands a clear, privacy-safe view of their customers, which they can use across our range of digital media, messaging and loyalty solutions. We process over 400 billion consumer interactions each day and hold several patents of proprietary technology, including real-time modelling languages and consumer privacy enhancements. Thanks to the work of each employee, Epsilon has been regularly recognized as industry-leading by Forrester, Adweek and the MRC. Located at the core of Publicis Groupe, Epsilon is a global company with more than 8,000 employees across the globe. Check out a few of these resources to learn more about what makes Epsilon so EPIC:

• Our Culture: https://www.epsilon.com/us/about-us/our-culture-epsilon
• Life at Epsilon: https://www.epsilon.com/us/about-us/epic-blog
• DE&I: https://www.epsilon.com/us/about-us/diversity-equity-inclusion
• CSR: https://www.epsilon.com/us/about-us/corporate-social-responsibility

Great People Deserve Great Benefits

We understand that we have some of the brightest and most talented associates worldwide, and we believe in rewarding them as such. If you work here, anticipate competitive pay, comprehensive health coverage, and limitless 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 real 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

REF212966U