Note: The job is a remote job and is open to candidates in USA. Aquent is seeking a Marketing Analytics Analyst to support ongoing analytics operations, reporting, and performance tracking for marketing initiatives. The role involves data preparation, reporting, analytical validation, and generating actionable insights to ensure data integrity across multiple sources.
Responsibilities
- Prepare and deliver weekly marketing performance reports, including:
- Data cleaning and validation
- Data organization and structuring
- Audit checks for accuracy and completeness
- Summary insights and key takeaways
- Build and maintain repeatable reporting processes and templates
- Conduct data comparisons between agency reporting and internal data sources
- Identify discrepancies and determine root causes
- Provide documentation and recommendations to improve alignment and reporting accuracy
- Track and maintain a centralized log of marketing tests (A/B and multivariate)
- Analyze test results, including:
- Performance lift evaluation
- Directional statistical insights
- Business impact assessment
- Summarize findings and recommendations for stakeholders
- Develop monthly performance review reports covering:
- Channel and campaign performance
- Business outcomes such as leads, conversions, and revenue indicators
- Test learnings and optimization opportunities
- Deliver actionable insights and recommendations to leadership
- Maintain and update marketing performance scorecards
- Monitor KPIs against targets and historical benchmarks
- Identify trends, risks, and opportunities for improvement
- Support leadership and marketing teams with quick-turn analytical requests
- Translate business questions into structured analysis
- Deliver clear, insight-driven recommendations
- Weekly reporting packages including validated datasets and performance insights
- Monthly performance review reports and presentations
- Marketing test tracking logs and analysis summaries
- KPI scorecards and performance dashboards
- Ad hoc analytical reports as needed
Skills
- Bachelor's degree in Analytics, Business, Marketing, Economics, Statistics, Information Systems, or a related field
- 2–5 years of experience in: Marketing Analytics, Business Intelligence, Consulting, Finance, or related analytical roles
- Advanced Microsoft Excel skills, including: Pivot Tables, Power Query, XLOOKUP / INDEX-MATCH, SUMIFS and advanced formulas, Data cleansing and transformation, Large dataset management
- Experience building: Automated reporting frameworks, Recurring dashboards and performance scorecards
- Strong problem-solving and root cause analysis abilities
- Ability to synthesize complex data into actionable insights
- Strong organizational skills with the ability to manage multiple priorities independently
- Excellent written and verbal communication skills
- Ability to present findings clearly to both technical and non-technical stakeholders
- Experience with SQL and reporting logic
- Familiarity with: Google Ads, Google Analytics, CRM platforms, Call tracking tools
- Experience with: Attribution modeling, Conversion funnel analysis, A/B testing and measurement
- Experience supporting multi-location businesses or service-based organizations
- Background in budget planning, forecasting, or financial performance analysis
Company Overview
Company H1B Sponsorship