DRUM

  • Digital Analyst

    Type
    Regular Full-Time
  • Overview

    Company

     

    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.

     

    Culture

     

    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.

     

    Summary:

     

    The digital analyst 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.

     

    Responsibilities

    - Gather information about reporting needs from end users
    - Develop, maintain and continuously upgrade/update all reports maintained in Tableau.
    - Write and test T-SQL procedures to deliver data from SQL Server to 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.
    - Collaborate with media, analytics and account service to develop compelling digital visualizations that assist in data storytelling.
    - Manage projects and timelines for report delivery
    - Ensure reported output is accurate and matches user requirements.
    - Assist in training junior team members in use of Tableau and understanding SQL processes

    Qualifications

    - BS Degree in Computer Science, Marketing, Business, Finance, Accounting, Engineering or its equivalent in education and experience2-3 years of professional experience in a multi-client reporting and analysis environment.
    - Excellent T-SQL skills including stored procedures, functions, & views
    - Experience with the Microsoft BI Stack (SQL Server SSMS, SSRS, SSIS, & SSAS)
    - Extensive knowledge of indexing, query optimization and other performance tuning techniques
    - High capacity for data analysis, data modeling, computer programming, problem solving, sound judgment, accuracy and attention to detail
    - 2+ Years experience developing in Business Intelligence Software such as Tableau and Microsoft Reporting Services.
    - Understanding of SQL and relational and multidimensional designs
    - Proficient in MS Office(Excel, PowerPoint, and Word)
    - Experience delivering technical presentations to non-initiated audiences

    Options

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