Marketing Data Analyst

Optomi, in partnership with a leading financial services company, is seeking a Marketing Data Analyst to join their team! You will bridge the gap between our technical data infrastructure and our marketing strategy. This role is ideal for someone who is equally comfortable writing complex SQL queries as they are managing project timelines and explaining marketing ROI to stakeholders. You will ensure our marketing decisions are backed by clean, accessible data and that Enterprise data integration projects are delivered on schedule.

Qualifications:

• Strong Oracle SQL / database expertise
• Deep understanding of Data Warehousing (e.g., Snowflake, BigQuery) and Relational Database Management Systems (RDBMS).
• Working proficiency of SQL (joins, CTEs, window functions) for data extraction and manipulation.
• Working proficiency in Marketing in general, and Marketing Analytics in specific, including attribution modeling, funnel analysis.
• Proficient in both Marketing & Sales tools and data. Tools: Google Analytics, Adobe Analytics, Marketo, MS Dynamics 365, Salesforce etc.
• Working proficiency in data visualization tools like Tableau, Power BI.
• Strong Project Coordination skills; experience with Agile/Scrum or tools like Jira, Asana, or Trello.
• Ability to translate complex data findings into "plain English" for non-technical marketing stakeholders.

Responsibilities:

• Identify the business use cases from our stakeholders. Source the data from the relevant platform to fulfill the use cases. Understand and perform relational data-modeling.
• Act as the custodian of the marketing data warehouse. Ensure data from various sources (CRM, Ads, Web Analytics etc.) are properly integrated and structured for consumption by the analysts and other users.
• Write and optimize database queries to develop regular and ad-hoc reports.
• Educate analysts on leveraging specific data sets to meet business objectives, including technical, hands-on instructions.
• Serve as the "connective tissue" between the Data Engineering and the Marketing Analytics teams. Define and manage project scopes, and ensure technical deliverables meet marketing business use cases and requirements and project timelines.
• Identify and resolve data discrepancies between various marketing platforms and the Enterprise data warehouse.