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.
Key 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/QlikView,
IBM Cognos, Tableau, or similar platforms.
- 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.
Required Skills & Experience
- 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
(ADF), Informatica, Talend, or similar ETL platforms.
- 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/QlikView, 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.
Preferred Skills
- Experience with Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, or other cloud-
based data platforms.
- Knowledge of data warehousing concepts, Lakehouse architecture, and Medallion Architecture
(Bronze, Silver, Gold).
- 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.
- Exposure to financial, operational, or enterprise reporting environments
Work Location: In person
