Share this Job

Title:  BI Data Warehouse Developer

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

BI Data Warehouse Developer

About this role:
We are seeking highly motivated individuals wanting to be part of a diverse global team at a large multinational company developing business solutions using 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. The successful developer must have a sound understanding of BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques. The BI Data Warehouse Developer role is responsible for the successful delivery of business intelligence information to the entire organization by leveraging experience creating star schema data models, performing ETLs, developing tabular model cubes, and finding creative solutions to solve complex business reporting challenges.


Primary Responsibilities:

  • Design and implement ETL procedures and interfaces for intake of data from both internal and external sources.
  • Work closely with business stakeholders to architect solutions using MS SQL databases and MS SSAS Tabular Cubes.
  • Develop innovative solutions using MS SQL, MS SSIS, MS SSAS, and MS Power BI.
  • Continually refine processes and approaches to better support a distributed CICD development model.
  • Propose new technology or approaches to optimize and automate different aspects of the develop cycle.


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 working with Power BI and Microsoft On-Premise Data Gateways desirable.
  • SAP, ABAP, Oracle, REST API 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.