The Technical Analyst will be an integral part of 160over90’s rapidly-growing analytics department. He or she will work across multiple departments to bring a data-driven approach and a technical skillset to a variety of client engagements. The analyst will be comfortable working with APIs to pull, clean, and activate data using Python. Leading candidates will have the ability to transform raw data into organized databases and compelling visualizations. The analyst will also be tasked with providing deep analysis into agency-wide marketing trends and campaign optimization opportunities. There is tremendous opportunity to expand and shape the role as the department and agency evolves. 

RESPONSIBILITIES

• Develop code to pull, aggregate, clean, and blend data from a variety of platforms
• Apply statistics to analyze campaign performance and attribution
• Identify opportunities for campaign management and reporting automation
• Help build out a data warehouse that encompasses agency-wide media data
• Collaborate with media team to create ad hoc reports and 
• Build out custom client dashboards and connect dashboards to APIs

SKILLS/REQUIREMENTS

• A passion for digital analytics and a desire to continue to learn is a must
• Experience using Python to pull and clean data
• Knowledge of digital marketing APIs 
• Experience with data visualization tools (Tableau, Domo, Data Studio)
• Strong understanding of Google Analytics and other marketing data sources
• General knowledge of paid search, display, and paid social advertising
• 2-3 years of experience preferred
• Analytical mindset with strong attention to detail and problem-solving skills
• Highly organized with ability to multitask in a fast-paced environment
• Data warehouse and ETL expertise is a plus
• SQL proficiency is a plus
• HTML/CSS/JavaScript experience is a plus