CRM Marketing Data Analyst
Job Summary
This role involves strategic leadership in driving bottom-line profit and Customer Lifetime Value (LTV) for a growing tech firm. You will own profit dashboards, design CRM journeys, and standardize marketing data infrastructure. The position requires a mix of analytical expertise and business strategy implementation within a collaborative, data-driven environment.
Responsibilities
- Manage and optimize profit dashboards for true ROI calculation
- Design and automate CRM journeys to maximize LTV
- Standardize marketing data infrastructure and ensure clean data flow
- Conduct A/B testing and performance analysis
Required Skills
- 3-7 years experience in Data Analysis or CRM/Performance Marketing
- Proficiency in GA4, Looker Studio, and advanced Excel/Sheets
- Business-level proficiency in both English and Japanese
- Strong understanding of business metrics (GP, CAC, ROAS, LTV)
Job Details
### Job Description
This is not a simple data-entry role. You will be a strategic leader responsible for evolving our marketing organization into a powerhouse that drives the "bottom-line profit" and "Customer Lifetime Value (LTV)" across all our services.
### Key Highlights
- High Strategic Impact: Your analysis will directly influence company-level budget allocations and executive decision-making.
- Beyond "Clicks": Move past simple CPA management to master "True ROI" by factoring in COGS, payment fees, and unit economics.
- Full Ownership from Day One: You will have the autonomy to design CRM journeys and standardize data infrastructure from the ground up.
- Global Collaboration: Work in a diverse environment using both English and Japanese to collaborate with international Dev, PM, and CS teams.
### Responsibilities
1. Profit & ROI Analysis (Data Operations)
- Take ownership of the master profit dashboard and define the logic to calculate true ROI (Revenue – COGS – Ad Spend – Fees).
- Visualize operating profit using Looker Studio and propose actionable budget reallocations based on profit margins.
2. CRM Architecture & Execution (LTV Maximization)
- Segment the user database and design/implement automated CRM journeys (Welcome series, Cart recovery, Cross-sell).
- Run rigorous A/B tests to optimize Open Rates and CVR, accurately calculating incremental profit gains.
3. Data Infrastructure & Standardization
- Collaborate with Dev and PM teams to ensure clean data flow from the backend to marketing tools.
- Enforce naming conventions (UTMs) and support groundwork for future Marketing Mix Modeling (MMM).
### Requirements
- Experience: 3–7 years of hands-on experience in Data Analysis, CRM Operations, or Performance Marketing.
- Business Literacy: Ability to discuss business strategy using GP, CAC, ROAS, and LTV.
- Tool Proficiency: Mastery of GA4, BI tools (Looker Studio, etc.), and advanced Google Sheets/Excel.
- Language Skills: Business-level Japanese (for internal cross-departmental collaboration) and Business-level English.
### Preferred Skills
- Experience with raw data extraction using SQL (BigQuery, etc.).
- Background in the Travel, OTA, or Inbound Tourism industry.
- Experience aligning marketing data with financial/accounting data.