Business Intelligence Engineer
is seeking a highly technical Business Intelligence Engineer to design, build, and maintain the data infrastructure that powers our analytics. This role is integral to developing scalable data pipelines, constructing robust data models, and optimizing our data warehouse. Your contributions will enable BI Analysts and business leaders to access clean, reliable, and performant data for insightful decision-making.
Key responsibilities include designing, building, and maintaining scalable ETL/ELT pipelines to process data from diverse sources for various reporting use cases. You will develop and manage reusable data models within our data warehouse (BigQuery) using best practices such as star schemas. Additionally, you will write, optimize, and productionize complex SQL and Python scripts for data transformation, cleaning, and validation to ensure data integrity. Collaborating with BI Analysts and business stakeholders to understand their data requirements and translating them into technical specifications for the data backend is also a crucial part of this role.
The ideal candidate holds a bachelor's or master's degree in Computer Science, Information Systems, Engineering, or a related technical field. Expert-level SQL skills are essential, with a proven ability to write highly optimized advanced queries, stored procedures, and window functions on large-scale data. Proficiency in coding with data processing tools such as Jupyter and Python is highly desirable. A deep understanding of data modeling and data warehouse design principles, including dimensional modeling and star schemas, is required. Strong analytical and problem-solving skills are necessary to debug complex data pipelines, optimize query performance, and troubleshoot data integrity issues. Excellent written and verbal communication skills are important for effective collaboration with BI Analysts and business stakeholders. Experience with modern data stack tools like dbt, Airflow, AWS Glue, or Azure Data Factory is a plus.
offers a dynamic work environment with opportunities for professional growth. Employees benefit from a collaborative culture that values innovation and continuous learning. We provide competitive compensation packages, including health insurance, retirement plans, and paid time off. Joining our team means contributing to a company that is transforming the Indonesian financial landscape through technology.