Digital Analytics & Marketing Data Analyst

Simons-Michelson-Zieve, Inc. Advertising (SMZ); Troy (MI); Hybrid; USD 90,000 - 130,000; Full time

Job summary

SMZ Advertising Agency in Troy, MI seeks a Digital Analytics & Marketing Data Analyst to support end-to-end digital media analytics in a hybrid role. You will connect marketing data sources, ensure data quality, build dashboards, and help teams and clients understand performance across channels.

Responsibilities include integrating data feeds from major platforms, transforming data, and analyzing KPIs to guide budget and optimization decisions.

Qualifications

• Bachelor's degree in marketing, analytics, or a related field.
• 3+ years of experience in digital analytics or marketing data roles.
• Experience integrating data from multiple ad platforms.

Responsibilities

• Integrate APIs and data feeds from 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 ensure reliable analytics.
• Analyze KPIs across digital channels and build dashboards to visualize results for stakeholders.

Skills

API integration

Data transformation

Dashboarding

KPI analysis

Communication

Project management

Education

Bachelor's degree in marketing/analytics

Tools

Looker Studio

Tableau

Power BI

TapClicks

Datorama

Salesforce Marketing Intelligence

Excel

Google Sheets

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