
Technical Consultant
Anaqua
full-time
Posted on:
Location Type: Hybrid
Location: Tokyo • Japan
Visit company websiteExplore more
About the role
- Work with project managers and business consultants to translate customer requirements into practical solutions.
- Create mappings and analyze data for use in data conversion.
- Create data maps, write ETL conversion scripts, validate migrated data, and help identify and resolve issues.
- Communicate with both the client's technical team and business owners as needed during design and implementation.
Requirements
- BS/BA / Computer Science or related field
- Able to create SQL queries, stored procedures, views, etc. with a thorough understanding of relational database design (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.)
- Business level English (Able to learn from English videos, translate and communicate customer requirements with Global TC, and communicate technically in English)
- Japanese to the extent that one can discuss complex issues with customers and read and write patent terminology
- Excellent problem-solving, analytical, and time management skills
- Excellent interpersonal and organizational skills
- Strong client management skills
- Experience with requirements gathering
- 5+ years people management experience for Associate Director
- 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).
- Quality Control: Commitment to ensuring migration quality by creating Q&Q reports and checklists.
- Design Ability: Ability to organize client requirements into accurate specifications like Value Mapping Sheets.
- Ability to use reporting tools such as SQL Server Reporting Services (SSRS), Sisense, and PowerBI
- ETL experience
- Experience with K2View
- Proficient SQL Server, SSIS, SSRS, C#
- Experience with Visual Studio as a development and testing tool
- Knowledge of system integration and the system development lifecycle
- Experience with automated testing tools
- Microsoft Office Suite, Visio, and Project experience with Experience with intellectual property
- Experience with software implementation
- Experience with multiple projects
- Ability to understand Japanese IP terminology and engage in practical discussions with IP departments.
- Interest in extending tool features via PowerShell/C# and automating routine tasks using AI agents.
Benefits
- SOCIAL INSURANCE: 健康保険、厚生年金、雇用保険、労災保険
- HOLIDAYS: Weekends, National holidays and New Year holidays
- OTHERS: Free foods and drinks, Paid sick leave, Office Casual attire and volunteer holiday
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLETLdata mappingrelational database designtransformation scriptsC#system integrationautomated testingrequirements gatheringdata conversion
Soft Skills
problem-solvinganalytical skillstime managementinterpersonal skillsorganizational skillsclient managementcommunicationdesign abilityadaptabilityleadership