Digital Analytics & Marketing Data Analyst Job Troy area,Michigan USA,IT/Tech

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 Big Query, Snowflake, or Redshift
Knowledge of ad-tech data structures and campaign taxonomy