Data Architect | Staff | IT Enterprise Data & Platforms Japan

The Position

Our IT EDP Data & Analytics team is seeking a talented and experienced Data Architect to join our team. The ideal candidate will be responsible for designing, creating, and managing our company's data architecture. This individual will play a key role in developing data strategies, implementing data solutions, and ensuring the overall integrity and security of our data assets for Digital Products delivered to Business.

This individual converts business and analytics into Snowflake models, patterns, and pipelines for consistent data ingestion, transformation, quality, and governance. Expertise in Snowflake, dbt, ELT, and data contracts is essential. Pharmaceutical commercial data experience is a plus.

Tasks and Responsibilities

• Design scalable, cost‑efficient Snowflake‑based data architectures
• Define standardized patterns for ingestion, transformation, modeling, and consumption
• Develop solution blueprints, including data flows, lineage, and integrations
• Establish and govern data contracts (schema, SLAs, validation, evolution)
• Lead conceptual, logical, and physical modeling using tools like SqlDBM and dbt
• Build modular, reusable dbt models with strong testing and CI/CD practices
• Integrate data quality, observability, and metadata‑driven validation
• Design orchestrated pipelines using Airflow, Jenkins, or similar tools
• Ensure compliance with governance, security, and access‑control standards
• Partner across data, platform, and governance teams; mentor engineers and analysts

Requirements

• Degree in Computer Science, Engineering, Data/Information Systems, or a related field, with 7+ years of relevant experience in data engineering, analytics engineering, or similar roles.
• Enterprise data architecture experience with Snowflake or similar platforms
• Strong hands‑on ELT/ETL and dbt skills (models, tests, macros, CI/CD)
• Deep understanding of Data Vault and dimensional modeling
• Experience in designing and governing data contracts
• Advanced SQL and ELT expertise
• Experience in developing and operating semantic layers supporting analytics, reporting, conversational AI, and self-service data consumption.
• Familiarity with orchestration tools, Git workflows, and governance platforms
• Strong stakeholder management, analytical thinking, and structured problem‑solving skills.
• Excellent communication skills in English and Japanese, enabling clear interaction with technical and non‑technical stakeholders.

Nice to have

• Data Vault 2.0 experience
• Familiarity with Iceberg, external tables, and data catalogs
• Knowledge of analytics layers (Power BI, Tableau, semantic models)
• Exposure to cloud‑native and platform engineering practices