DWH/BI Consultant

Employer: Vauban
Domain:
  • Banks - Financial Institutions
  • IT Software
  • Telecommunication
  • Job type: full-time
    Job level: 1 - 5 years of experience
    Location:
  • BUCHAREST
  • Updated at: 06.08.2019
    Short company description

    Vauban is a Romanian Group with more than 11 years of sustainable and healthy growth. We do focus on innovation, learning, entrepreneurship and capacity to find new solutions. The company figures are +450 consultants, +100 clients, having locations in Romania and France.
    Our teams daily deliver Technology Services as consultancy (missions at clients’ premises), and also from our delivery center (integration & application development in digital and BI, Software as a Service management, Production, security and infrastructure).
    Vauban is also the Romanian partner with Top premium software editors, leader in data governance and security, being responsible to integrate the solutions and to ensure local support.

    Requirements

    Good understanding and usage of SQL-PL/SQL in the context of data warehouse solutions - minimum 5 year experience developing in SQL-PL/SQL
    Experience in tuning complex DWH/BI (based on SQL-PL/SQL) environments as far as data volumes
    Experienced in ETL process design and data flows optimization
    Advanced technical knowledge of Oracle specific database structures (indices, partitions, data dictionary, explain plans…)
    Previous experience in usage of ETL (ODI/ INFORMATICA)
    Knowledge of telecommunications industry data model would be an advantage
    Understanding of Tableau, Business Objects, Oracle Discoverer and Java it's a plus
    Previous data modelling experience would be an advantage

    Responsibilities

    Participate (design & development) in the extension of DWH and related business intelligence applications and data structures:
    Integration of new data sources
    Data marts implementation
    Metadata based solutions and tools
    Develop and enhance PL/SQL ETL data flows
    Integration of tools in the area of reporting & analytics
    Align with different development teams the interfaces and solutions defined
    Development, creation of the related functional and technical documentation
    Performance testing for the implemented solutions
    Mentoring and peer development for new team members
    Testing and validation of the applications for deployment and production
    Support operations teams in case there are issues identified in the production environment
    Act as an expert on different subject areas solution components depending on allocated responsibilities

    Other info

    Benefits:
    Interesting salary conditions
    Undetermined period of contract
    Career plan (professional, academic and financial)
    Medical insurance
    Official trainings and certifications
    English, French, soft skills trainings
    Lunch tickets
    Yearly professional evaluation
    Professional and friendly working environment
    Professional infrastructure
    Join a multinational team.