Analyst, Customer Analytics

- Temporary role, hourly - 8/03 – 09/30 – possibility to extend - Remote, must support both East and Central Time Zone. - W2 on dentsu payroll only Job Description: The Analyst supports customer analytics initiatives by transforming customer, transaction, and marketing data into actionable business insights. This role partners with analytics and client teams to understand customer behavior, audience performance, retention, loyalty, and marketing effectiveness.

Key Responsibilities

• Query and analyze customer data using SQL and other data extraction tools.
• Perform data analysis using Python and visualization tools to identify trends, opportunities, and business recommendations.
• Develop recurring reports, dashboards, and data quality checks.
• Support customer segmentation, audience development, and campaign measurement.
• Assist with A/B test design, reporting, and interpretation.
• Present findings and recommendations to internal stakeholders.
• Collaborate with data engineering and analytics teams to ensure data accuracy and consistency.

Qualifications

• Bachelor's degree in Analytics, Statistics, Economics, Mathematics, Data Science, Business Analytics, Marketing, or related field.
• 2-3 years of relevant experience
• Proficiency in SQL required.
• Experience with Python for data analysis strongly preferred.
• Familiarity with Tableau, Power BI, or similar BI tools.
• Strong communication skills and ability to translate data into business insights.

Technical Skills Required

• SQL (joins, CTEs, aggregations, window functions)
• Advanced Excel (pivot tables, lookups, and formulas)
• Experience querying and manipulating large datasets
• Data visualization tools (Tableau, Power BI, Looker, or similar)
• Strong analytical and problem-solving skills

Preferred

• Python (pandas, NumPy, data cleaning, exploratory analysis, automation)
• Experience with cloud data warehouses such as Snowflake, Databricks, or BigQuery
• Exposure to R or SAS
• Understanding of ETL processes and data pipelines
• Experience with CRM, loyalty, retail, or customer behavioral datasets

At dentsu, we believe great work happens when we’re connected. Our way of working combines flexibility with in-person collaboration to spark ideas and strengthen our teams. Employees who live within a commutable distance of one of our hub offices, currently located in Chicago, metro Detroit, Los Angeles, and New York City, are required and expected to work from the office three days per week (two days per week for employees based in Los Angeles). Dentsu may designate other Hub offices at any time. Those who live outside a commutable range may be designated as remote, depending on the role and business needs. Regardless of your work location, we expect our employees to be flexible to meet the needs of our Company and clients, which may include attendance in an office. The hourly pay range for this position is $40-$50. The hourly pay rate for the successful candidate is based on a variety of factors, including relevant experience, knowledge, skills, and other factors permitted by law. Temporary employees are eligible for paid holidays in accordance with dentsu policy, as well as safe and sick time. This position is not eligible for any other benefits or other compensation. To begin the application process, please click on the “Apply” button at the top of this job posting. Applications will be reviewed on an ongoing basis, and qualified candidates will be contacted for next steps. #LI-Remote #LI-MS3 Location: USA - Remote - Maryland Brand: Merkle Time Type: Full time Contract Type: Temporary Dentsu is committed to providing equal employment opportunities to all applicants and employees. We do this without regard to race, color, national origin, sex , sexual orientation, gender identity, age, pregnancy, childbirth or related medical conditions, ancestry, physical or mental disability, marital status, political affiliation, religious practices and observances, citizenship status, genetic information, veteran status, or any other basis protected under applicable federal, state, or local law. Dentsu is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with us, please send an e-mail to [email protected] by clicking on the link to let us know the nature of your accommodation request and your contact information. We are here to support you.