SMZ Advertising Agency (Simons-Michelson-Zieve, Inc. Advertising) is hiring an agile Digital Analytics & Marketing Data Analyst to strengthen the data foundation behind digital media analytics. This hybrid role in Troy, MI (48084) supports cross-team collaboration across Creative, Account, and Media, helping clients and internal partners make smarter decisions with trusted reporting.
You will connect marketing and ad-tech data into a central visualization environment, ensure data quality, and build dashboards that translate performance into actionable insights for non-technical stakeholders. With at least two days per week in the office, you can balance collaboration with focus time.
What you’ll do
- Integrate APIs and data feeds from platforms such as DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis, and others into a central data visualization platform.
- Own data transformation, mapping, normalization, and ongoing troubleshooting to keep reporting consistent and reliable.
- Analyze key performance indicators across digital channels, including social media, search, display ads, and email, and create dashboards to visualize performance.
- Evaluate campaign effectiveness, identifying strengths, weaknesses, and ROI to inform budget allocation and optimization.
- Track industry trends, emerging technologies, and competitor strategies to help keep the team competitive in the digital space.
- Partner with media counterparts and work with Account and Creative teams to communicate data insights clearly to non-technical stakeholders.
- Collaborate with internal and external UI/UX teams to implement tracking codes.
What you bring
- 3+ years of experience and a Bachelor’s degree in marketing, analytics, or a related field.
- Hands-on ability connecting APIs/data feeds from platforms such as DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis, and similar sources.
- Experience with data transformation, mapping, normalization, and troubleshooting.
- Working knowledge of visualization and reporting tools, including Looker Studio, Tableau, Power BI, Tapclicks, Datorama/Salesforce Marketing Intelligence, or comparable platforms.
- Strong dashboard and report development skills.
- Data QA and reconciliation experience, including spotting discrepancies between buying platforms, databases, and dashboards.
- Strong Excel and/or Google Sheets skills.
- Understanding of digital media metrics such as impressions, clicks, CTR, CPM, CPC, conversions, attribution, spend, and reach/frequency.
- Marketing knowledge that supports social media strategies and content optimization.
- Clear communication skills to present technical findings to marketing teams or clients.
- Time management to handle competing priorities across campaigns and reporting cycles while maintaining accuracy.
Additional strengths (preferred)
- Experience 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.
Technologies: DV360, Google Ads, Meta, The Trade Desk, Amazon Ads, Basis, Looker Studio, Tableau, Power BI, Tapclicks, Datorama, Salesforce Marketing Intelligence, Excel, Google Sheets
