Database Designer

Angajator: Vodafone Romania
  • IT Software
  • Tip job: full-time
    Nivel job: 1 - 5 ani experienta
  • Actualizat la: 04.12.2020
    Scurta descriere a companiei

    Every great brand stands for something and, at Vodafone, our purpose is ‘to connect for a better future’.
    Vodafone is a leading telecommunications company in Europe and Africa. Our expertise and scale give us a unique opportunity to drive positive change for society. Our networks keep family, friends, businesses and governments connected and – as the COVID-19 pandemic has proven – we play a vital role in keeping economies running and the functioning of critical sectors like education and healthcare.
    Working at Vodafone is all about helping people to benefit from the new technology and innovations. We bring the future to even the most remote places, using technology to help families in disaster zones, enabling access to digital for the vulnerable, connecting millions of vehicles to the internet and thinking about technology that doesn’t even exist yet.
    Over 30 years ago, we made the first ever mobile phone call and sent the first SMS in Britain and have been changing the lives of billions of people ever since. In Romania, we are also carrying a long history of firsts – first mobile operator in Romania, first GSM operator to launch the short messaging service (SMS) and first to offer GPRS (2001), 3G (2005), 4G (2012) and 5G (2019) services – and innovations: we offered world’s first live hologram concert and, later, 4K holograms of Romanian mothers.
    We believe being different is good. We can only leverage this diversity by building an inclusive culture where everyone is respected, can be themselves and strive to be their best. We do this through our maternity and parental leave policies, by empowering women through connectivity and improving access to education and digital skills for women, girls, and society at large. We are respectful of all individuals, irrespective of race, ethnicity, disability, age, sexual orientation, gender identity, belief, culture or religion. Your different perspectives help us to shape the future.
    At Vodafone, we are also taking significant steps to reduce our impact on our planet by reducing our greenhouse gas emissions by 50% by 2025, purchasing 100% of our electricity from renewable sources by 2025, and reusing, reselling or recycling 100% of our redundant network equipment.

    The future is exciting. Ready?


    Competente, cunostinte si experienta:

    •Facultate cu profil IT (ex. Automatica, Electronica, Cibernetica)
    •3-4 ani experienta profesionala in programare baze de date, raportare
    •Cursuri de programare SQL si proiectare baze de date – preferabil
    •Experienta in Business Objects, SAS, Qlik, Tableau – preferabil
    •Baze de date si programare SQL
    •Cunostinte de proiectare si arhitectura baze de date si sisteme
    •Excel, Access
    •Experiență cu aplicatii de raportare


    Scopul postului:

    •Asigura sursele de date necesare BICC pentru producerea rapoartelor si analizelor, cu accent pe alinierea definitiilor, integrarea intregului portofoliu VF-RO in structuri unitare de date (inclusiv fix) si defragmentarea / alinierea rapoartelor si surselor de date
    •Colaboreaza permanent cu departamentul IT in toate proiectele cu impact in datawarehouse, inclusiv programe transformationale – asigura rolul de business project management, analiza sistemelor sursa, designul modelului de date DW, testarea integrarilor
    •Proiecteaza structura datamart-ului SAS BICC, dezvolta procesele de incarcare a datelor si asigura mentenanta acestora; proiecteaza si implementeaza layer-ele semantice pentru rapoarte si vizualizari interactive
    •Rol central in stabilirea strategiei BICC dpdv tehnic (evolutia datawarehouse VF-RO, datamart BICC, solutii de raportare interactive / self-service)
    •Ofera consultanta BICC-DDV in vederea identificarii surselor corecte si relevante pentru dezvoltarea de noi rapoarte
    •Asigura suport si consultanta pentru consolidarea portofoliului existent de rapoarte si alinierea acestuia la sursele si definitiile agreate
    •Proiecteaza si dezvolta procese de prelucrare si livrare a datelor pentru solicitarile care presupun un grad avansat de expertiza in programare si cunoastere a datelor sursa
    •Asigura procesul de Reference Data Management (intretinerea nomenclatoarelor din DW cu input din business)
    •Monitorizeaza permanent calitatea datelor extrase din sistemele de raportare, semnaleaza anomaliile si contribuie la remedierea defectelor

    Responsabilitati principale:

    Asigurarea surselor de date necesare in activitatea BICC:
    •Colecteaza, consolideaza si analizeaza nevoile de raportare, implementeaza procesele necesare pentru furnizarea datelor sursa, traduce cerintele de business si definitiile in cerinte tehnice, colaboreaza cu departamentul IT pentru integrarea de noi surse de date in datawarehouse
    •In cadrul proiectelor cu impact in datawarehouse (inclusiv proiecte transformationale in zona operationala), asigura business project management, colaboreaza cu IT pentru proiectarea modelului de date relevant, asigura testare de business a proceselor de integrare
    •Proiecteaza si dezvolta flow-urile de integrare pentru datamart-ul BICC, asigura mentenanta acestuia si il documenteaza / expune catre BICC-DDV si alte entitati cu capabilitati de procesare a datelor – CVM, Big Data, Group BI
    •Asigura intretinerea consistenta a Reference Data (nomenclatoarelor), cu input din business

    Definirea si implementarea strategiei BI:
    •Are rolul principal (in colaborare cu IT) in stabilirea strategiei tehnologice a BICC in ceea ce priveste dezvoltarea datawarehouse VF-RO (impreuna cu IT), aplica directiile strategice VF-Group, identifica si contribuie la implementarea celor mai eficiente solutii si aplicatii de raportare
    •Stabileste metodologiile de lucru ale BICC in ceea ce priveste activitatea de dezvoltare a rapoartelor, inclusiv self-service
    •Participa la activitatile si proiectele echipei in conformitate cu alocarile de resurse facute de catre managementul departamentului

    Raportare integrata:
    •Asigura consultanta si suport catre BICC-DDV pentru identificarea surselor cele mai eficiente pentru dezvoltarea de rapoarte, cu respectarea definitiilor aliniate de business
    •Identifica si consolideaza rapoarte fragmentate / ne-aliniate dpdv surse de date sau definitii
    •Dezvolta flow-uri de procesare de date reutilizabile si le documenteaza / expune catre BICC-DDV sau alte departamente cu capabilitati de procesare a datelor
    •Expune sursele de date BICC in layer-e semantice pentru exploatarea in aplicatii de vizualizare a datelor (layering)
    •Implementeaza si livreaza rapoarte sau prelucrari de date in zonele care presupun un grad inalt de expertiza
    •Monitorizeaza permanent calitatea datelor extrase din sistemele de raportare, semnaleaza anomaliile si contribuie la remedierea defectelor