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.
