BI Engineer

Role Overview

We are seeking a skilled BI Engineer with strong expertise in Business Intelligence, ETL development, data modelling, and reporting solutions. The ideal candidate will be responsible for designing and developing scalable reporting data models, building interactive dashboards, and ensuring high-quality, accurate reporting solutions. The role requires close collaboration with business stakeholders and cross-functional teams to translate business requirements into insightful analytics and reporting.

Responsibilities

• Design, develop, and maintain reporting data models, semantic layers, and curated datasets for enterprise reporting.
• Develop, optimize, and maintain ETL/ELT pipelines to extract, transform, and load data from multiple source systems.
• Build interactive dashboards and reports using BI tools such as Power BI, Qlik Sense, IBM Cognos, or Tableau.
• Develop complex SQL queries, views, stored procedures, and aggregation logic for reporting and analytics.
• Design and implement dimensional data models, including star and snowflake schemas.
• Validate and reconcile reporting data against source systems to ensure data accuracy and consistency.
• Collaborate with business users to gather reporting requirements and deliver actionable insights.
• Optimize report performance and improve data processing efficiency.
• Support User Acceptance Testing (UAT) and resolve reporting or data discrepancies.
• Participate in code reviews, version control, and CI/CD deployment processes for BI solutions.
• Enhance existing dashboards and reports based on evolving business needs.
• Utilize AI-assisted tools to improve SQL development, ETL processes, and data modeling efficiency.

Requirements

• 4–7 years of experience in Business Intelligence, Data Engineering, or Analytics.
• Strong hands-on experience in ETL development using tools such as SSIS, Azure Data Factory, Informatica, or Talend.
• Strong SQL expertise, including complex query development, performance tuning, stored procedures, views, and data optimization.
• Experience designing reporting semantic layers and enterprise reporting data models.
• Hands-on experience with Power BI, Qlik Sense, IBM Cognos Analytics, Tableau, or other enterprise BI tools.
• Strong understanding of dimensional modelling concepts, including fact tables, dimension tables, star schemas, and snowflake schemas.
• Experience working with Azure SQL Database, Azure Synapse Analytics, SQL Server, or other relational databases.
• Experience validating and reconciling reporting data with source systems.
• Familiarity with version control systems and CI/CD pipelines.
• Experience using AI tools to support SQL development, ETL design, and reporting optimization.
• Excellent analytical, problem-solving, and communication skills.

Skills

• SQL
• Power BI
• Azure Data Factory
• ETL
• Azure Synapse Analytics

Nice to Have

• Experience with Microsoft Fabric or other cloud-based data platforms.
• Knowledge of data warehousing concepts, Lakehouse architecture, and Medallion Architecture.
• Experience with Azure DevOps, Git, or similar source control tools.
• Understanding of data governance, data quality, and metadata management.
• Experience working with ERP or enterprise business applications.