[Kyujin Box / Lead Candidate] Analytics Engineer to Lead Data Infrastructure and Business Evolution by Maximizing Synergy Between Two Major ServicesTranslated from Japanese

▼Job Description As an Analytics Engineer for the HR Company, you will be responsible for both "problem-solving through data analysis" and "building a reliable data infrastructure" to accelerate business and product growth. Your mission is to create data synergy across the Kakaku.com Group by leveraging data from "Kyujin Box" and "Engage". 【Specific Responsibilities】 - Design and formulate KPIs and management metrics, identify business challenges, and conduct analysis to solve them. - Design, implement, and automate ELT/ETL pipelines using BigQuery, Databricks, etc. - Design, build, and operate data models and data marts. - Build dashboards and manage the performance of initiatives (using Looker Studio / Tableau / Redash, etc.). - Conduct hypothesis testing, measure effectiveness, and propose next actions using statistical methods. - Monitor data quality, implement tests, and design alerts. - Participate in the design and operation of DWH architecture and data lakehouses. - Support analysis through collaboration with Analytics Engineers and Data Scientists. - Formulate and promote data governance. - Contribute opinions and build consensus on the team's technical direction. - Support task organization and priority adjustment for team members. - Conduct code reviews and support skill development for team members. ▼Onboarding Plan - Month 1: - Understand the business model and data infrastructure of the assigned services. - Grasp existing analysis projects and data pipelines. - Build relationships with team members. - Month 2 onwards: - Take charge of new projects (starting with small-scale ones). - Share knowledge within the team and mentor/guide members. - Month 3 onwards: - Lead the organization and proposal of technical challenges as a core member of the team, and lead member development and reviews. 【Career Path】 After joining, we expect you to first become a core member of the team, and eventually lead the team as a Team Leader. As a specialist in data utilization supporting the business, career paths include specializing further in analysis and visualization according to your aptitude, an engineering-focused career deepening your expertise in areas like data architecture design and pipeline construction, or a management career involved in data strategy and decision support at the executive level. ▼Required Skills/Experience - 3+ years of practical experience in data extraction, processing, and aggregation using SQL. - 3+ years of experience in designing, building, and operating DWH and data marts. - Experience in designing and implementing data pipelines (ETL/ELT). - Team or project lead experience (with 2-3 or more members). - 3+ years of practical experience in building dashboards and visualization using BI tools (Looker Studio / Tableau / Redash, etc.). - Basic knowledge of statistics and knowledge of designing and analyzing business metrics (KPIs, etc.). ▼Preferred Skills/Experience - Experience in data analysis and infrastructure construction using DWH on GCP/AWS (BigQuery / Redshift, etc.). - Experience using Databricks / Apache Spark. - Experience using data modeling tools such as dbt. - Advanced data analysis experience using Python/R, etc. - Data analysis experience using machine learning and generative AI. - Experience building CI/CD pipelines. - Practical experience in data governance and data management. - Experience in designing and operating data quality management (test automation, monitoring). - Experience in member development and evaluation. - Experience in priority adjustment and progress management for multiple projects. ▼Ideal Candidate Profile - Individuals who resonate with our company's mission and vision and have a strong desire to drive business growth through data. - Individuals who can translate business challenges into data design and proactively drive initiatives. - Individuals who can communicate smoothly with members from different backgrounds and build consensus. - Individuals with flexibility and a challenging spirit who can enjoy changes in new business phases. - Individuals who are always aware of new information and technologies and have a high desire to learn. - Individuals who can drive problem-solving by engaging the team while hands-on. - Individuals who are motivated by both technical skills and member development/team contribution. ▼Job Appeal - You can gain end-to-end experience in data design and utilization for two large-scale services by working with data from both "Kyujin Box" and "Engage". - This is a valuable position to be at the core of the synergy phase under Kakaku.com, at a time when data integration and collaboration between the two services are becoming full-fledged. - There is significant room for improvement through data utilization, allowing you to take on a wide range of responsibilities from infrastructure construction to advanced analysis and visualization, and achieve significant results. - As a core member of data utilization, you will have technical discretion and influence on the business. ▼Development Environment 【Work Environment】 - Project Management: Confluence / Jira - Source Code Management: GitHub Enterprise - Generative AI Tools: Cursor / Dify - Communication: Slack - Collaboration: Miro - Office Tools: Google Workspace / Box / Microsoft365 - Terminal: Windows (MacBook Pro also available) 【Development Environment & Tech Stack】 - Data Platform: BigQuery / Databricks - Cloud: Google Cloud / AWS - DWH/Storage: BigQuery / Amazon Redshift / Amazon S3 - ETL/Data Integration: AWS Glue / TROCCO - Languages: SQL / Python - BI: Looker Studio / Tableau / Redash - Others: Vertex AI / Cloud Run / GCE / Workflows / KARTE / Adjust / Google Tag Manager, etc. ▼Employment Type Full-time employee (no fixed term) ▼Probationary Period 3 months *No change in employment status or treatment during the probationary period. ▼Salary Annual salary: ¥7,500,000 - ¥12,000,000 ▼Bonus Once a year (June) ▼Annual Salary Lower Limit (10,000 JPY) 750 ▼Annual Salary Upper Limit (10,000 JPY) 1200 ▼Work Location Shibuya Parco DG Building, 15-1 Udagawa-cho, Shibuya-ku, Tokyo *We adopt a hybrid work style, flexibly combining remote work and office attendance depending on job duties and team circumstances. ▼Working Hours Flextime work (standard working hours: 8 hours per day) - Core time: 10:00 AM - 3:00 PM *Overtime may occur due to work circumstances. *This differs for managers and those under discretionary labor systems. *You can flexibly change your start and end times according to the team's situation and your work pace. ▼Break Time 1 hour during working hours ▼Overtime Work Yes ▼Holidays, Paid Leave, Special Leave Complete two-day weekend system - Scheduled holidays: Saturdays, Sundays, National Holidays, Year-end and New Year holidays (December 29 - January 3) - Leave: Summer vacation (3 days), Paid leave, Congratulatory/Condolence leave *Paid leave: Up to 10 days granted depending on the month of joining. ▼Benefits We aim to be a company where employees can experience both the "fun of working" that Kakaku.com has valued since its founding, and "ease of working." We will continue to actively review our systems, reflecting employee feedback and considering usage status. - Defined contribution pension plan - Group life insurance - Free comprehensive medical check-ups (periodic health examinations) - EAP counseling program - Congratulatory/Condolence money - Maternity leave - Childcare leave (can be taken until the end of the fiscal year when the child turns 3 years old) - Reduced working hours for childcare (can be taken for up to 12 years until the child graduates from elementary school. Option to choose coreless flextime system). - Childcare support leave (10 days per year, 5 of which are paid leave. If you have multiple children, 20 days per year, 10 of which are paid leave). - Nursing care leave - Volunteer leave - Family allowance (payment conditions apply) - Remote work environment allowance ▼Allowances - Commuting expenses fully reimbursed (with limits) - Family allowance (payment conditions apply) - Remote work environment allowance ▼Insurance Enrollment - Social insurance complete (Employment, Health, Workers' Accident Compensation, Pension) - Group life insurance ▼Measures to Prevent Passive Smoking in the Workplace Indoor smoking prohibited in principle (smoking area available) ▼Education/Skill Up/Career Up Self-study support system available ▼Health - Free comprehensive medical check-ups (periodic health examinations) - EAP counseling program ▼Interview/Selection Process Document screening → 1st interview → Final interview → Offer *The selection process may be subject to change.