Associate Data Analyst

New business pitches happen several times a month. Since 1963, the agency has added data science, analytics and in-house production teams. Timesheets are due daily, broken out by client and task.

THE POSITION:

Kendrick Brand Studio has an opening for an Associate Data Analyst. Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. We want an analyst who is comfortable pushing back when the numbers don't support the conclusion. Remote within the US. The team meets in New York City once a quarter, travel covered. Normal working hours, Monday to Friday. Strong written English is important, since much of our work is async.

RESPONSIBILITIES:

• Analyze trends, cohorts and funnel drop-off and summarize findings in plain language
• Build and maintain dashboards in Tableau, Power BI or Looker
• Track sales, inventory or service levels against targets and flag misses early
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Present results to managers and answer follow-up questions
• Define metric logic with stakeholders and document it

MINIMUM QUALIFICATIONS:

• 1+ years of experience in a data or reporting analyst role
• Strong SQL (joins, CTEs, aggregations, window functions)
• Clear written and verbal communication with non-technical stakeholders

PREFERRED QUALIFICATIONS:

• Salesforce or NetSuite reporting

PAY AND BENEFITS:

Pay range: $32.50 to $38.00/hr. Final offer will depend on experience.

• Flexible schedule

We read every application and reply within about a week.

Duration: 6 months. Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Kendrick Brand Studio.