Seeking a Data Analyst with expertise in Power BI to support our digital initiatives in KPI dashboarding through a templated reporting approach. This role involves facilitating data discovery workshops, performing data cleansing and transformation, and contextualizing data from multiple enterprise systems to deliver insightful and standardized performance dashboards.

RESPONSIBILITIES: 

• Conduct data discovery workshops with business and technical stakeholders to identify KPI requirements and data sources. 

• Interpret data, analyze results using statistical techniques to develop the KPIs 

• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality 

• Identify, analyze, and interpret trends or patterns in complex datasets 

• Cleanse, transform, and integrate data from multiple systems used for processes and operational. 

Perform data observation and profiling to assess quality, completeness, and consistency of source data. 

• Generate reports as required and present findings to aid decision-making to prepare the datasets. Contextualize data to align with business processes and operational hierarchies (e.g., asset-level, business unit, site-level views). 

• Work closely with IT, data engineering, and business teams to ensure seamless data flow and transformation. 

• Identify and Validate data mappings and calculation logic for key metrics and ensure alignment with approved definitions. 

• Prepare and maintain documentation of datasets whit respective systems and KPIs. 

• Identify and suggest opportunities for automation, improved visualization, or enhanced insights in reporting processes. 

• Develop and maintain standardized Power BI dashboards as per business KPIs. 

• Work closely with Power BI developer to deploy interactive Power BI dashboards and reports based on business requirements. 

• Familiarity with Microsoft Power Platform (Power Automate, Power Apps) is a plus. 

• Analyse existing SQL queries for performance improvements. 

• Proficiency in writing complex queries on various structured databases 

• Develop the connector, gateways to integrate the data from source applications. 

QUALIFICATIONS: 

• Bachelor’s degree in computer science, Information Systems, Engineering, or a related field. 

• 8+ years of experience in developing Power BI reports and dashboards in a corporate or industrial setting. 

• Expertise and Certified in Python, Design Patterns, Data Engineering, NumPy, pandas, OCR, Tableau etc. 

• Certification in Microsoft Power BI or related data analytics platforms. 

• Strong understanding of data modelling (Star/Snowflake schema), Power Query (M), and DAX. 

• Experience in connecting Power BI to various data sources like SQL Server, Oracle, SharePoint, Excel, or REST APIs. 

• Familiarity with Microsoft Power Platform (Power Automate, Power Apps) is a plus. 

• Understanding of engineering project workflows or EPC business environments is highly desirable.