Theo · 12 hours ago
Associate Analyst [HYBRID - US]
Theo is a fast-growing performance media agency located in Portland, Oregon. We are looking for a talented Data Analyst who can manage the data analysis process across a diverse set of clients and industries, providing insights that drive strategic marketing decisions.
AdvertisingAnalyticsMarketingSEO
Responsibilities
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
Qualification
Required
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
Preferred
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