Lead Data Analyst

The opportunity:

Hitachi Energy's Technology and Solution Development organization for Grid Power Quality Solution and Services is a global leader in developing innovative solutions for the energy sector. Within this organization, the Project Management Office plays a pivotal role in ensuring the successful delivery of projects by providing strategic oversight and leveraging data-driven insights to enhance decision-making and operational efficiency. As a Lead Data Analyst, you will spearhead data initiatives, ensuring the highest standards of data quality and integrity. You will define and implement strategies for data analysis, automation, reporting, and SharePoint-based collaboration, aligning with Hitachi Energy's organizational objectives.

We are seeking a highly skilled and motivated Lead Data Analyst to join our team. In this role, you will leverage advanced data analysis techniques, automation tools, reporting platforms, and Microsoft SharePoint to deliver actionable insights that support strategic and operational goals. Collaborating with cross-functional teams, you will ensure data quality, drive process improvements, provide leadership in data-related initiatives, and create customized SharePoint solutions to enhance collaboration and data accessibility within the Project Management Office.

How you'll make an impact:

• You will apply advanced Excel functionalities (pivot tables, macros, embedded Python) to analyze and manipulate complex datasets. To Contribute to financial analysis for project management (where applicable).
• To develop and maintain Python-based automation scripts for data quality checks, ETL processes, and reporting workflows and SharePoint-based reporting solutions, including custom web parts and Power BI integrations.
• To create and customize SharePoint sites to support project management activities, including dashboards and document repositories also utilize SharePoint lists and libraries to manage and analyze project-related datasets, ensuring data integrity and accessibility.
• To design and deploy interactive dashboards and reports using Power BI to visualize key performance indicators and insights and identify and implement automation opportunities to enhance efficiency and minimize manual intervention in data processes.
• To Leverage SharePoint Framework (SPFx) or Power Automate to automate workflows within SharePoint environments. Provide data-driven insights to support project planning, resource demand forecasting, and workforce planning.
• To collaborate with stakeholders to design and deploy SharePoint sites for project collaboration and document management also engage with stakeholders to understand data requirements and deliver customized analytical solutions.
• To leverage SharePoint Framework (SPFx) or Power Automate to automate workflows within SharePoint environments. Build and refine tools/scripts to streamline data workflows and improve organizational productivity. Lead and enforce data due diligence practices, promoting accountability and best practices in data management.
• You will be responsible for mentoring junior team members in data analysis techniques and tools.
• You will be responsible for ensure 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.

• Required bachelor's or master's degree in data science, Computer Science, Statistics, or a related field.
• Advanced proficiency in Excel (pivot tables, macros, embedded Python) and in Microsoft SharePoint, including site creation, list/library management, and basic customization.
• Experience with advanced SharePoint development, such as SPFx web parts, Power Automate workflows, or integration with Microsoft 365 services (e.g., Teams, Power Apps).
• Experience in project planning, including project controlling, resource demand analysis, and workforce planning. Strong Python coding skills with hands-on experience in automation, data quality assurance, and ETL processes.
• Demonstrated experience in stakeholder management and leading data-focused initiatives. Familiarity with Microsoft Copilot in SharePoint for AI-driven content creation or site design and additional data analysis tools or programming languages.
• Expertise in Power BI for data manipulation, dashboard creation, and reporting. Knowledge of accounting principles and project management financials. Exposure to the energy sector or grid power quality solutions.
• Exceptional analytical, problem-solving, and communication skills.
• Proficiency in both spoken and written English.