Marketing Data Analyst

Winwithoptimal; Austin (TX); Hybrid; USD 65,000 - 95,000; Full time

Benefits offered by this job

Health insurance

401K with company matching

Tuition Reimbursement

Flexible Time Off

Paid Leave for new parents

Flex Spending Plan

Professional development opportunities

Rewards and recognition programs

Job summary

Optimal is seeking a Marketing Data Analyst to join our Austin-based BI team. The role partners with Paid Media and SEO to quantify client performance and automate reporting, transforming descriptive data into actionable dashboards.

The ideal candidate has 2+ years in performance analytics, strong SQL, Power BI, and Google Analytics experience, plus a solid Excel toolkit. Hybrid work from our Austin office is offered.

Qualifications

• 4-year degree in math/analytics or related field.
• 2+ years in performance marketing analytics.
• 2+ years using Power BI/Tableau or similar dashboards.
• 2+ years SQL experience.
• Experience with PPC/SEO analytics a plus.
• Advanced Excel skills (formulas, Pivot Tables, macros).
• Familiarity with Google Analytics and HTML/JS is a plus.

Responsibilities

• Create custom dashboards for high-value clients in Power BI, Excel, and Google Sheets.
• Automate reports and integrate data from multiple sources (ads platforms, CRMs).
• Define and optimize BI processes to reduce manual work and improve consistency.
• Interpret data and extract insights on CTR, ROAS, conversions, and attribution windows.

Skills

SQL

Power BI

Google Analytics

Excel

Data visualization

Education

Bachelor's degree in analytics

Tools

Tableau

Microsoft Azure

Job description

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.

Who Are We?

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.

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.