This is a contract role for 12 Months in our San Jose Office.
Job Overview:
We're looking for a marketing data analyst to join the Demand Generation Activation team in our San Jose office on a 12-month contract. Our team is made up of three functions, data & analytics, marketing automation, and paid media. You'll be joining our data & analytics function.
You will work closely with the other data analysts in our team as well as colleagues in the digital team, developer marketing team and the broader demand generation campaign team. This is an excellent opportunity for a collaborative and eager-to-learn individual looking to grow their marketing and digital data knowledge and abilities by joining a dedicated team with deep expertise.
Responsibilities:
Adobe Analytics Reporting: Build and maintain reports in Adobe Analytics Workspace to support the marketing department and other digital platform owners.
Data Integration and Queries: Write SQL queries in Google Cloud Platform's BigQuery to combine Adobe Analytics web data with other data sources including CRM, email, digital ad channels and social media channels to support cross-channel reporting.
Audience Segmentation: Use Adobe Analytics or BigQuery to define and set up target audiences based on behavioral traits, user profiles, and account profiles.
Dashboard Development: Create dashboards using Power BI, integrating data from our data mart (in Google Cloud Platform's BigQuery) and other relevant sources.
Communicate insights and findings from your analysis to colleagues, both technical (your data team colleagues) and non-technical marketing colleagues.
Required Skills and Experience :
Marketing Data Expertise: Familiarity with marketing data (both transactional and digital), including campaign tracking, web activity, CRM data, UTM parameters, and lead generation.
SQL Proficiency: Writing of SQL queries, creating relationships, and joining data from multiple sources.
Adobe Analytics Proficiency: Experience with Adobe Analytics Workspace, creating segments, calculated metrics, and understanding core dimensions and measures.
Dashboard Tools: Experience with Power BI or similar BI tools (e.g., Looker, Tableau) for visualizing and reporting data.
"Nice To Have" Skills and Experience :
Experience with JavaScript, Python, or R programming.
Familiarity with API endpoints and webhooks for data activation purposes.
Familiarity with data modeling in dbt, common table expressions, joins, and groupings.
Experience creating data pipelines, or familiarity with ETL / ELT processes.