Business Analytics Technical Expert

Employer: Rompetrol - KMG International
Domain:
  • IT Software
  • Job type: full-time
    Job level: 1 - 5 years of experience
    Location:
  • BUCHAREST
  • Updated at: 25.01.2020
    Short company description

    Rompetrol, part of KMG International, is the place where thousands of minds spread throughout 11 countries are connecting to each other to create the energy we all need to get further. You may think of us as an Oil & Gas powerhouse, which combines the strength of the experienced with the eagerness of the new.
    This is how we grew over the past 40 years into a group of true professionals, specialized in diverse fields of work: Trading, Refining & Petrochemicals, Retail, Industrial Services.
    We believe that through trial and perseverance, true ambition is inspired and success achieved. With this reasoning, we intend to welcome you to our Rompetrol family and help you reach your full potential. So, are you ready to begin or continue your career, in a diverse and fulfilling environment?

    Requirements


    Job Summary

    Strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering is also responsible for ensuring high levels of BI availability through support functions and in-depth testing requirements, designing, and rolling out BI solutions to end users.

    Job Description

    •    Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary;
    •    Troubleshoot Business Planning and Consolidation tools, systems, and software; performance-tune these applications as necessary;
    •    Data Warehouse maintenance (back-end);
    o    Maintain and enhance data structure (e.g. develop new data marts);
    o    Master data management & metadata management;
    o    Periodic performance review & optimization;
    •    Report & Visualization maintenance (front-end);
    o    Adapt existing reports to new business challenges;
    o    Develop new reports & visualizations;
    o    Administer reporting tools;
    o    User access management;
    •    Develop and manage ETL processes ;
    •    Design, code, test, and document all new or modified BI systems, applications, and programs;
    •    Develop the semantic layer, metadata, reports, and report definitions;
    •    Develop graphs and portal interfaces;
    •    Design of databases and data warehouses to ensure interoperability with BI solutions
    •    Analyze user requirements and, based on findings, design functional specifications for BI front-end applications;
    •    Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system;
    •    Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion;
    •    Conduct job duties and responsibilities according to the organization’s business systems development methodology and/ or its Systems Development Life Cycle (SDLC) methodology;
    •    Design and deliver end-user training and training materials, provide technical support as necessary.

    Requirements

    •    University degree in the field of computer science, information systems, or computer engineering;
    •    Minimum 1 year experience of direct work experience within a complex BI environment: maintenance, support and/or development;
    •    Expert knowledge of Data loading, Programming (SQL, ABAP), BO reporting, Data modeling, Oracle, Microsoft-SQL based systems;
    •    Strong ability to analyze user requirements and experience in business planning;
    •    Strong willing to learn and assimilate new solutions and technology features;
    •    Strong understanding of relational database structures, theories, principles and practices;
    •    Experience with data processing flowcharting techniques;
    •    OLAP Modelling exposure;
    •    Fluency in English;
    •    Strong analytical, conceptual, and problem-solving abilities.


    Appreciated technology background:

    •    Knowledge of SAP Technology components like SAP BW and BW4H, Business Objects, SAP Hana , SAP Data services, SAP BPC other SAP ETL tools or SAP BI tools;
    •    Knowledge of SAP BPC 11, Power BI (DAX formulas), C#, Congos Controller/ Congos BI.

    Responsibilities

    Job Summary

    Strategically design and implement BI software and systems, including integration with databases and data warehouses. This includes selecting, blueprinting, gathering is also responsible for ensuring high levels of BI availability through support functions and in-depth testing requirements, designing, and rolling out BI solutions to end users.

    Job Description

    •    Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary;
    •    Troubleshoot Business Planning and Consolidation tools, systems, and software; performance-tune these applications as necessary;
    •    Data Warehouse maintenance (back-end);
    o    Maintain and enhance data structure (e.g. develop new data marts);
    o    Master data management & metadata management;
    o    Periodic performance review & optimization;
    •    Report & Visualization maintenance (front-end);
    o    Adapt existing reports to new business challenges;
    o    Develop new reports & visualizations;
    o    Administer reporting tools;
    o    User access management;
    •    Develop and manage ETL processes ;
    •    Design, code, test, and document all new or modified BI systems, applications, and programs;
    •    Develop the semantic layer, metadata, reports, and report definitions;
    •    Develop graphs and portal interfaces;
    •    Design of databases and data warehouses to ensure interoperability with BI solutions
    •    Analyze user requirements and, based on findings, design functional specifications for BI front-end applications;
    •    Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system;
    •    Work with project managers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion;
    •    Conduct job duties and responsibilities according to the organization’s business systems development methodology and/ or its Systems Development Life Cycle (SDLC) methodology;
    •    Design and deliver end-user training and training materials, provide technical support as necessary.

    Requirements

    •    University degree in the field of computer science, information systems, or computer engineering;
    •    Minimum 1 year experience of direct work experience within a complex BI environment: maintenance, support and/or development;
    •    Expert knowledge of Data loading, Programming (SQL, ABAP), BO reporting, Data modeling, Oracle, Microsoft-SQL based systems;
    •    Strong ability to analyze user requirements and experience in business planning;
    •    Strong willing to learn and assimilate new solutions and technology features;
    •    Strong understanding of relational database structures, theories, principles and practices;
    •    Experience with data processing flowcharting techniques;
    •    OLAP Modelling exposure;
    •    Fluency in English;
    •    Strong analytical, conceptual, and problem-solving abilities.


    Appreciated technology background:

    •    Knowledge of SAP Technology components like SAP BW and BW4H, Business Objects, SAP Hana , SAP Data services, SAP BPC other SAP ETL tools or SAP BI tools;
    •    Knowledge of SAP BPC 11, Power BI (DAX formulas), C#, Congos Controller/ Congos BI.

    Other info

    Rompetrol, part of KMG International, is the place where thousands of minds spread throughout 11 countries are connecting to each other to create the energy we all need to get further. You may think of us as an Oil & Gas powerhouse, which combines the strength of the experienced with the eagerness of the new. This is how we grew over the past 40 years into a group of true professionals, specialized in diverse fields of work: Trading, Refining & Petrochemicals, Retail, Industrial Services. We believe that through trial and perseverance, true ambition is inspired and success achieved. With this reasoning, we intend to welcome you to our Rompetrol family and help you reach your full potential. So, are you ready to begin or continue your career, in a diverse and fulfilling environment?