Marketing Data Analyst

Optimal; Austin (TX); Híbrido; USD 90.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible Time Off

Health insurance (medical, dental,视)

Descripción de la vacante

Optimal is seeking a Marketing Data Analyst to join our Business Intelligence team in Austin. You will partner with Paid Media and SEO to quantify client performance, maintain reporting suites, and build new dashboards in Power BI, Excel, and Google Sheets.

The role emphasizes automation, data interpretation, and actionable insights across platforms like Google Ads, Meta, and Bing. You will contribute to process improvements, reduce repetitive tasks, and detect anomalies to alert account

Formación

• 4-year Bachelor’s degree in mathematics, statistics, MIS, analytics, data science, BI, or related field.
• 2+ years of experience in performance marketing analytics.
• Experience with Power BI, Tableau or similar platforms.
• 2+ years of SQL experience.
• Proficiency in Google Analytics and Excel.
• Knowledge of PPC/SEO analytics is a plus.

Responsabilidades

• Create custom reports and dashboards for high value clients using Power BI, Excel, and Google Sheets.
• Automate reports and data pulls from Google Ads, Meta, Bing, LinkedIn, and other sources.
• Define processes to reduce manual work and improve BI documentation.
• Interpret data from Google Analytics and ads platforms to derive actionable insights.

Conocimientos

Power BI

SQL

Google Analytics

Excel Pivot Tables

Educación

Bachelor's degree in math/stats/analytics or related field

Herramientas

Tableau

Descripción del empleo

About the Role

Optimal 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. 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.

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 Off
• Paid Leave for new parents
• Health insurance (including dental and vision)
• Flex Spending Plan
• Tuition Reimbursement
• 401K with company matching
• Professional development opportunities
• Rewards and recognition programs

Office Hours

This 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.