Execution Senior Analyst, Reporting

Overview

At bp, we're reimagining energy for people and our planet. We have a bold ambition be a net zero company by 2050 or sooner, and help the world get to net zero. Creating a more efficient business that makes the best use of its resources is a critical part of getting there. And that's what our new Finance Business & Technology (FBT) centre in Pune, India is here to do – put digital at the heart of our business and accelerate the transformation of bp's business processes across the globe. Driven by the bp values and comprising capabilities in data, procurement, finance and customer service, the FBT centre will drive pioneering digital solutions and agile ways of working.

Job Summary-

Job Summary and Key Accountabilities :

You will be responsible for transforming raw data into significant insights through the use of Microsoft Power BI. You will collaborate with various collaborators to understand business requirements, design and develop Power BI reports and dashboards, and provide actionable recommendations based on data analysis. The role requires a demonstrable understanding of data visualization principles, proficiency in Power BI, and the ability to communicate complex data concepts to non-technical audiences.

Power BI Development-

• Design, develop, and maintain Power BI reports and dashboards that efficiently communicate insights.
• Proficiency in designing data models and usage of power bi relationship for report the design.
• Mastery of DAX (Data Analysis Expressions), a formula language used in Power BI for calculations and data manipulation.
• Expertise in creating visually compelling and illuminating reports, dashboards power bi apps and Business KPIs.
• Knowledge of connecting to various data sources, such as databases, cloud services, APIs and Data connectivity.
• Power Query ability to use data extraction, transformation, and data cleansing.
• Skills in transforming raw data into a format suitable for analysis.
• Familiarity with SQL for querying databases.
• Use of SQL Stored procedure, Joins, Group by Subquery.
• Apply DAX (Data Analysis Expressions) for creating custom calculations and measures.
• Integration of appropriate security models to end user reporting solutions with the use of row
• level security, Object level security and distribution lists).
• Integration and management of Power Platform components to support the end reporting solution (e.g., Data warehouse Power Flows, Power Automate, SharePoint etc).
• Connecting data sources, including use of gateways and XMLA endpoints.
• Design and develop power bi report and dashboard with large datasets (20m+ records).

Data Analysis and Interpretation-

Data Integration and Management-

Qualifications, Competencies & Approach

Crucial Education & Experience

Approaches-

Own your success : Accountable for delivering innovative business outcomes; Seeks opportunities to improve and digitize process delivery; Adheres to safe and ethical work practices.

Think big : Actively builds own knowledge, capabilities and skills for the future, Values partnership and collaborates to achieve results.

Be curious : Willing to suggest new ways of working, processes and technologies; Ensures the delivery and improvement of digital solutions to benefit customers.

Effortless customer experiences : Understands customer needs and delivers digital detailed self

Key Competencies-

Operational Perfection : Has a sound understanding of process and workflow streamlining, problem resolution and organisational change.

Risk Management : Identifies external and internal factors that impact risk and mitigation opportunities. Identifies potential new or emerging risks / threats and implements mitigation plans. Builds energy around a change using a systematic approach to transition from the present to the desired state.

Digital Fluency : Efficiently uses digital guidance, tools, methods, security measures for operating as a digital business. Uses digital tools to collaborate, organize, plan and reflect on digital data.

Analytical Thinking : Systematically breaks down a complex problem or process into component parts using logical analysis techniques to reach a solution. Logically assesses relationships, grasps inter-dependencies, and reviews trends within a complex problem or situation.

Decision Making : Makes decisions affecting both own tasks and those of others. Combines a variety of factors including commercial awareness, risk and financial expertise to make appropriate decisions and derive insights.

Innovation : Adapts existing processes, methods and ways of working to drive efficiency. Uses digital technologies to develop new insights, projects and opportunities.

Influencing : Identifies areas of alliance and disagreement, evaluates options and potential outcomes, and plans influencing strategy. Identifies short term customer needs and communicates benefits to the collaborator. Knows when and how to use the chain of command.

Problem Solving : Evaluates and prioritises problems for own area. Resolves problems in a timely Evaluates and prioritises problems for own area. Resolves problems in a timely way, using a combination of logic and experience to make decisions and address problems.

Relationship Management : Establishes and handles relationships with peers and internal business partners to achieve results.

Come, join our bp team!

Skills Required

Data Visualization, Data Integration, Microsoft Power Bi, Data Cleansing, Power Query, Sql