Customer Analytics Data Analyst (remote)
The Fountain Group · Santa Clara, CA · 1 mo ago
RemoteRemoteOTHR$60–$66.67/hrContract
100% remote role. W2 only. Duration: 8 months with extensions based on client need and performance.
Role Overview
We are seeking a detail-oriented Data Analyst to support B2B customer insights and insights analytics projects. This individual should be curious to uncover hidden insights. Knowledge of Customer Data Platforms is necessary to understand which systems produce which types of data to provide analytics and executive reporting. The role requires the ability to find business answers in data, leaning more towards strategy and customer operations analytics vs. number-crunching and data mapping.
Responsibilities
- Data Consolidation & Mapping: Extract, analyze, and consolidate data sets from multiple disparate sources (e.g., CRMs, ERPs, flat files) into a unified, centralized data repository.
- Single Source of Truth Management: Design and document complex data mapping rules and transformations to establish definitive, standardized definitions for cross-functional business metrics.
- Dashboard & Report Development: Design, build, and maintain interactive Tableau dashboards and automated reports that translate consolidated data into actionable insights for business stakeholders. Create reports in systems like Gainsight, Clarizen, and Salesforce.
- KPI Tracking & Analytics: Collaborate with leadership to define key performance indicators (KPIs) and build intuitive reporting structures that monitor business health, trends, and performance.
- Quality Assurance & Data Cleansing: Perform rigorous data profiling and validation to identify inconsistencies, resolve discrepancies, and ensure data integrity flows seamlessly from the backend systems to the front-end reports.
Requirements
- Bachelor's degree in Data Analytics, Information Systems, Computer Science, Statistics, or a related quantitative field.
- Minimum of 3+ years of relevant experience in data analysis, data mapping, and hands-on BI reporting/dashboarding.
- B2B Customer Analytics project experience.
- Advanced SQL query ability and expertise with Google Sheets/Excel.
- Tableau dashboard development experience.
- Ability to use AI tools to automate reporting.
- Experience with customer data platforms including Salesforce, Gainsight, and Clarizen is preferred.
Skills
- Data Visualization & Reporting: Hands-on experience building complex, interactive dashboards in Tableau (or similar BI tools) and translating business requirements into compelling visual data narratives.
- Data Mapping & Integration: Deep expertise in master data management (MDM), data mapping, and ETL/ELT concepts.
- Advanced SQL: High proficiency in writing complex SQL queries to extract, join, and manipulate large datasets across various relational databases.
- Dashboard UI/UX Design: Strong understanding of dashboard design principles and best practices, focusing on end-user experience, optimal chart selection, and minimizing cognitive load.
- Analytical Problem Solving: Exceptional ability to untangle messy data structures, spot logical conflicts between systems, and formulate standardized business rules for accurate reporting.
- Communication: Excellent written and verbal communication skills, with the ability to explain complex data trends and architectural concepts to non-technical stakeholders.
Pay
$60–$66.67/hour.