Technical Consultant

{
  "content_hash": "3170c309086d85a81d6e3f6271024a9f3dcf75f0d40e02fd9c319f741a69c081",
  "source_hash": "3c797103c5a23d53e13fe013c1d617525e3aec0546210006145f80d155e9ba0e",
  "last_changed_at": "2026-05-30T05:45:11.456Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Tokyo, Chiyoda-ku, 100-0004, Japan",
    "city": "Tokyo",
    "region": "Chiyoda-ku",
    "country": null,
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T19:52:46.358Z",
  "launch_scope": {
    "reason": "bamboohr_production_catalog",
    "included": true,
    "location": {
      "raw": "Tokyo, Chiyoda-ku, 100-0004, Japan",
      "city": "Tokyo",
      "region": "Chiyoda-ku",
      "country": null,
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": []
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "list_job": {
    "id": "905",
    "isRemote": null,
    "location": {
      "city": "Tokyo",
      "state": "Chiyoda-ku"
    },
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "province": null
    },
    "departmentId": "18383",
    "locationType": "2",
    "jobOpeningName": "Technical Consultant",
    "departmentLabel": "Professional Services",
    "employmentStatusLabel": "Full-Time"
  },
  "detail_errors": [],
  "detail_job_opening": {
    "location": {
      "city": "Tokyo",
      "state": "Chiyoda-ku",
      "postalCode": "100-0004",
      "addressCountry": "Japan"
    },
    "datePosted": "2026-04-01",
    "atsLocation": {
      "city": null,
      "state": null,
      "country": null,
      "countryId": null
    },
    "description": "<p><span style=\"font-weight: bold\">Responsibilities/Objectives</span></p>\n<p> </p>\n<ul>\n<li><span>Work with project managers and business consultants to translate customer requirements into practical solutions.</span></li>\n<li><span>Create mappings and analyze data for use in data conversion.</span></li>\n</ul>\n<p> </p>\n<ul>\n<li><span>Create data maps, write ETL conversion scripts, validate migrated data, and help identify and resolve issues.</span></li>\n<li><span>Communicate with both the client's technical team and business owners as needed during design and implementation.</span></li>\n</ul>\n<p> </p>\n<p><span style=\"font-weight: bold\">Requirements</span></p>\n<p><span style=\"font-weight: bold\">(MUST)</span></p>\n<ul>\n<li><span>BS/BA / Computer Science or related field</span></li>\n<li><span>Able to create SQL queries, stored procedures, views, etc. with a thorough understanding of relational database design</span></li>\n</ul>\n<p>            (Experience coding SQL with over 300 lines, experience with jointing and aggregating multiple tables. Proficiency in writing transformation scripts using OUTER APPLY, STRING_AGG, and complex CASE statements.)</p>\n<ul>\n<li><span>Business level English</span></li>\n</ul>\n<p>             (Able to learn from English videos, translate and communicate customer requirements with Global TC, and communicate technically in English)</p>\n<ul>\n<li><span>Japanese to the extent that one can discuss complex issues with customers and read and write patent terminology</span></li>\n<li><span>Excellent problem-solving, analytical, and time management skills</span></li>\n<li><span>Excellent interpersonal and organizational skills</span></li>\n<li><span>Strong client management skills</span></li>\n<li><span>Experience with requirements gathering</span></li>\n</ul>\n<ul>\n<li>5+ years people management experience for Associate Director</li>\n</ul>\n<ul>\n<li> Experience in the implementation, configuration, customization, or development of business software such as ERP, CRM, accounting systems, and attendance management systems (from the perspective of an engineer or implementation specialist).</li>\n</ul>\n<ul>\n<li> Quality Control: Commitment to ensuring migration quality by creating Q&amp;Q reports and checklists.</li>\n</ul>\n<ul>\n<li> Design Ability: Ability to organize client requirements into accurate specifications like Value Mapping Sheets.</li>\n</ul>\n<p> </p>\n<p> </p>\n<p><span style=\"font-weight: bold\">(PREFERED)</span></p>\n<ul>\n<li><span>Ability to use reporting tools such as SQL Server Reporting Services (SSRS), Sisense, and PowerBI</span></li>\n</ul>\n<ul>\n<li><span>ETL experience</span></li>\n<li><span>Experience with K2View</span></li>\n</ul>\n<ul>\n<li><span>Proficient SQL Server, SSIS, SSRS, C#</span></li>\n<li><span>Experience with Visual Studio as a development and testing tool</span></li>\n<li><span>Knowledge of system integration and the system development lifecycle</span></li>\n<li><span>Experience with automated testing tools</span></li>\n<li><span>Microsoft Office Suite, Visio, and Project experience with</span></li>\n<li><span>Experience with intellectual property</span></li>\n<li><span>Experience with software implementation</span></li>\n</ul>\n<ul>\n<li>Experience with multiple projects</li>\n</ul>\n<ul>\n<li> IP Knowledge: Ability to understand Japanese IP terminology and engage in practical discussions with IP departments.</li>\n</ul>\n<ul>\n<li> Interest in extending tool features via PowerShell/C# and automating routine tasks using AI agents.</li>\n</ul>\n<p> </p>\n<p><span style=\"font-weight: bold\">Benefits</span></p>\n<p>- SOCIAL INSURANCE: 健康保険、厚生年金、雇用保険、労災保険</p>\n<p>- HOLIDAYS: Weekends, National holidays and New Year holidays</p>\n<p>- OTHERS: Free foods and drinks, Paid sick leave, Office Casual attire and volunteer holiday</p>\n<p> </p>",
    "compensation": null,
    "departmentId": "18383",
    "locationType": "2",
    "seekPromoted": false,
    "jobCategoryId": null,
    "jobOpeningName": "Technical Consultant",
    "departmentLabel": "Professional Services",
    "jobOpeningStatus": "Open",
    "minimumExperience": null,
    "jobOpeningShareUrl": "https://anaqua.bamboohr.com/careers/905",
    "employmentStatusLabel": "Full-Time"
  }
}