Business Intelligence Engineer

Jakarta - Indonesia

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

We are seeking a highly technical Business Intelligence Engineer to design build and maintain the data infrastructure that powers our analytics. You will be responsible for developing scalable data pipelines building robust data models and optimizing our data warehouse. Your work will be the foundation that enables our BI Analysts and business leaders to access clean reliable and performant data for their insights and decision-making.

Job Description

Design build and maintain scalable and reliable ETL/ELT pipelines to process data from diverse sources for any reporting use cases.
Develop and manage robust reusable data models within our data warehouse (BigQuery) using data modeling best practices (star schemas etc.).
Write optimize and productionize complex SQL and Python scripts for data transformation cleaning and validation to ensure data integrity.
Create and manage optimized data marts and summary tables that support the specific needs of our BI Analysts and visualization tools.
Collaborate with BI Analysts and business stakeholders to understand their data requirements and translate them into technical specifications for the data backend.
Monitor debug and optimize data pipeline performance query speeds and data warehouse health.
Implement data quality checks and governance processes to ensure all data is accurate consistent and trustworthy.

Qualifications :

Having a bachelors or masters degree in Computer Science Information Systems Engineering or a related technical field.
Expert-level SQL skills with the proven ability to write highly optimized advanced queries stored procedures and window functions on large-scale data.
Capable of coding with data processing tools are a major plus (e.g. Jupyter Python).
Deep understanding of data modeling and data warehouse design principles (e.g. dimensional modeling star schemas) to build efficient data backends.
Strong analytical and problem-solving skills to debug complex data pipelines optimize query performance and troubleshoot data integrity issues.
Excellent written and verbal communication skills to collaborate with BI Analysts and business stakeholders to translate their requirements into technical specifications.
Experience with modern data stack tools is a plus (e.g. dbt Airflow AWS Glue Azure Data Factory or other data orchestration tools).

Remote Work :

Employment Type :

Full-time

Job Description

Design build and maintain scalable and reliable ETL/ELT pipelines to process data from diverse sources for any reporting use cases.
Develop and manage robust reusable data models within our data warehouse (BigQuery) using data modeling best practices (star schemas etc.).
Write optimize and productionize complex SQL and Python scripts for data transformation cleaning and validation to ensure data integrity.
Create and manage optimized data marts and summary tables that support the specific needs of our BI Analysts and visualization tools.
Collaborate with BI Analysts and business stakeholders to understand their data requirements and translate them into technical specifications for the data backend.
Monitor debug and optimize data pipeline performance query speeds and data warehouse health.
Implement data quality checks and governance processes to ensure all data is accurate consistent and trustworthy.

Qualifications :

Having a bachelors or masters degree in Computer Science Information Systems Engineering or a related technical field.
Expert-level SQL skills with the proven ability to write highly optimized advanced queries stored procedures and window functions on large-scale data.
Capable of coding with data processing tools are a major plus (e.g. Jupyter Python).
Deep understanding of data modeling and data warehouse design principles (e.g. dimensional modeling star schemas) to build efficient data backends.
Strong analytical and problem-solving skills to debug complex data pipelines optimize query performance and troubleshoot data integrity issues.
Excellent written and verbal communication skills to collaborate with BI Analysts and business stakeholders to translate their requirements into technical specifications.
Experience with modern data stack tools is a plus (e.g. dbt Airflow AWS Glue Azure Data Factory or other data orchestration tools).

Remote Work :

Employment Type :

Full-time

Key Skills

Business Intelligence
Cognos
SQL
Power BI
QlikView
Data Visualization
ssrs
Tableau
SSIS
Data Modeling
Data Warehouse
Data Analysis Skills

Apply Now

About Company

Cermati.com

Cermati is a financial technology (fintech) startup based in Indonesia. Cermati simplifies the process of finding and applying for financial product by bringing everything online so people can shop around for financial products online and can apply online without having to physically ... View more

View Profile View Profile

AI AutoApply

Apply to 100+ jobs with one click