Job ID : 1041264 Date Updated : November 16th, 2020
Large American Insurance Company

~10M DWH/BI Business Analyst & PM 〜1,000万DWHビジネスアナリスト/ PM

Hiring Company International Insurance company
Location Tokyo - 23 Wards, Minato-ku
Job Type Permanent Full-time
Salary 7 million yen ~ 10 million yen

Job Description

Tokyo- Roppongi


The primary responsibility is to manage and drive DWH (Data Warehouse) / BI (Business Intelligence) Solution development projects from Initiating to closing but also covers for some various management and execution work that will be occur in the process. This
position identifies the requirement for DWH / BI Solution that may arise from business requirement and data source system changes, estimate IT development resource, time, cost, then manage development & delivery process to meet predefined budget, timeframe, quality in work with stakeholders. This position will work on various data related projects, so broad range of experience in data solutions is MUST.



Initiating & Planning

  • Act as single point of contact of data team in IT project scheme
  • Identify scope for impact on DWH/BI solutions and stakeholders required to collaborate with.
  • Work with stakeholders in Biz & IT to discover requirements for DWH/BI Solution, translate these requirements into system requirements definition like as business rule, calculate algorithm, views, data model, ETL data flow & mapping logic.To
    confirm biz & IT requirements, the position need to analyze & check As-Is production systems and data by own self in collaborate with stakeholders include Off-shore developers.
  • Estimate resource, time, cost required for solution development in cooperation with Scrum Master.
  • Create a business case definition document that describes business background, balance between the business benefits and costs and get approval through Company IT governance process.
  • Create Work Breakdown Structure (WBS), clarify release schedule and get stakeholder agreement
  • Define a communication plan to promote the Project and make it known to stakeholders.
  • Create test cases and scenarios including data patterns with the consent of business stakeholders and inform the contents to development team.

Executing, Monitoring & Controlling

  • Conduct and facilitate meetings & communications with Biz & IT stakeholders in On-shore and Off-shore as needed.
  • Review project estimates and POR monthly allocation by collaborating with Scrum
  • Leverages Company project management methodologies to deliver IT projects on time and on budget effectively
  •  Review Project Status With Development Leads Appropriately, Identifies Project Risks / Issues, Execute Mitigation Plans And Also Communicates Status To Business And IT Leadership.
  • Promote And Sometimes Conduct By Own User Acceptance Test And Production Smoke Test To Check Rightness Of Solution Development Deliverables.


Review executed process with stakeholders and accumulate and share Lessons & Learns get from project.

Other Management & Leadership

  • Maintains a manner of leadership, influence, and flexibility to promote a team atmosphere.
  • Manage and mentor scrum team to reach their full potential and create a passion to help drive teams to success.
  • Ensure programs are staffed with the appropriate resource and skill sets.

General Requirements

Minimum Experience Level Over 3 years
Career Level Mid Career
Minimum English Level Business Level (Amount Used: English usage about 50%)
Minimum Japanese Level Fluent
Visa Status Permission to work in Japan required

Required Skills


Management & Leadership

3+ years of experiences of project manager or leadership for DWH/BI Solution development team.

including: Scope/Schedule/Cost/Quality/Communicatioin/Risk/Procurement/Stakeholder management & integration, Business Value Proposition & Proposal for the domain
or equivalent skill required
Extensive knowledge & Experience for Software Development methods & Process, SDLC, Agile Scrum
Experience working with diverse cultures, including working with offshore IT organizations
Communication & Attitude 

Excellent interpersonal, written and oral communication skills in Japanese & English
writing clearly and concisely in Japanese & English is highly required.

Be able to respond appropriately for all level of management and members in any severe situations
Active listener & excellent presenter
Good mentor & consultant for colleague in Biz & IT
Results driven, exceptionally self-motivated and directed, with keen attention to detail and strong sense of personal accountabilities


Bachelor's Degree or equivalent required; Graduate Degree desirable
Knowledge writing and executing SQL scripts for the purpose of data validation & quality check.
Knowledge & Experience of DWH & Big Data Architecture concepts, logical & physical data model (relational & OLAP), Data analysis, data visualization, BI, ETL, and related Technology product.



PMP or equivalent industry certification
2+ years of enterprise experiences in management of external vendors (on/offshore) preferred, including multiple culture and languages
experiences in proposing new business initiative or IT governance improvement desirable
Experience in operations support desirable



Be member of Fast growing, multi-cultural, international team.

Can get awesome experience for business improvement with real data while working closely with both business and IT professionals.

Work in dynamic, collaborative, transparent, non-hierarchal, and ego-free culture.

Where your talent is valued over a role title.

Work/Life Balance: On Solution release timing, you have to do smoke test at late

Average overtime is less than 20 hrs./month.
Opportunities: variety, innovation and unique challenges,

You can learn something new every day if you want.
Occasionally need to travel within or outside Japan


Japanese & English bilingual / Business level fluent

Must use on every day.


Job Location

  • Tokyo - 23 Wards, Minato-ku

Work conditions

Job Type Permanent Full-time
Salary 7 million yen ~ 10 million yen
Job Division IT Division

Hiring Company Information

Company Type Small/Medium Company (300 employees or less) - International Company
Non-Japanese Ratio About half Japanese
Recruiter Company Information

RGF Professional Recruitment Japan

~10M DWH/BI Business Analyst & PM 〜1,000万DWHビジネスアナリスト/ PM - 1041264

Company Description

RGF Professional Recruitment Japan provides bilingual professionals to multinational corporations. We are functional recruiters focusing on Finance & Accounting, Banking, Legal, HR & GA, Logistics, Telecoms, Sales & Marketing, and Technology.