CRM & Data Analyst

【Responsibilities】 1. Profit and ROI Analysis (Data Operations) You will take ownership of the master profit dashboard and define the calculation logic for "True ROI" (Revenue - COGS - Advertising Expenses - Settlement Fees). By visualizing the operating profit of each service using tools such as Looker Studio, you will propose cross-channel budget reallocation strategies to decision-makers based on actual profit margins rather than just CPA. 2. CRM Design and Execution (LTV Maximization) You will segment the user database based on purchasing behavior to design and implement automated CRM journeys, including welcome emails, abandoned cart recovery, and cross-selling initiatives. You will accurately calculate the incremental revenue and profit generated by these CRM measures and continuously improve open rates and CVR through rigorous A/B testing. 3. Data Infrastructure Maintenance and Standardization Working in coordination with the development team and Product Managers, you will ensure accurate data integration from the backend to various analytical tools. You will enforce strict naming conventions (such as UTM parameters) to maintain a clean data pipeline and support the foundation-building required for future Marketing Mix Modeling (MMM). ■Tools Used - GA4 (basic operations such as tracking setup and exploration reports) - Looker Studio (dashboard creation and management) - Excel / Google Sheets (functions, pivot tables, data processing) 【Job Requirements】 - Experience and Skills: 3–7 years of practical experience in data analysis, CRM operations, or performance marketing. - Understanding of Profit Metrics and Proficiency with Tools: Ability to calculate metrics such as gross profit (GP), CAC, ROAS, and LTV, and use them in business discussions. Additionally, skills in data aggregation and dashboard creation using GA4, BI tools (e.g., Looker Studio), and advanced spreadsheets. - Experience in CRM Implementation and Scenario Design: Practical experience in designing customer journeys and user segmentation. - Language Skills: Business-level Japanese (ability to collaborate smoothly with development, PM, CS, etc.) and business-level English. 【Preferred】 - Experience extracting and processing raw data using SQL (e.g., BigQuery). - Knowledge of the travel and inbound tourism industries. - Experience integrating marketing data with financial and accounting data.