Senior BI Developer

Zempot Malaysia Sdn. Bhd.; Iskandar Puteri; Presencial; MYR 90.000 - 130.000; Jornada completa

Descripción de la vacante

ZEMPOT MALAYSIA SDN BHD is seeking an experienced Senior BI Developer to join our team in Malaysia. You will work with SQL, Databricks, and Power BI to build and maintain analytical datasets, data models, and BI solutions within a Databricks environment.

You will develop dashboards, semantic models, and data quality checks while optimizing performance for large datasets. The role emphasizes analytics, data governance, and reliable data delivery to business users.

Formación

• Advanced SQL proficiency including complex queries, joins, CTEs, window functions.
• Hands-on development experience with MSSQL or similar relational databases.
• Experience using Databricks for data development and analytics.
• Strong skills in Power BI dashboards, semantic models, and DAX/Power Query.

Responsabilidades

• Develop and optimize complex SQL queries for data extraction, transformation, and aggregation using MSSQL and Databricks SQL.
• Design, develop, and maintain analytical tables, views, and summary tables.
• Develop stored procedures and SQL-based data processing logic.
• Analyze and optimize query performance for large datasets.
• Understand and improve existing data models and schemas.
• Develop analytical datasets and data models using Databricks SQL.
• Work with Delta Lake structures for efficient data querying.
• Design, develop, and maintain Power BI dashboards and reports.
• Develop Power BI semantic models, DAX measures, and Power Query transformations.
• Ensure data accuracy and integrity through validation and quality checks.

Conocimientos

SQL

Databricks

Power BI

Educación

Bachelor's degree

Descripción del empleo

We are seeking an experienced Senior BI Developer with 3–5 years of relevant experience to join our team. The ideal candidate should have strong technical expertise in SQL, Databricks, and Microsoft Power BI, with hands‑on experience in BI development, analytical data modeling, dashboard development, data quality management, and performance optimization. This role will focus on developing and maintaining efficient analytical datasets, data models, and BI solutions within a Databricks‑based analytics environment, ensuring that business and data analytics teams have access to accurate and reliable data.

Key responsibilities

Develop and optimize complex SQL queries for data extraction, transformation, and aggregation using MSSQL and Databricks SQL

Design, develop, and maintain analytical tables, views, and summary tables to support business analytics and reporting

Develop stored procedures and SQL-based data processing logic

Analyze and optimize query performance for large datasets

Understand existing data models and schemas, and implement improvements where necessary

Develop and maintain analytical datasets and data models using Databricks SQL

Work with Delta Lake-based data structures for efficient data querying and analysis

Design, develop, and maintain interactive Power BI dashboards and business reports

Develop and maintain Power BI semantic models, DAX measures, and Power Query transformations

Ensure data accuracy, consistency, and integrity through validation and quality checks

About you

3–5 years of relevant working experience in Business Intelligence development, Data Analytics, or a related field

Bachelor's degree in Computer Science, Information Technology, Data Analytics, Statistics, or a related field, or equivalent practical experience

Advanced SQL proficiency, including complex queries, JOINs, CTEs, window functions, and subqueries

Hands‑on development experience with Microsoft SQL Server (MSSQL) or similar relational database systems

Experience developing stored procedures, views, and complex aggregation queries

Hands‑on experience in SQL‑based data development within a Databricks environment

Strong proficiency in Databricks SQL for data extraction, transformation, and analytical queries

Hands‑on experience developing dashboards using Power BI Desktop and Power BI Service

Experience in Power BI data modeling and semantic model development

Proficiency in DAX and Power Query

Unlock job insights

Hirer responsiveness Salary match Number of applicants

Your application will include the following questions:

• Which of the following statements best describes your right to work in Malaysia?
• How many years' experience do you have as a business intelligence developer?
• Which of the following types of qualifications do you have?
• How many years of Database Development experience do you have?
• How many years of Business Data Analytics experience do you have?
• Do you have experience using Power Query?
• How many years' experience do you have as a SQL Analyst?

Computer Software & Networking 11-50 employees

ZEMPOT MALAYSIA SDN BHD is a newly branched sister company from the South Korean top 5 video gaming company. Our company slogan is "JUST FOR FUN" which emphasizes our working environment. We are currently looking for fun new colleagues to join us in our adventure to conquer the South East Asian market in terms of video game data analysis.

ZEMPOT MALAYSIA SDN BHD is a newly branched sister company from the South Korean top 5 video gaming company. Our company slogan is "JUST FOR FUN" which emphasizes our working environment. We are currently looking for fun new colleagues to join us in our adventure to conquer the South East Asian market in terms of video game data analysis.

To help fast track investigation, please include here any other relevant details that prompted you to report this job ad as fraudulent / misleading / discriminatory / salary below minimum wage.

Researching careers? Find all the information and tips you need on career advice.