Cermati

Business Intelligence Engineer

Jakarta, ID
SQL Python BigQuery dbt Airflow AWS Glue Azure Data Factory
Description

Business Intelligence Engineer

Location: Jakarta, Jakarta, id

Job Description

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

Cermati
Cermati

0 applies

0 views

There are more than 50,000 engineering jobs:

Subscribe to membership and unlock all jobs

Engineering Jobs

60,000+ jobs from 4,500+ well-funded companies

Updated Daily

New jobs are added every day as companies post them

Refined Search

Use filters like skill, location, etc to narrow results

Become a member

🥳🥳🥳 452 happy customers and counting...

Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.

To try it out

For active job seekers

For those who are passive looking

Cancel anytime

Frequently Asked Questions

  • We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
  • We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
  • We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
  • We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
  • Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
  • Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
  • Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅

What Fellow Engineers Say