Analyze JMDC and Omron Group data to develop new data-driven services, build predictive models, advise industry clients, improve services with machine learning, and publish findings.
About this role
The data engineer will design and develop data marts and data-processing workflows for a platform that stores, processes and provides health insurance claims data. Core work includes building scalable processing on AWS Redshift Serverless using SQL and stored procedures, and orchestrating batch processing with Step Functions.
The role includes understanding the complex data structures and business logic of a long-running existing platform and evolving it for expanded data-use needs. The engineer will also work directly with sales planning, analytics and other business functions to identify better ways to use the data from both technical and domain perspectives.
The system supports the storage, processing and provision of claims data through a data warehouse, data marts and ETL. The team handles the full development process in-house, from requirements definition through operations, without customer-site assignment or offshore outsourcing. The position is in the Data Warehouse Development Department's Insurer Claims Group, a four-person team consisting of two employees and two partner staff members.
Required experience includes at least three years building and operating data-processing or ETL pipelines on AWS, and at least three years of development using SQL, including complex query design, tuning or data-mart implementation. Preferred experience includes designing or operating data warehouses and data marts, managing infrastructure with infrastructure-as-code tools such as CloudFormation or Terraform, handling healthcare or medical data such as claims data, and developing batch processing or data transformation with Python or similar languages.
The stated development environment includes Python and SQL; AWS services including Redshift Serverless, Step Functions, Lambda, Glue Data Catalog, CloudFormation and SAM; GitHub for source-code management; and Slack and Confluence for communication. Claude Code, Gemini and GitHub Copilot are used as AI coding agents in the development process.
The position can use a hybrid work style combining remote work and office attendance of at least two days per week. The initial work location is the Tokyo office in Minato-ku, Tokyo. Working hours use a flextime system with core hours from 11:00 to 15:00; standard working time is eight hours per day with a 60-minute break. The employment type is full-time. Benefits and programs stated in the posting include social insurance, commuting allowance up to 150,000 yen per month, a corporate defined-contribution pension, paid leave, AWS certification assistance, technical-book purchasing assistance of approximately 5,000 yen per month, seminar support and use of 10% project time for self-directed projects or learning.
This is an AI-generated summary of the employer's original posting — details can be incomplete, out of date or simply wrong. Always confirm everything on the official posting before applying.
Similar jobs
Conduct data science R&D for healthcare services, analyze medical and health data, build predictive models, support client consulting, and improve services through machine learning. The role uses Python and SQL.
Design and build data pipelines, cloud infrastructure, MLOps capabilities, and backend APIs for new healthcare data products using large-scale medical data. The role covers architecture, deployment, monitoring, and continuous improvement.
Manages hardware assets, data-center and server-room operations, facility risks, vendor performance, purchasing coordination, inventories, and compliance across Japan.
Manages an Enterprise Solutions Engineering team in Tokyo, supporting enterprise solution engineering activities for Box customers and stakeholders.
Develop real-time vehicle control solutions using control theory, optimization, and machine learning.