DataJobs.io
← Back to all jobs
Simons-Michelson-Zieve, Inc. Advertising (SMZ)

Digital Analytics & Marketing Data Analyst

Simons-Michelson-Zieve, Inc. Advertising (SMZ)
Troy, MI Full time Posted 3h ago
Ad Tech Bi Analytics Business Analytics Data Analysis Data Analytics Data Integration Data Pipeline Data Processing Data Visualization Digital Advertising Digital Marketing Marketing Analytics Marketing Data Marketing Technology Power BI Reporting and Analytics
Apply Now

Job Description

SMZ Advertising Agency (Simons-Michelson-Zieve, Inc. Advertising, SMZ) is seeking an agile Digital Analytics & Marketing Data Analyst to support digital media analytics end to end. In this hybrid role in Troy, MI, you will connect marketing data sources, ensure data quality, build dashboards, and help internal teams and clients understand performance across channels.

What you’ll do

  • Integrate APIs and data feeds from platforms including DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis, and others into a central data visualization platform.
  • Lead data transformation, mapping, normalization, and troubleshooting to keep analytics reliable.
  • Analyze KPIs across digital channels such as social media, search, display ads, and email, and build dashboards to visualize results.
  • Evaluate digital campaign effectiveness by identifying strengths, weaknesses, and ROI to support budget allocation and optimization.
  • Track industry trends, emerging technologies, and competitor strategies to inform how the organization stays ahead in the digital space.
  • Collaborate with media partners as well as account and creative teams to communicate data insights to non-technical stakeholders.
  • Work with internal and external UI/UX teams to implement tracking codes.

Skills and qualifications

  • Experience connecting APIs/data feeds from platforms such as DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis.
  • Strong capabilities in data transformation, mapping, normalization, and troubleshooting.
  • Hands-on dashboarding experience with tools such as Looker Studio, Tableau, Power BI, Tapclicks, Datorama/Salesforce Marketing Intelligence or similar platforms.
  • Ability to develop dashboards and reports.
  • Perform data QA and reconciliation, including spotting discrepancies between buying platforms, databases, and dashboards.
  • Proficiency with Excel and/or Google Sheets.
  • Understanding of digital media metrics including impressions, clicks, CTR, CPM, CPC, conversions, attribution, spend, reach/frequency.
  • Marketing knowledge with comfort around digital marketing concepts, social media strategies, and content optimization.
  • Clear communication skills to present technical findings to marketing teams or clients.
  • Time management for competing priorities across multiple campaigns, stakeholders, and reporting cycles while maintaining accuracy.
  • Bachelor’s degree in marketing, analytics, or a related field and 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.

Tools and technologies

  • DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis
  • Looker Studio, Tableau, Power BI, Tapclicks, Datorama, Salesforce Marketing Intelligence
  • Excel, Google Sheets

Location

  • Hybrid remote in Troy, MI 48084
  • Minimum two days in the office

Similar Jobs