Carat, part of Dentsu Aegis Network, has been appointed by Microsoft to run its global advertising, media buying and planning since April 2014. Microsoft is one of the most prestigious clients in the Dentsu Aegis Network portfolio and services the full suite of products such as Xbox, Surface and Azure for over 80 markets across the world.

Carat USA is a full service, award-winning agency. Curiosity, Creativity, and Collaboration guide our people to deliver communications solutions in an innovative and empowering work environment. The depth and scope of Carat’s offerings and ability to encompass all consumer touch points, gives us a unique ability to activate all expressions of a client’s brand. MediaPost Holding Company of the Year 2016, 2017 & 2020 and Adweek Media Agency of the Year 2015.

The Analyst, Data & Analytics, will be part of a cross-functional team, specifically focused on transforming raw data into insights and recommendations to drive business outcomes for our clients. The ideal candidate is a proactive self-starter and has an innate interest in all things data: whether it’s data tidying, visualization, analysis, or statistics, using data to drive business outcomes is a passion.

Job Responsibilities:

Data Management:
• Access and compile large volumes of data across disparate sources into concise and precise information
• Understanding of ETL process and ability to query databases
• Ensure data quality and data documentation
• Solve problems with internal and external clients on data issues
• Ability to determine and gather data requirements for a given project
• Identify and resolve data discrepancies and reporting issues

Data Analysis and Presentation:
• Understand the business processes and leverage the procured knowledge in planning, execution, and reporting
• Produce visuals (charts, graphs) and presentations for summary trend statistics
• Provide support for ad-hoc data and research
• Clearly and effectively communicate findings

Education/Experience:

• Bachelor's Degree with a background in mathematics, statistics, or related field preferred
• 2-4 years of experience in analytics with expertise in digital media
• Experience building reports from scratch
• Knowledge of working with large relational data sets
• Client-facing experience within media agencies or publishers desired

Software Skills Desired:

• Advanced Excel knowledge
• Working knowledge of Ad Tech platforms including, DoubleClick (DBM, DCM) Adobe (Analytics, AMO, AAM) Marin and Prisma is preferred
• Experience with SQL & Python preferred
• Experience in visualization tools (Power BI, Tableau) is preferred

What’s in it for you?

At Carat we invest in our talent, we’ll help you develop your skillset and provide you with many opportunities to challenge yourself and shine:

•401K including match

•medical, dental, vision

•HSA & FSA including commuter benefits

•Flexible time off & we support working from home if your schedule allows it

Dentsu is a modern marketing solutions company. Our mission is to help clients navigate, progress and thrive in a world of change. Businesses rely on our integrated network of agencies and specialized practices to champion meaningful progress through creative, media, commerce, data and technology. Part of Dentsu Group, our global network comprises 66,000 diverse people in 143 countries, who are dedicated to teaming for growth and good. Some of our award-winning agencies include 360i, Carat, dentsumcgarrybowen, DEG, dentsuX, iProspect and Merkle. Follow us on Twitter @DentsuUSA and visit dentsu.com/us.

Employees from diverse or underrepresented backgrounds encouraged to apply.

Dentsu (the "Company") is committed to a policy of Equal Employment Opportunity and will not discriminate against an applicant or employee of the Company, on the basis of age, sex, sexual orientation, race, color, creed, religion, ethnicity, national origin, alienage or citizenship, disability, marital status, veteran or military status, genetic information, or any other legally-recognized protected basis under federal, state or local laws, regulations or ordinances. Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and/or certain state or local laws. A reasonable accommodation is a change in the way things are normally done that will ensure an equal employment opportunity without imposing an undue hardship on the Company. Please contact [email protected] if you need assistance completing any forms or to otherwise participate in the application process or to request or discuss an accommodation in connection with a job at the Company to which you are applying. #LI-MB3