IMM is looking to solve the problem of managing and optimizing their proprietary cross-channel last-touch attribution model while ensuring the accuracy and integrity of their performance media measurement ecosystem.
Requirements
- Strong SQL knowledge, with proven experience writing complex queries
- Hands-on experience managing ETL processes and troubleshooting data pipeline
- Familiarity with data warehousing, stored procedures, and relational data sets ideally in AWS Redshift
- Proficiency in Microsoft Excel and comfort with advanced functions
- Experience with data visualization and reporting tools (Tableau, Looker Studio, etc.)
- Ad Operations and GTM experience, with a strong sense of data hierarchy
- Comfort with marketing and media platforms, including knowledge of attribution models and pixel-based tracking
Responsibilities
- Maintain Daily Data Operations
- Monitor and validate data pipelines in Adverity and AWS
- Troubleshoot and resolve data ingestion or transformation errors
- Automate repetitive processes using SQL and optimize DB function
- Build and maintain weekly/monthly reports for clients
- Update Tableau & Adverity dashboards to reflect current campaign performance and business KPIs
- Manage pixel placements across channels and troubleshoot discrepancies
Other
- 3–5 years of experience as a Data Analyst, preferably in a marketing, advertising, or media environment
- Bachelor’s degree in a quantitative field (e.g., Marketing Analytics, Information Systems, Computer Science, Statistics) or equivalent work experience
- Strong communication and storytelling skills–you can distill complex data into insights that influence decisions
- A blend of technical ability and business acumen—you can both build the pipeline and explain the “so what” of the data
- Time off is as important as hard work! Salaried employees are on a Flex PTO plan
