Client Note : We need to find candidates with Tableau, Data Integration with Salesforce, snowflake, etc. Along with Marketing Data Analyst domain knowledge
We are seeking a data-driven Senior Business Analyst to join our team. You will be the bridge between our raw data and strategic decision-making, responsible for extracting insights from our data warehouse and visualizing them to drive growth across Sales and Marketing.
## Core Responsibilities
Advanced Data Extraction: Use Advanced SQL to write complex, performant queries that extract and join data from our centralized data warehouse.
Cross-Functional Data Expertise: Act as the subject matter expert for our core data schemas, specifically focusing on Salesforce (CRM), HubSpot/Marketo (Marketing Automation), and Google Analytics (Web Traffic).
Dashboard Development: Design, build, and maintain automated, high-impact dashboards in Tableau Server that provide a "single source of truth" for the leadership team.
KPI Management: Define and track critical Sales and Marketing KPIs, with a heavy focus on marketing engagement and multi-touch attribution models.
Insight Generation: Translate complex data sets into actionable narratives that help optimize the sales funnel and marketing spend.
## Required Qualifications & Skills
Technical Prowess
Expert-Level SQL: Proficiency in writing window functions, complex joins, and CTEs to manipulate large datasets.
Tableau Server Mastery: Proven experience building scalable dashboards, managing data extracts, and utilizing Level of Detail (LOD) expressions.
SaaS Tool Stack: Deep architectural understanding of how Salesforce objects (Leads, Contacts, Opportunities) relate to Marketing Automation objects (Programs, Campaigns).
Web Analytics: Experience querying and interpreting Google Analytics or similar website clickstream data to understand the user journey.
## Preferred Experience
Experience with Snowflake, BigQuery, or Redshift data warehouses
Knowledge of data modeling tools like dbt.
Prior experience in a high-growth B2B SaaS environment.