
Contract - Customer & Marketing Data Analyst
Job Description
Responsibilities
1. Reporting & Monitoring – 35%
- Provide monthly reports on marketing performance to key stakeholders.
- Perform deep-dive and ad-hoc analyses on marketing initiatives, campaign performance, audience behavior, and utilization data.
- Proactively monitor and track marketing KPIs (e.g., CTR, CPA, ROAS, Conversion Rates).
- Translate findings into actionable insights and optimization opportunities for stakeholders through reports and presentations.
2. Data Collection & Management – 25%
- Extract and clean data from marketing platforms (e.g., Google Analytics 4, Social Media Platforms, Salesforce Marketing Cloud) for analysis and database storage.
- Ensure proper campaign tagging and tracking implementations (e.g., UTM Parameters, Google Tag Manager), including documentation.
- Write, optimize, and document SQL queries to retrieve data from databases.
- Support the development of marketing tables and views in database schemas.
3. Automation & Dashboard Development – 25%
- Build and maintain marketing reporting dashboards using BI tools (Tableau, Power BI).
- Apply visualization best practices for clarity and usability.
- Conduct routine quality assurance checks to ensure data accuracy and consistency.
- Work closely with marketing teams to collect business requirements and documentation.
4. Collaboration & Insights Generation – 15%
- Create clear, concise reports and presentations for stakeholders to inform decision-making with data-driven recommendations.
- Work cross-functionally with other analyst(s) and data engineers to support analysis and data integration