IT Business Intelligence Specialist

We are a Romanian brand that evolved to an international group that produces and delivers energy products. With 6,000 employees and a wide range of jobs, Rompetrol has operations in Europe and Central Asia, from oil trading and refining to petrochemicals production, retail and marketing of petroleum products to providing services to other operators in the Energy industry.

Job purpose: The Business Intelligence (BI) Specialist’s role is to 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.

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;
-Database knowledge and expertise gained through demonstrably successful working experience with industry strength database solutions such as Oracle, Microsoft-SQL based systems;
-Expert knowledge of: Data loading Programming (SQL, ABAP), BO reporting, Data modeling;
-Strong ability to analyze user requirements;
-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;
-Strong understanding of the organization’s goals and objectives;
-Fluency in English;
- Strong analytical, conceptual, and problem-solving abilities;
-Able to prioritize and execute tasks in a high-pressure environment;
-A positive “can-do” attitude to work well on a team as well as independently;
Appreciated technology background: 
-MS SQL development skills (queries, stored procedures);
- Experience with Microsoft full Database Stack (T-SQL, SSIS, SSAS, SSRS);
-Experience with data warehouse, data modelling and reports using Microsoft SQL Server 2012 or higher;
OR
-Knowledge of SAP Technology components like SAP, BW, Business Objects, SAP Hana, SAP Data services, other SAP ETL tools;
-Fully aware of other SAP BI tools;
- Knowledge of SAP BPC 10.1;
- Knowledge of Power BI (DAX formulas);
- Knowledge of C#;
- Knowledge of Congos Controller/ Congos BI.

-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);
- Maintain and enhance data structure (e.g. develop new data marts);
-Master data management & metadata management;
-Periodic performance review & optimization;
-Report & Visualization maintenance (front-end);
-Adapt existing reports to new business challenges;
-Develop new reports & visualizations;
-Administer reporting tools;
- 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.

Please have in mind that only applications matching the profile we are looking for will be contacted and enter in the recruitment process.