Junior Business Intelligence Specialist

Job description

Entity: Finance Job Family Group: Finance Group Job Description: We are a global energy business involved in every aspect of the energy system. We are working towards delivering light, heat, and mobility to millions of people every day. We are one of the very few companies equipped to solve some of the big complex challenges that matter for the future. We have a real contribution to make to the world's ambition of a low-carbon future. Join us and be part of what we can accomplish together. Would you like to discover how our diverse, hardworking people are leading the way in making energy cleaner and better – and how you can play your part in our world-class team? The role will have responsibilities manage Business Intelligence across the Cash & Credit. This includes the maintenance of standard MIS reports, monthly scorecards, BI Dashboard, data visualization and automation implementation. This is an individual contributor role working as an enabler for the entire function across all geographies. The role will be internal facing & will be largely responsible for internal collaborators Key Accountabilities Build, publish & upgrade standard reporting framework with appropriate data visualization (Excel, Tableau, Power BI, or QlikView) for Cash & Credit teams. Develop and implement VBA macro or small automation as per business needs Develop & implementation of reporting & performance Dashboard (BI, excel, etc.) with insights and visualization. Participate in the design and enhancement of data architecture and reporting systems to improve efficiency and scalability. Provides reliable data & reporting solutions, metrics & analytics that help optimize a sustainable workforce & drive fact-based decision by Business Leaders Develop and maintain complex SQL queries and scripts to retrieve data efficiently. Analyse large datasets to identify trends, anomalies, and potential risk factors. Prepare comprehensive reports and dashboards for key participants, including executives and regulatory agencies. Collaborate with multi-functional teams to understand reporting requirements and deliver actionable insights. Implement data quality checks and ensure the accuracy and integrity of reporting data. Stay updated on industry trends, best practices, and regulatory changes related to credit risk reporting. Provide ad hoc analysis and support to address specific business questions or challenges. Exposure to Power Apps and Building or updating BI dashboards (at macro and micro level). Must be able to work specific shifts and have ability to work across various time zones and regions Extract, transform, and load (ETL) credit risk data from SAP and Big Data sources. Exposure and experience with six sigma methodologies Qualifications & Competencies Bachelor’s degree with experience in finance, Economics, Statistics, Computer Science, or a related field. Min 4-5 yrs demonstrable experience in data analysis, reporting, and visualization, preferably in a O2C, credit risk or financial services environment. Proficiency in SAP modules (e.g., SAP BW, SAP HANA) and Big Data technologies (e.g., Hadoop, Spark). Experience in MIS reports, monthly scorecards, BI Dashboard, data visualization and automation implementation. Advanced SQL skills with experience in querying large datasets. Familiarity with data visualization tools such as Tableau, Power BI, or QlikView. Strong analytical and problem-solving abilities with keen attention to detail. Superb communication and interpersonal skills, with the ability to collaborate effectively across teams. Ability to prioritize tasks, manage multiple projects simultaneously, and meet tight deadlines. Knowledge of regulatory requirements (e.g., Basel III, CCAR) related to credit risk reporting is a plus. Understanding of statistical methods and modelling techniques is desirable. Technical Capability Strong MIS Reporting Capability using Excel, Tableau, Power BI, or QlikView Ability to run basic automation using SQL, Access, Sharepoint, Infopath Data Visualization Business Capability Good understanding of the Finance industry (especially O2C) Good knowledge of CI principles like Agile, Six sigma, Lean Understanding of different operating and charging models used in the Finance industry (especially O2C) E2E understanding of the process lifecycle in the Shared Services space At bp, we provide an excellent environment and benefits such as an open and inclusive culture, a great work-life balance, tremendous learning, and development opportunities to craft your career path, life and health insurance, medical care package and many others! Diversity sits at the heart of our company, and as an equal opportunity employer, we stay true to our mission by ensuring that our place can be anyone's place. We do not discriminate based on race, religion, colour, national origin, gender and gender identity, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided with reasonable accommodation to participate in the job application and interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Travel Requirement No travel is expected with this role Relocation Assistance: This role is not eligible for relocation Remote Type: This position is a hybrid of office/remote working Skills: Dashboard Reporting, Data Reporting, Microsoft Power Business Intelligence (BI), MS SQL Queries, Office VBA, Reporting, Standard Reports . Legal Disclaimer: We are an equal opportunity employer. We do not discriminate on the basis of protected characteristics like race, religion, color, sex, national origin, sexual orientation, veteran status or disability status. Individuals with an accessibility need may request an adjustment/accommodation related to bp’s recruiting process (e.g., accessing the job application, completing required assessments, participating in telephone screenings or interviews, etc.). If you would like to request an adjustment/accommodation related to the recruitment process, please contact us . If you are selected for a position and depending upon your role, your employment may be contingent upon adherence to local policy. This may include pre-placement drug screening, medical review of physical fitness for the role, and background checks.