Data Analyst-Market Mix Modeling+Ms-Excel&SQL

Job description
Analytics Operations Analyst – Marketing Mix Modeling

The Analytics Operations Analyst will support marketing analytics agenda by executing pre-built marketing mix models, validating inputs and outputs, and translating results into actionable insights. This role focuses on data readiness, model execution, diagnostics, optimization scenarios, and stakeholder-ready readouts, rather than model development.

Responsibilities
• Collect, review, and validate all required inputs for marketing mix analyses, including target lists, segments, deciles, forecasts, and promotional data.
• Execute pre-built marketing mix models following established methodologies and standard operating procedures.
• Run detailed data and model diagnostics to assess data integrity, model stability, and result reasonableness.
• Build historical promotional performance assessments and standardized analytical readouts.
• Budget Optimization & Scenario Planning
• Stakeholder & Cross-Functional Collaboration
• Operational Excellence & Prioritization

Qualifications
• 1–5 years of experience in marketing analytics, commercial analytics, or analytics operations.
• Hands-on experience working with marketing mix models or related analytical frameworks (execution, interpretation, or validation).

Required Skills
• Strong analytical skills with the ability to validate datasets, interpret model outputs, and identify anomalies.
• Experience preparing executive-ready analytical summaries and presentations.

Preferred Skills
• Proficiency in SQL and/or analytical tools (e.g., Python, R, SAS) for data validation and analysis.
• Experience working with large, multi-source marketing and sales datasets.
• Familiarity with optimization concepts and scenario modeling.
• Comfort working within structured analytical workflows and SOP-driven environments.