Digital Analytics & Marketing Data Analyst

Simons Michelson Zieve, Inc.; Troy (MI); Hybrid; USD 70,000 - 100,000; Full time

Job summary

SMZ Advertising Agency in Michigan 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.

We work hybrid with a minimum of two days in the office; you’ll partner with Creative, Account, and Media teams while setting the bar for concept and craft.

Qualifications

• Bachelor’s degree in marketing, analytics, or related field; 3+ years of experience.
• Experience 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.
• Strong Excel/Google Sheets.
• Understanding of digital media metrics: impressions, clicks, CTR, CPM, CPC, conversions, attribution.
• Marketing knowledge of digital marketing concepts and content optimization.
• Communication skills to present technical findings to marketing teams or clients.
• Time management to handle multiple campaigns and reporting cycles with accuracy.

Responsibilities

• Technical setup: Connect APIs/data feeds from platforms into a central data visualization platform; oversee data transformation and troubleshooting.
• Data Analysis & Reporting: Analyze KPIs across digital channels and create dashboards to visualize performance.
• Campaign Evaluation: Assess ROI and advise on budget allocation and optimization.
• Market Research: Monitor industry trends, emerging technologies, and competitor strategies.
• Collaboration: Work with media, account, and creative teams to convey insights to non-technical stakeholders; collaborate with UI/UX teams on tracking implementations.

Skills

API integration

Data transformation

Data QA

Dashboard development

KPI analysis

Excel/Google Sheets

Digital media metrics

Communication

Time management

Education

Bachelor’s degree in marketing, analytics, or related field

Tools

Looker Studio

Tableau

Power BI

TapClicks

Datorama/Salesforce Marketing Intelligence

SQL

BigQuery

Snowflake

Redshift

Job description

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