Rise Interactive (http://www.riseinteractive.com), a rapidly growing full service interactive advertising agency, is looking to hire an Internet Marketing Consultant, Analytics for our Mexico City office. We are looking for a detail-oriented, highly motivated and tenacious individual that is excited about getting involved in an entrepreneurial company with an expanding Fortune 500 client base. This position will remain flexible hybrid based off of pod and client needs.
Summary & Scope
The Internet Marketing Consultant for our Analytics team will focus on cross-channel analysis for current and prospective clients across all marketing channels. This individual must have strong analytical and technical skills, proficiency with Excel and/or Tableau, an understanding of data transformation concepts and techniques, and exhibit an overall sense of urgency and client focus through all activities.
Responsibilities
Work closely with clients and team members to understand client goals and identify opportunities for optimization of digital media
Identify the required inputs for analyzing media data
Lead and manage media data aggregation, transformation, and normalization necessary for analysis using Excel, Alteryx, and other tools
Create and manage data tables in BigQuery, write queries to transform data
Perform measurement, analysis, and reporting of web and campaign performance metrics
Provide insights and recommendations based on cross-channel data analysis
Support incrementality testing and forecasting projects
Develop and support process standardization, automated data validation, and error checks
Create effective dashboards and data visualizations for internal and external stakeholders using Data Studio and Tableau
Support implementation and customization of third-party analytics software
Required Skills
Bachelor’s degree required
Experience with database management and basic knowledge of SQL
Experience with normalizing and transforming large data sets and analyzing the outputs created from them
Strong Analytical and Logical Reasoning Skills
Intermediate experience with Microsoft Excel
Basic statistics knowledge
Experience with data visualization tools such as Tableau or Google Data Studio
Strong interpersonal, analytical, project management, and verbal and written communications skills