BI Engineer

USER EXPERIENCE RESEARCHERS PTE. LTD.; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

A leading company is searching for a BI Engineer responsible for creating and managing business intelligence solutions. In this role, you will design ETL processes, develop dashboards, and maintain data integrity. Ideal candidates will have a background in Information Systems or related fields with skills in SQL and BI tools.

Qualifications

• Bachelor’s or Master’s degree in relevant field is required.
• Proficient in SQL and experience with various databases.
• Experience with BI tools like Power BI and Tableau.

Responsibilities

• Design and implement ETL workflows for data management.
• Develop and maintain data models and interactive dashboards.
• Ensure data integrity and quality in BI processes.

Skills

SQL

Data Manipulation

Data Integration

ETL Processes

Dashboard Development

Cloud Platforms

Education

Bachelor’s or Master’s degree in Information System, Computer Science, Software Engineering, Data Science

Tools

Power BI

Tableau

MySQL

SQL Server

Oracle

Apache Nifi

AWS

Azure

GCP

Job description

The BI Engineer will be responsible for creating and managing business intelligence solutions, including data modeling, ETL (Extract, Transform, Load) processes, report and dashboard development, and data warehousing.

Responsibilities:

• Design and implement efficient ETL workflows to extract, transform, and load data from various sources into a centralized data warehouse.
• Ensure data integrity, quality, and accuracy in the pipeline.
• Develop and maintain data models that provide insights into business operations, ensuring scalability and performance.
• Design, develop and maintain interactive dashboards and reports using BI tools such as Tableau, Power BI.
• Monitor and tunes BI tools to ensure optimum level of performance.
• Optimize queries and database performance to ensure fast access to large datasets.
• Automate recurring reports and analysis to minimize manual work while ensuring timely delivery of insights.
• Develop self-service BI solutions that allow end-users to access the data they need independently.
• Implement and maintain processes for data governance, ensuring that data is secure, compliant, and accurate.
• Perform data validation and quality checks regularly to ensure the integrity of business reports.
• Support upgrades, configuration and troubleshooting for business intelligence tools.
• Work with team leaders to understand user requirement needs and develop BI solutions tailored to those requirements.
• Modify existing reports, extracts, dashboards when necessary.

Requirements:

• Bachelor’s or Master’s degree in Information System, Computer Science, Software Engineering, Data Science or a related field.
• Proficiency in SQL and experience with database management (e.g., MySQL, SQL Server, Oracle, etc.).
• Experience with BI tools (e.g., Power BI, Tableau, etc.).
• Knowledge of ETL tools and data integration (e.g., Apache Nifi, etc.).
• Familiarity with programming languages (e.g., Python, R) for data manipulation and analysis.
• Good verbal communication skills.
• Comfortable working with a team.
• Experience of cloud platforms (e.g., AWS, Azure, GCP) and big data technologies (e.g., Hadoop, Spark) is an added advantage.
• Experience of report tools such as Elixir report is an added advantage.