01Key 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:
47 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 .
