Marketing Data Analyst

Marketing Data AnalystOptimal is looking for a Marketing Data Analyst with experience in performance digital marketing analytics. The Marketing Data Analyst works hand-in-hand with our Paid Media and SEO departments to improve the effectiveness and efficiency of our client services teams. The Data Analyst helps to clearly quantify client performance objectives by maintaining our existing reporting suites, creating new methods of reporting, and automating repetitive tasks. The Marketing Data Analyst will join our Business Intelligence team – a team that re-imagined our data analytics from the ground up. We started with web tracking and attribution (Google Analytics, Google Tag Manager), then moved into reporting automation (SQL and Power BI) and are now driving a shift from descriptive reporting to actionable and insightful dashboarding. Our team is also frontline in detecting anomalies in key performance metrics that alert account managers for intervention. These initiatives directly impact almost every aspect of our company and are critical to driving our continued growth.Optimal is a performance marketing agency on a mission, bringing together the best data, technology, and people to achieve our clients' marketing goals. Brand, campaign, or cause: we maximize performance at every moment. We are not only digital media strategists – we're award-winning industry leaders, with deep knowledge spanning all things digital: from advertising and paid media, to marketing and communications, to audience data and analytics, we deliver for our clients. Everyone at Optimal has the opportunity to learn, grow, and progress. Through our proprietary training programs, we provide our team members with the personal and professional development they need to achieve advancement at any stage in their careers. We're always looking for exceptional people to join our team. If this sounds like you, please apply!Key Responsibilities:Report Creation – Work with account teams to create custom reports for high value clients that focus on their unique KPIs and reporting needs. Create beautiful, insightful, and actionable dashboards for all clients in Microsoft Power BI, Excel, and Google Sheets.Reporting Automation – Use existing web-based tools to query data from our sources (Google Ads, Meta, Bing, LinkedIn, etc.) and assist in developing new tools for pulling data from other sources (web scraping, CRMs, etc). Automate reports using Power BI, SQL, and formulas & pivot tables in Google Sheets.Process Management – Define and successfully deploy processes to reduce manual lift and avoid fault points. This includes streamlining our project management process, documenting around account team FAQs, and iterating upon our BI internal documentation.Data Interpretation – Dig into the data presented in platforms such as Google Analytics, Google Ads, and Facebook Ads and understand what is happening with performance. Draw insights with your understanding of metrics like CTR, CVR, ROAS, Click-through vs. View-through conversions, attribution windows and modes, path to conversion, A/B testing, etc.Qualifications & Skill Requirements:4-year Bachelor's degree required in mathematics, statistics, MIS, analytics, data science, business intelligence, or a related field.2+ years of experience in performance marketing-related analytics.2+ years of experience utilizing tools such as Power BI, Tableau, or similar platforms.2+ years of SQL experience.Experience with PPC, SEM or SEO marketing analytics is a strong plus.Advanced knowledge of Excel formulas, Pivot Tables, and Macros.Experience with Microsoft Azure Platform is a plus.Experience with scripting languages is a plus.Proficiency in Google Analytics.Excellent mathematical, problem solving, analytical, and communication skills.Experience with HTML/Javascript/CSS is a plus.Optimal is proud to offer the following:Flexible Time OffPaid Leave for New ParentsHealth insurance (including dental and vision)Flex Spending PlanEmployee Assistance Program401K with company matchingProfessional development opportunitiesRewards and recognition programsOffice HoursThis role is based out of our Austin office. Our team works on a hybrid basis, working three days a week in the office and two days from home. Work hours are consistently 9:00 A.M. to 5:00 P.M., Monday - Friday, with the expectation that evening and weekend work will be required as necessary. Please note that we are unable to provide Visa sponsorship for this position at this time.Please visit our Notice to Applicants and Employees to learn about our information practices in the job application and employment context.