Bi Analytics Data Jobs

1 job found

Today

Digital Analytics & Marketing Data Analyst

Simons-Michelson-Zieve, Inc. Advertising (SMZ) Troy, MI

Troy, MI

Today

Full time Ad Tech Bi Analytics Business 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

View full job page →

Get Bi Analytics Data Jobs alerts

New Bi Analytics Data Jobs, daily.