BI Engineer

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

Job summary

A leading company in user experience research is seeking a BI Engineer to create and manage business intelligence solutions. The role involves designing ETL workflows, developing dashboards, and ensuring data integrity. Candidates should have a relevant degree and proficiency in SQL and BI tools. This position offers the opportunity to work with cutting-edge technologies in a collaborative environment.

Qualifications

• Proficiency in SQL and experience with database management.
• Experience with BI tools like Power BI and Tableau.
• Knowledge of ETL tools and data integration.

Responsibilities

• Design and implement ETL workflows for data integration.
• Develop and maintain interactive dashboards and reports.
• Ensure data integrity and quality in the pipeline.

Skills

SQL

Data manipulation

Data governance

ETL processes

BI tools

Cloud platforms

Big data technologies

Education

Bachelor’s or Master’s degree in Information System

Bachelor’s or Master’s degree in Computer Science

Bachelor’s or Master’s degree in Software Engineering

Bachelor’s or Master’s degree in Data Science

Tools

Power BI

Tableau

Apache Nifi

MySQL

SQL Server

Oracle

AWS

Azure

GCP

Hadoop

Spark

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.