Digital Analyst II , short-term freelance
Summary
Freelance Digital Analyst II supporting a Kia account at an ad agency, analyzing digital channel performance, writing SQL against large event-level datasets, and building/maintaining dashboards using GA4, BigQuery, Looker, and Tableau.
INNOCEAN USA, a full-service advertising agency located in Huntington Beach, is seeking a freelance Digital Analyst II to join our Kia team!
This is a contract role starting ASAP through 1/29/27.
We are a hybrid workplace, x3 days week in-office. Candidates must be local to SoCal.
We are seeking a data science-oriented Digital Analyst to support our digital analytics and data engineering team in collecting, validating, and reporting on website performance and working with media data. Looking for a candidate who lives in the data, not just the dashboard - focused on using data to generate insights and power data-driven decisions across the business for our client. You will work with a team of analysts and engineers responsible for collecting, ingesting, monitoring, measuring, and improving the health and performance of our digital channels, while supporting the transformation layer that turns raw event data into trusted, analysis-ready datasets. If you've ever fixed a report by fixing the table behind it, this is your role.
The Digital Analyst II will work closely with senior analysts, directors, strategists, and cross functional partners to ensure accurate data collection and clear reporting that drives insights.
ESSENTIAL DUTIES/RESPONSIBILITIES
Analysis & Insight
- Analyze channel performance metrics, identify trends, and support data-driven decisions to improve results
- Translate raw data into clear, actionable recommendations for stakeholders and strategy partners
- Support ad hoc analysis requests and presentation preparation for internal teams and clients
Data Engineering & Modeling
- Write performant SQL to process large event-level datasets
- Contribute to data architecture, including scheduled jobs, workflows, and basic orchestration
- Implement data quality checks, freshness monitoring, and validation logic so problems surface before stakeholders finds them
- Partner with senior level data engineers on ingestion, table design, and access patterns; support the layer between raw data and reporting
Reporting & Data Hygiene
- Build and maintain recurring reports and dashboards using Google Analytics 4, BigQuery, Databricks SQL, Looker, Tableau, or similar platforms
- Document definitions and metric logic so the business trusts a single source of truth
- Partner with internal teams to understand reporting needs and measurement goals