Digital Analytics & Marketing Data Analyst
SMZ Advertising Agency is seeking an agile Digital Analytics & Marketing Data Analyst to manage the data infrastructure behind digital media analytics, including platform integrations, data quality assurance, dashboard development, and client reporting.
SMZ is a collaborative place. You'll partner with the Creative, Account, and Media teams while setting the bar for concept and craft. We work hybrid, with a minimum of two days in the office, because we believe the best ideas happen when people are in the room together. In return, we'll give you the space to dream big, be challenged, and challenge others — internally and on the client side. Help us grow our agency and our clients' businesses, and we'll help you grow your career.
Key Responsibilities:
- Technical setup: Connect APIs/data feeds from platforms such as DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis etc. into a central data visualization platform. Oversee data transformation, mapping, normalization, and troubleshooting
- Data Analysis & Reporting: Analyze key performance indicators (KPIs) across digital channels (social media, search, display ads, email) and create dashboards to visualize performance.
- Campaign Evaluation: Assess the effectiveness of digital marketing campaigns, identifying strengths, weaknesses, and ROI to advise on budget allocation and optimization.
- Market Research: Monitor industry trends, emerging technologies, and competitor strategies to help keep the organization ahead in the digital space.
- Collaboration: Work with media counterparts in addition to account and creative teams to communicate data insights to non-technical stakeholders. Collaborate with internal and external UI/UX teams to implement tracking codes.
Required Skills and Qualifications:
- Connecting APIs/data feeds from platforms: such as DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis etc.
- Data transformation, mapping, normalization, and troubleshooting
- Looker Studio, Tableau, Power BI, Tapclicks, Datorama/Salesforce Marketing Intelligence, or similar visualization platforms
- Dashboard/report development
- Data QA and reconciliation—spotting discrepancies between buying platforms, databases, and dashboards
- Strong Excel/Google Sheets
- Understanding of digital media metrics: impressions, clicks, CTR, CPM, CPC, conversions, attribution, spend, reach/frequency
- Marketing Knowledge: Understanding of digital marketing concepts, social media strategies, and content optimization.
- Communication Skills: Ability to present technical findings clearly to marketing teams or clients.
- Time Management: Proven ability to manage competing priorities across multiple campaigns, stakeholders, and reporting cycles while maintaining a high level of accuracy.
- Experience: Bachelor's degree in marketing, analytics, or a related field, with 3+ years of experience.
Preferred Qualifications:
- Experience working with SQL
- Knowledge of ETL/ELT processes
- Experience with data warehouses such as BigQuery, Snowflake, or Redshift
- Knowledge of ad-tech data structures and campaign taxonomy
Work Location: Hybrid remote in Troy, MI 48084
