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.

- University degree in the field of computer science, information systems, or computer engineering.
- Very strong database knowledge and expertise gained through demonstrably successful working experience with industry strength database solutions such as Oracle, Microsoft-SQL based systems.
- Minimum 5 years of direct work experience within a complex BI environment.
- Expert knowledge of:
o Data loading
o Programming (SQL, ABAP)
o BO reporting
o Data modeling
- Strong ability to analyze user requirements.
- Strong understanding of relational database structures, theories, principles, and practices.
- Experience with data processing flowcharting techniques.
- OLAP Modelling exposure.
- Strong MS SQL development skills (queries, stored procedures).
- Experience with Microsoft full Database Stack (T-SQL, SSIS, SSAS, SSRS).
- Minimum one year experience with data warehouse, data modelling and reports using Microsoft SQL Server 2012 or higher.
- 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;

Nice to have:

- Experience in business planning
- 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.

- 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.
- Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary.
- Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.