Digital Analytics & Marketing Data Analyst

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