- Company Name
- Spectrum
- Job Title
- Senior Data Analyst - Spectrum Reach
- Job Description
-
**Job Title**
Senior Data Analyst – Spectrum Reach
**Role Summary**
Lead analytics for the Enterprise Strategy & Analytics team, extracting, integrating and modeling large datasets to deliver data‑driven insights on media performance, advertising outcomes and market trends. Build and maintain dashboards, automate reporting, and support sales, research, and client teams with actionable recommendations and attribution modeling.
**Expectations**
- Provide accurate, timely insights that inform media strategy and client decision‑making.
- Maintain high data quality, documentation, and reproducible processes.
- Communicate complex analyses clearly to stakeholders at all levels.
- Manage multiple projects, meet deadlines, and proactively flag issues.
**Key Responsibilities**
1. Extract, clean, and integrate data from internal systems and external sources (Nielsen, Comscore, Scarborough, etc.).
2. Design, develop, and maintain Tableau/Power BI dashboards to simplify data consumption for internal users.
3. Automate sales opportunity reporting and slide generation at scale.
4. Conduct media research and market trend analyses, producing concise reports and visualizations.
5. Develop and refine attribution methods for client campaigns, applying media math principles.
6. Document data definitions, quality requirements, and processes for sustainability.
7. Analyze usage metrics of internal dashboards and recommend optimizations.
8. Present findings and recommendations to business leaders and cross‑functional teams.
9. Collaborate with data engineers, product owners, and stakeholders to align on data strategy.
**Required Skills**
- Advanced SQL and Python for data extraction, transformation, and analysis.
- Proficiency with Tableau, Power BI, or equivalent BI tools.
- Experience with cloud data warehouses (e.g., Snowflake, Redshift, BigQuery).
- Strong Excel skills (advanced functions, pivot tables).
- Knowledge of data integration/ETL concepts; experience with Alteryx preferred.
- Familiarity with media math, attribution modeling, and campaign measurement.
- Excellent analytical, storytelling, and presentation skills.
- Project management abilities, ability to document processes, and manage deadlines.
- Detail‑oriented, accurate, and able to work independently and within a collaborative team.
**Required Education & Certifications**
- Bachelor’s degree in Marketing Analytics, Data Analytics, Statistics, Computer Science, or a related field.
- Minimum 4 years of professional data analytics experience.
- Preferred: 2+ years in media research, marketing, or sales enablement.
- Relevant certifications (e.g., Microsoft Certified: Azure Data Scientist Associate, Tableau Desktop Specialist, or similar) are a plus.