Marketing Intelligence Analyst
UKG
·Today
- Location
- BG
- Workplace
- Remote
- Type
- Full-time
- Department
- Marketing
- Experience
- 5+ years
- Education
- Bachelor
- Source
- Eightfold
Description
Design and optimize datasets and data structures for both human analysis and AI model consumption, ensuring data schemas are normalized, documented, and AI-ready Define and maintain core marketing metrics and KPIs including attribution models, customer acquisition cost (CAC), customer lifetime value (CLV), and funnel metrics; ensure consistent definitions across all dashboards, reports, and downstream analytical systems Interface with marketing's internal customers to gather project requirements and transform those requirements into actionable analytics deliverables Build strategic analytics solutions including reports, metrics, scorecards, dashboards, KPIs, and datasets that are technically sound, scalable, and optimized for downstream AI applications Build and optimize datasets that support marketing measurement frameworks such as media mix modeling, incrementality testing, and multi-touch attribution analysis across paid, email, and organic channels Establish and enforce data governance frameworks including documentation standards, data lineage tracking, quality metrics, and source-of-truth definitions to ensure analytical integrity Create analytics dashboards and reporting systems in visualization tools (Power BI or Tableau) with attention to technical architecture, performance optimization, and readiness for AI-assisted analysis Write production-quality SQL and Python code to query structured and unstructured data, build complex data models, perform statistical analysis, and automate routine analytics workflows Collaborate with data engineers and data scientists to ensure datasets meet requirements for machine learning pipelines and predictive modeling initiatives Identify and implement technical improvements to data collection, storage, and processing, reducing query latency, improving data quality, and optimizing cloud costs Presentation skills and business stakeholder engagement: Demonstrated ability to present analytical findings and recommendations to non-technical stakeholders; skill in translating complex data insights into clear, actionable business language; experience gathering requirements from business partners and managing expectations Familiarity with AI and large language models (Claude, GPT, Codex); demonstrated ability to structure and present data in formats optimized for AI analysis and model training 5+ years of hands-on data analytics experience with a focus on technical implementation and dataset development (marketing, sales, finance, or similar data-intensive domains) 5+ years of professional SQL experience with demonstrated ability to write complex queries, optimize performance, work with unstructured/structured data, and design efficient schema structures 3+ years of experience with data visualization tools (Power BI or Tableau) with focus on technical architecture, performance tuning, and dashboard optimization 2+ years of hands-on experience with Python for data manipulation, analysis, and automation (pandas, NumPy, or equivalent libraries); ability to write clean, maintainable code Marketing domain knowledge: Understanding of marketing funnel concepts, attribution modeling, CAC, CLV, and key marketing metrics and KPIs; ability to translate marketing measurement requirements into data architecture Attribution and multi-touch analytics: Familiarity with marketing attribution models (first-touch, last-touch, multi-touch) and the technical challenges of building datasets that support attribution analysis across multiple marketing channels Strong proficiency in building and documenting data models including understanding of normalization, dimensional modeling, and statistical foundations (correlation, distribution, hypothesis testing) Hands-on experience with cloud data platforms (BigQuery, Redshift, Snowflake, or Azure Synapse) with understanding of data quality principles, validation, governance, and cost optimization; comfortable with cloud-native analytics architecture Understanding of data quality and governance practices including metric definitions, data validation, error detection, and production analytics systems Strong technical communication and documentation skills, with ability to clearly document data architecture, explain technical decisions, and maintain comprehensive metadata—especially critical for remote collaboration across time zones Comfort collaborating with cross-functional technical teams including data engineers, data scientists, and product teams on complex, multi-phase analytics initiatives Eagerness and ability to learn new skills as our team's goals and priorities evolve over time Bachelor's degree in Computer Science, Statistics, Mathematics, Data Science, or related technical field Experience designing analytics systems specifically optimized for AI integration or preparing datasets for machine learning pipelines Marketing measurement frameworks: Knowledge of marketing measurement methodologies such as Media Mix Modeling (MMM), incrementality testing, or customer journey analysis; understanding of how to structure data to support these analytical approaches Marketing data sources expertise: Hands-on experience working with marketing data ecosystems including paid advertising platforms (Google Ads, Meta Ads Manager), email marketing data, marketing automation platforms, and web analytics; understanding of how these systems track and transmit customer interaction data Proficiency with version control systems (Git) and understanding of CI/CD practices for analytics code Experience with marketing automation platforms (Eloqua, Marketo) and technical understanding of how marketing attribution data flows through enterprise systems Knowledge of Google Cloud Platform (GCP) including BigQuery, Dataflow, and GCP's analytics ecosystem Advanced SQL skills including window functions, recursive queries, and performance optimization techniques