Theo

Associate Analyst

Theo

full-time

Posted on:

Location Type: Hybrid

Location: PortlandOregonUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $50,000 - $65,000 per year

About the role

  • Build and maintain recurring reports and dashboards for internal and client use
  • Collaborate with media and strategy teams to develop client presentations that clearly communicate performance trends and opportunities
  • Interpret and communicate performance trends and collaborate with internal marketing teams to identify contributing factors and corresponding optimizations and actions
  • Create data sets to be shared and used across multiple teams by gathering, organizing, cleaning, and connecting data from multiple sources into a cohesive and understandable data model
  • Monitor data pipeline and resolve any errors or issues in a timely manner
  • Manage priorities across a diverse set of clients and projects

Requirements

  • Basic Excel understanding
  • Great attention to detail
  • Math skills
  • Proficient PC computer skills
  • Curious attitude leading to sourcing root causes and correlations
  • Basic analysis experience
  • Bonus for basic understanding of the following:
  • Understand the dimensions and metrics available across the standard digital marketing platforms (e.g. Google Analytics, Google Ads, Facebook, Salesforce, etc)
  • Experience with Microsoft Power BI including best practices with data transformations and DAX
  • Understand relational data design
  • Advanced understanding of Excel
  • Understand data visualization best practices
  • Basic understanding of ad tagging/UTM process
  • 2 years experience in an analyst or reporting role
  • Bachelor degree preferred
Benefits
  • Healthcare, Dental & Vision Insurance, Theo covers an average of 75%
  • Matching 401K
  • Unlimited PTO
  • Parental leave benefits
  • Remote work support
  • Complementary supplemental insurance
  • Unlimited volunteer time
  • Charity matching
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Exceldata analysisdata visualizationdata modelingdata transformationDAXad taggingUTM processrelational data designreporting
Soft Skills
attention to detailcuriositycommunicationcollaborationprioritization