Data Extraction Specialist

JMDC

SQL

Linux

Healthtech

Data Eng

About this role

This role works in JMDC’s data analysis division and is responsible for extracting data with SQL. The position receives requests from client-facing members and performs extraction based on requirements-definition documents. Work includes aggregating, processing, and extracting the company’s health big data according to client needs, as well as cross-checking extracted data.

案件 are handled by two-person teams. Each member extracts the data independently, confirms ambiguous interpretations of the requirements, and repeats correction and verification until both results match. One案件 generally takes two to three days. The extracted data is used by consultants to make proposals to pharmaceutical clients and support business impact through data utilization.

Applicants must meet at least one of the following conditions: experience in data extraction using SQL; practical experience developing, maintaining, or operating systems using a database and SQL; or at least three years of system development experience, regardless of programming language. Interest in using health big data is welcomed. The role seeks people who can engage with the difficulty of problems without a single correct answer and enjoy creating SQL from requirements and matching results through a puzzle-like process.

The stated development environment includes Linux and Windows operating systems, SQL, and a Redshift database server.

The department provides health big data and analysis tools to pharmaceutical companies and supports them with data-based consulting. Its work covers uses such as pharmaceutical marketing, research and development operations, database studies, new healthcare service planning, new drug development, and understanding patient treatment conditions.

The initial expected work location is JMDC’s Tokyo office in Shibadaimon, Minato-ku. Working hours use a flextime system with core hours from 11:00 to 15:00, standard working hours of eight hours per day, and a 60-minute break. The position is full-time. Benefits and systems stated in the posting include health, pension, employment, and workers’ accident compensation insurance; commuting allowance up to 150,000 yen per month; a corporate defined-contribution pension; childcare and nursing-care leave; condolence payments; and an employee stock ownership plan. The company also states a five-day annual leave grant at joining, additional paid leave after six months, weekends and public holidays off, and a mandatory retirement age of 65.

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.