Data Analytics & Business intelligence specialist

The opportunity

As a Project Management Power BI Analyst you will be part of Operation Center, India (INOPC-PGTR), you will be part of and the Project management Team, aiming to develop a global and wholistic environment of operational analytics, where key QO activities, resources and expertise are shared globally to optimize PGTR's operational and quality performance. Key activities will be mostly, but not exclusively, the development of the main PGTR QO PowerBI workspace, further detailed adhoc analytics leveraging PowerBI, Excel & PowerPoint, the development of the BU's QO reporting and Analytics Teams space and many more.

How you’ll make an impact

• Assist in planning and monitoring PM transformation goals in Hub APMEA. Contribute to the enhancement of PM methodologies and tools, recommending ways to improve delivery effectiveness. Automate key processes and documents to improve Project Management tools.

• Prepare and maintain key project documents (plans, timelines, status reports) to ensure transparency and accountability.

• Support of the PGTR PMM Management with the development and administration of the BU-QO’s Power BI workspace. Design, build and, maintain dashboards (E.g. Gate Model KPIs, Project Risk & Opportunity Review, etc.) using Power BI to support data driving decisions.

• Building Analysis Services reporting models. Developing visual reports, dashboards and KPI scorecards using Power BI desktop. Connecting to data sources, importing data, and transforming data for Business Intelligence.

• Translating data into informative visuals and reports. Implementation of row level security on data and application security layer models in Power BI. Creation of DAX queries in Power BI desktop.

• Applying advance level calculations on the data set. Development of tabular and multidimensional models that are compatible with warehouse standards. Developing, publishing and scheduling Power BI reports as per the business requirements.

• Extraction and analytics of data from various tools and other relevant sources to measure the performance of specific activities or initiatives for the QO  Department. Creation of What/IF analyses or scenario analyses.

• Undertake adhoc customized analytics and creation of Knowledge portals in sharepoint. Develops and maintain reports and dashboards (including but not limited to Relex Analyzer and PowerBI Dashboards) for the Transformers Quality & Operations Department.

• Supports in training the stakeholders about the usage of the reports and dashboards. Proactively monitors and strives to maintain high levels of data quality and completeness. Supports on data cleansing to enhance the quality of reporting.

• Development & maintenance of the BU QO’s Reporting & Analytics Teams Space / Sharepoint. Help maintain an up-to-date online documents library that includes general information & Instructions for the reporting and usage of the BI tools Basics.

• Extended MS Office knowledge & skills, especially excel but also eg PowerPoint, etc. Knowledge of HE / PGTR organizational structure & operational KPIs preferred. Experienced in building MS Teams Space & SharePoint pages. Be flexible across timezones for certain meetings (Meetings only).

• Responsible for ensuring compliance with applicable external and internal regulations, procedures, and guidelines.

• Living Hitachi Energy’s core values safety and integrity, which means taking responsibility for your own actions while caring for your colleagues and the business.

Your background

• Bachelor’s degree B.E/B.Tech in relevant field. 3 -6 years of experience in Power BI Analytics/ Process optimization using Power App & Power Atomate.

• Specialist on building visualizations in PBI based on various sources and datasets. Strong capabilities of DAX queries / DAX functions / Power Query Editor. PL-300 certification preferred.

• Experience with SAP / S4 HANA -Data handling Preferred. Experienced in connecting different data sources in 1 Power BI.

• Adept in developing, publishing and scheduling Power BI reports as per the business requirements.

• Expertise in using advance level calculations on the data set. Able to develop tabular and multidimensional models that are compatible with warehouse standards.

• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources. Familiar with Row Level Security (RLS).

• Basic knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, SSAS, Visual Studio, Power Apps etc

• Proficiency in both spoken & written English language is required.