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.
Having a bachelor's or master's 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).
Skills Required
- Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or related technical field
- Expert-level SQL skills including advanced queries, stored procedures, and window functions on large-scale data
- Proficiency coding for data processing and transformation (e.g., Python, Jupyter)
- Deep understanding of data modeling and data warehouse design principles (dimensional modeling, star schemas)
- Strong analytical and problem-solving skills to debug pipelines and optimize query performance
- Excellent written and verbal communication skills to translate stakeholder requirements
- Experience with modern data stack tools (dbt, Airflow, AWS Glue, Azure Data Factory)
What We Do
We are a technology startup that engages in the Indonesian financial technology area. We are based in Jakarta and we're founded by ex-silicon valley engineers. Our vision is to use technology to make financial information more available and more useful to everyone. Our mission is to enable people to take control of their financial situation and save a lot of money by doing so. Our products allow people to easily make the best financial decision for their situation. Come join our adventure in transforming Indonesian financial landscape through technology.
