DRUM

Data Analyst

Location US-Atlanta
Type
Contract

Overview

Newton’s First Law: Objects at rest tend to remain at rest. The same is true of people. At DRUM, our job is to get people to move. But random movement is pointless. Movement in rhythm with the goals of our clients, on the other hand, is the most valuable thing in the world. There’s an irresistible beat that gets brands noticed, gets people talking and, above all, gets results. No wonder so many great brands — like AT&T, Aflac, Carhartt, E*TRADE, PayPal, March of Dimes and more — trust us to help take them where they want to go. We’re DRUM. Let’s dance.

 

If you’re not having any fun at work, you’re doing it wrong. Whether you’re in our Atlanta, Chicago or New York office, you’ll see for yourself: At DRUM, we love what we do. We’re focused, but not funless. Aggressive, but not ad-holes. After all, we believe in harmony. It’s there in everything we do, from our award-winning campaigns to our slightly less decorated bowling team. And it’s the reason our agency is recognized time and again, from Chief Marketer’s Top 200 Agencies to the Atlanta Journal-Constitution’s Top Workplaces.

 

Our Atlanta office is currently looking for a Data Analyst.  This position is a contractor role. The work schedule is Monday-Friday from 9:30am to 5:30pm.

The Data Analyst will provide technical solutions, identify approaches for capturing, storing, retrieving corporate data so that is may be used widely, effectively and as efficiently as possible. Analyze business requirements; develop high-level and detailed data assessment for complex, cross numerous business functional areas projects.

 

The analyst manages the data collection and cleansing activities and participates in the development and maintenance of digital performance reports for various clients.  Candidates should have 2-4 years of progressive experience performing in an analysis environment.  A history of managing competiting priorities and evangelizing analytics is preferred.

Responsibilities

- Process/clean data in SQL and/or Excel in preparation for reporting & model-building
- Execute functions in SQL Server and Tableau to address client business issues
- Summarize media performance results
- Analyze media effectiveness and, if called upon, be able to deliver findings to clients
- Build Powerpoint presentations summarizing both model results and client recommendations
- Manage the periodic delivery of substantial performance updates to various clients. This includes, but is not limited to, innovative methods of presenting performance metrics, automating recurring data needs and aligning presentation materials with Account Service and Media efforts
- Work directly with client and DRUM staff to determine priorities and to manage to deadlines
- Recommend and provide general data governance and analytics support to client

Qualifications

- Meticulous attention to detail and accuracy while dealing with complex projects and time-sensitive materials
- 2 - 4 years data analyst experience, preferably in the digital agency industry
- 2-4 years of experience programming in SQL Server
- Bachelors degree in a quantitative, marketing, mathematics, computer science, economics, or business equivalent preferred Years of Relevant Experience
- Advanced Excel skills (pivot tables, macros, functions, etc.) and intermediate knowledge of MS PowerPoint
- Attribution measurement experience
- Data visualization, presentation, and analysis experience
- Strong fundamentals in relational data and database schema
- Ability to multi-task, prioritize and manage workload
- Self motivated/self starter, and ability to work independently
- Strong written and verbal communication skills
- Basic HTML and marketing automation platform knowledge
- Ability to adapt quickly to new technologies
- Fundamental understanding of core digital marketing disciplines
- Statistical tools (such as R, SPSS, SAS) and techniques e.g. segmentation, response modeling and lifetime value experience a plus
- Database tools (MySQL, SQL Server, MS Access)
- Understanding of database concepts including normalization, and data integrity

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed