Senior Marketing Analyst

Objective Partners; Oakland (CA); On-site; USD 110,000 - 165,000; Full time

Job summary

Objective Partners is seeking a Senior Marketing Analyst in Oakland, CA to turn complex marketing data into actionable insights that drive strategy and ROI. You will own SQL data transformations, build robust Power BI dashboards, and partner with marketing leaders to measure attribution and performance across digital and offline channels.

You will design scalable data models, validate data quality, create executive-ready reporting, and advocate for automation to improve efficiency and

Qualifications

• Advanced SQL skills for transforming large marketing datasets.
• Experience building Power BI datasets, semantic models, and DAX measures.
• Ability to design data models supporting flexible slicing and executive reporting.

Responsibilities

• Develop and maintain advanced SQL queries to transform and analyze marketing, customer, and revenue data.
• Build analytical datasets and reporting tables for performance, attribution, and experimentation.
• Develop and optimize Power BI models, measures, and dashboards for executives.

Skills

Advanced SQL

Power BI & DAX

Data modeling

Multi-channel analysis

Executive reporting

Data quality

Education

Bachelor's degree in analytics/statistics/economics/marketing

Tools

Snowflake

BigQuery

Azure Synapse

Job description

We are seeking a highly skilled and technically strong Senior Marketing Analyst with deep expertise in SQL and Power BI to support, measure, and optimize marketing performance across both digital and offline channels. This is a hands‑on, data‑driven role focused on transforming complex datasets into reliable insights that inform marketing strategy and business decisions.

Responsibilities

• Develop and maintain advanced SQL queries to transform, aggregate, and analyze large-scale marketing, customer, and revenue datasets.
• Build and maintain analytical datasets and reporting tables supporting marketing performance, attribution, and experimentation.
• Develop, manage, and optimize Power BI semantic models, DAX measures, and dashboards used by marketing leaders and executives.
• Create executive‑level dashboards that clearly communicate performance, trends, and key drivers across channels including PPC, SEO, Paid Social, Organic Social, Display, Email, CTV, Linear TV, Print, and OOH.
• Monitor and validate data quality, investigate anomalies, and ensure consistency across reporting sources and dashboards.
• Translate complex analytical findings into clear, actionable insights and recommendations for senior leadership.
• Identify opportunities to improve reporting automation, scalability, efficiency, and performance.
• Support additional analytical initiatives and responsibilities as needed.

Required Skills & Qualifications

• Advanced SQL expertise, including complex joins, CTEs, window functions, and query performance optimization.
• Strong experience building and maintaining Power BI datasets, semantic models, dashboards, and advanced DAX measures.
• Demonstrated ability to design data models that support flexible slicing, multi‑period comparisons, and executive‑level reporting.
• Experience analyzing multi‑channel marketing data from platforms such as Google, Bing, Meta, and programmatic or CTV platforms.
• Strong understanding of marketing KPIs, attribution concepts, and performance measurement frameworks.
• Ability to translate technical analysis into clear business insights and effectively communicate findings to non‑technical stakeholders.

Preferred Skills & Qualifications

• Bachelor's degree or equivalent experience in analytics, statistics, economics, marketing, or a related field.
• Experience working with cloud data warehouses such as Snowflake, BigQuery, Azure Synapse, or similar technologies.
• Familiarity with data modeling concepts including star schemas, slowly changing dimensions, and fact tables.
• Experience with attribution modeling, incrementality testing, or causal inference methodologies.
• Experience optimizing Power BI performance, including query folding, data models, and report performance.
• Familiarity with Python or R for advanced analytics is a plus.
• Experience with GA4, Google Tag Manager, and marketing data integrations.
• Experience working with ServiceTitan or similar operational data platforms is a plus.