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.