• Data Services Specialist(Contract Position)

  • 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 Aflac, E*TRADE, PayPal, Wounded Warrior Project 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.




    The Data Services Specialist manages and participates in the day-to-day reporting, visualization development and analysis for various clients.  The Analyst works both collaboratively and independently with Data Services, Media and Account Services to understand client data, inform the development of client’s data warehouse and build client data models in MS SQL Server which are used as datasets for Tableau server. This is a Contract role, up to 35 hours per week with the possibility but not a guarantee of converting into a full-time, salaried position. 



    - Collaborate with media, analytics and account service to develop compelling digital visualizations that assist in data storytelling
    - Will initial be cross-trained with Ad Operations Team 
    - Gather information about reporting needs from end users
    - Develop, maintain and continuously upgrade/update all reports maintained in Tableau.
    - Create and test reports in Tableau
    - Monitor daily audit reports which provide insight into the health of the underlying datasets.
    - Develop, maintain and support code/systems in support of the business needs.
    - Train end users on capabilities of Tableau and finding insights from reporting
    - Work with other team members to retrieve third-party reports and data for data integration and delivery
    - Follows technical guidelines and best practices to ensure a consistently high standard of quality.
    - Resolves defects or deficiencies with completed development, updates documentation, and provides training to support team members on completed development as necessary.
    - Create ad hoc data queries and solve data related reporting issues and document reports created.
    - Manage projects and timelines for report delivery
    - Trouble shoot and ensure reported output is accurate and matches user requirements.
    - Assist in training junior team members in use of Tableau and understanding SQL processes


    - BS Degree in Computer Science, Marketing, Business, Finance, Accounting, Engineering or its equivalent in education and experience
    - High capacity for data analysis, data modeling, computer programming, problem solving, sound judgment, accuracy and attention to detail
    - Prior Digital Media experience and/or Ad Ops with an understanding of paid search and display is a plus but not required.
    - 2-3 years of professional experience in a multi-client reporting and analysis environment.
    - Intermediate to Advanced experience in MS Office(Excel, PowerPoint, and Word)
    - 2+ Years experience developing in Business Intelligence Software such as Tableau and Microsoft Reporting Services.
    - Extensive knowledge of indexing, query optimization and other performance tuning techniques
    - Understanding of SQL and relational and multidimensional designs
    - Ability to learn quickly and multi-task
    - Strong Interpersonal skills
    - Experience delivering technical presentations to non-initiated audiences


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