Data & BI Analyst jobs

Marketing Data Analyst

OptimalAustin, TXFull-timeHybridFirst seen 20 days ago

Pay not listed

Key facts

Schedule
Weekends
Where
Austin, TX · hybrid, 3 days on-site
Experience
2+ years
Degree
Bachelor's degree
US visa
No US visa sponsorship

Looks real. 1 thing to check before you apply.

On Optimal’s own careers site (JazzHR), checked open today.

  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteJazzHR board
  • Checked: Checked open todayJazzHR board
  • Checked: No reposts foundJazzHR board
  • Trust score 95 / 100 · Strong
See all 5 checksShow fewer
How we check

What you’ll do

  • Create custom client reports and actionable dashboards in Power BI, Excel, and Google Sheets.
  • Query marketing-platform data and help develop tools to pull data from additional sources; automate reporting with Power BI, SQL, and spreadsheet formulas.
  • Define and deploy processes to reduce manual work and errors, and maintain internal documentation.
  • Analyze campaign performance data and metrics, identify insights, and support account teams with findings.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 2+ years of experience in performance marketing-related analytics
  • 2+ years of experience using Power BI, Tableau, or similar platforms
  • 2+ years of SQL experience
  • Experience with PPC, SEM, or SEO marketing analytics (preferred)
  • Experience with Microsoft Azure Platform (preferred)
  • Experience with scripting languages (preferred)
  • Experience with HTML, JavaScript, or CSS (preferred)

Education

  • 4-year bachelor’s degree in mathematics, statistics, MIS, analytics, data science, business intelligence, or a related field

Skills

  • Advanced knowledge of Excel formulas, Pivot Tables, and Macros
  • Proficiency in Google Analytics

Other requirements

  • Must not require visa sponsorship

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Benefits

Dental & vision
Dental and vision coverage
Retirement plan
401(k) with company matching
Paid time off
Flexible Time Off
Parental leave
Paid leave for new parents
Learning & tuition
Tuition reimbursement, Professional development opportunities
Wellness & mental health
Employee Assistance Program
Other
Flex Spending Plan, Rewards and recognition programs

Also: health insurance

Full job description

From Optimal’s careers site

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.

Show full descriptionShow less

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. 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 Off
  • Paid Leave for New Parents
  • Health insurance (including dental and vision)
  • Flex Spending Plan
  • Employee Assistance Program
  • 401K with company matching
  • Tuition Reimbursement
  • 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.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Data Analyst

Vestwell · New York, NY +3 places

$70k–$80k/yrFull-timeHybrid

StrongChecked open todayPosted 18 days ago

Senior Data Analyst

Hippo Insurance · Austin, TX

Hybrid

StrongPay not listedChecked open todayPosted 28 days ago

Senior Data Analyst

Auctane · Austin, TX

Pay not listedHybrid

Strong2 to checkChecked open todayPosted 2 months ago

(SUMMER) Data Analyst Intern

Integra FEC - Internships · Austin, TX

Pay not listedInternship

Strong2 to checkChecked open todayPosted 2 months ago

(SPRING) Data Analyst Intern

Integra FEC - Internships · Austin, TX

Pay not listedInternship

Strong2 to checkChecked open todayPosted 2 months ago

See more like this