Share this Job

Title:  BI Data Warehouse Administrator / Operations Specialist

Company:  Renesas Electronics (Penang) Sdn. Bhd.
Country/Region:  MY
State:  Penang
City:  Bayan Lepas
Department:  (Business Application Infrastructure)
Business Unit:  Direct Organization (CLO)
Office:  REPG (Penang)
Job Function:  Information Technology
Job Type:  Permanent

BI Data Warehouse Administrator / Operations Specialist


About this role:
We are seeking highly motivated individuals wanting to be part of a diverse global team at a large multinational company supporting a cutting-edge business intelligence data warehouse infrastructure and related BI systems.

A high degree of competency in wide array computer programming and database related skills is required for this position. Typical tasks include archiving, tracking data changes, migration, monitoring data systems, as well as conducting performance tuning and other optimizations. Troubleshooting and resolving performance issues is an integral part of this position which requires strong interpersonal and analytical skills.


Primary Responsibilities:

  • Monitor all ETL processes and databases to ensure optimal performance. Resolve all performance issues.
  • Perform tests and maintain MS SQL Server databases and MS SSAS Multi-Dimensional and Tabular Cubes.
  • Administer databases, install required upgrades and patches, and resolve all issues to ensure data accuracy, permissions, and security configurations.
  • Ensure compliance to all specifications and documents all data warehouse administration activities.
  • Maintain all required documents for data warehouse.
  • Schedule plans for all tasks and maintain an optimized database.
  • Manage all architectural issues and recommend enhancements as necessary.
  • Evaluate and provide guidance on process methodology.
  • Assist with Quality Assurance and audit related activities.


Technical Skills (Microsoft Certifications preferred)

  • Minimum 3 years developing and administering Microsoft SQL Server & Microsoft SSIS (Integration Services)
  • Minimum 3 years developing and administering Microsoft SSAS (Analysis Services)
  • Excellent programming proficiency in SQL, DAX, M, MDX, as well as scripting languages like PowerShell and Windows Batch files.
  • Experience working with ETL and technologies such as FTP, Informatica PowerCenter, HULFT, Business Spectre, etc.
  • Experience working with Job Scheduling tools such as Hitachi JP1 and Windows Task Scheduler or equivalent.
  • Familiarity with using Source Code management tools like GitHub, CVS, or similar.
  • Experience with Windows Server OS and Administration, Security, and Disk Housekeeping practices.
  • Knowledge of SAN technology, and server load balancing practices
  • Experience working with Power BI and Microsoft On-Premise Data Gateways desirable.
  • SAP, ABAP, Oracle knowledge a plus.


Soft Skills

  • Energetic, creative individuals who like to innovate and automate.
  • Ability to translate business requirements into technical design.
  • Superb written and spoken communication skills in English. Japanese written and spoken language skills are also desired, but not required.