Senior Marketing Analyst

Talution Group; Oakland (CA); On-site; USD 90,000 - 140,000; Full time

Job summary

Talution Group is seeking a highly skilled Senior Marketing Analyst to turn complex datasets into actionable insights across digital and offline channels in Oakland.

You will own SQL-based data pipelines, build Power BI dashboards for executives, and partner with marketing teams to optimize performance, attribution, and reporting automation.

Qualifications

• Advanced SQL with joins, CTEs, window functions, and query tuning.
• Experience building Power BI datasets, semantic models, dashboards, and DAX.
• Design data models for flexible slicing and executive reporting.
• Experience analyzing multi-channel marketing data from ad platforms.
• Strong KPI, attribution, and measurement framework knowledge.
• Ability to translate analysis into clear business insights for non-tech stakeholders.

Responsibilities

• Develop and maintain advanced SQL queries over marketing and revenue data.
• Build analytical datasets and reporting tables for performance and attribution.
• Develop Power BI semantic models, DAX measures, and dashboards for executives.
• Create executive dashboards across PPC, SEO, Social, Email, TV, Print, OOH.
• Monitor data quality and investigate anomalies across sources.
• Translate findings into actionable insights for senior leadership.
• Identify opportunities to automate reporting and improve scalability.

Skills

Advanced SQL

Power BI

DAX

Data modeling

Marketing analytics

Attribution concepts

Education

Bachelor's degree in analytics, statistics, economics, marketing, or related field

Tools

Snowflake

BigQuery

Azure Synapse

GA4

Google Tag Manager

Power BI Desktop

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.