
Associate Analyst
Theo
full-time
Posted on:
Location Type: Hybrid
Location: Portland • Oregon • United States
Visit company websiteExplore more
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