BI Engineer: Scalable Data Pipelines & Modeling

Indodana; Kebayoran Baru; On-site; IDR 240,000,000 - 360,000,000; Full time

Job summary

Indodana is seeking a highly technical Business Intelligence Engineer to design, build, and maintain the data infrastructure powering analytics. You will craft scalable ETL/ELT pipelines, develop robust data models in BigQuery, and optimize the data warehouse to deliver clean, reliable datasets for BI analysts and leadership.

You will write and productionize SQL and Python scripts for data transformation, ensure data quality and governance, and collaborate with stakeholders to translate needs

Responsibilities

• 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.

Job description

Indodana is seeking a highly technical Business Intelligence Engineer to design, build, and maintain the data infrastructure powering analytics. You will craft scalable ETL/ELT pipelines, develop robust data models in BigQuery, and optimize the data warehouse to deliver clean, reliable datasets for BI analysts and leadership.

You will write and productionize SQL and Python scripts for data transformation, ensure data quality and governance, and collaborate with stakeholders to translate needs