Data Engineer - MIS
Description
Join our journey as we connect for a better future. Ready?
We are looking for a
Data Engineer
#Vodafonespirit
Our purpose at Vodafone is to connect for a better future. As a Global Communications Technology company, we put the customer at the heart of everything we do. We are forever challenging, pushing boundaries and discovering innovative ways to connect our customers with their digital societies.
We connect people, businesses, and communities across the globe to create the future. We earn customer loyalty, experiment, learn fast and get it done, together. As you can imagine, this means that we have a vibrant and diverse mix of skills and people making Vodafone a great place to work.
ROLE PURPOSE
This role is required for “Data Analytics - MIS” Team as part of Vodafone IT organization. MIS team is responsible for providing Revenue Sharing Data to Finance Operations team, Settlement Reports and VBU Invoice Reports.
Gathering data from multiple sources -without changing- (even CDR data)
Critical Reports
Settlement & Revenue sharing
VBU Invoice Reports
CBU Postpaid & Prepaid Donation Reports
SMS Interconnection Reports (Incoming/Outgoing)
Revenue Sharing for Marketplace and VF Mall
Dijital SIM OTP Revenue sharing
Legal Reporting (Tubitak,BDDK,GIB,Ticaret Bakanlığı,BTK etc)
Job Responsibility
Your place in the team
• Collect system/business requirements for MIS Reports.
• Conduct Data Discovery activities on Source Systems to analyse data and determine that it is ‘fit for purpose (reverse engineering skills are preferred)
• Ensure true business needs are clearly identified and clearly understood at the root so that the most effective and efficient solutions can be derived.
• Profile and analyse source systems, working with source system and application owners to understand source data structures.
• Design and develop data model
• Modify the physical data model for efficient data access paths.
• Generate DDL to create tables, and views
• Develop the required PL/SQL etl code, conduct unit & sat tests and deploy the code on production
• Ensure best performance for ETL by identifying needed indexes, partitions, materialized views …etc.
• Monitor and take required actions for the proper run of daily & monthly etl runs.
• Work closely with the Architecture team to ensure the design is meeting standards and delivering the right quality to the business
Long Description
We are looking for you if you have
• 5+ years experience in datawarehouse domain especially in requirements analysis, development, specifically the challenge and validation of data capability and reporting requirements
• Worked for source systems data analysis, source to target mapping, 3NF modelling and presentation layer design support.
• Knowledge on basics of DWH and exposure to BI projects
• Deep level PL/SQL development experience is must, ODI is a plus
• Understanding of business applications, interfaces and integrated operational environments
• End to end experience of software development lifecycle
• Good understanding of Telco and finance business
• Knowledge of Powerdesigner is a plus.
• Highly developed time management skills and ability to prioritise workload
• Ability to draw conclusions from detailed data sets and confidently communicate this back to senior stakeholders
• An understanding of user needs and a focus on the business outcome
• A logical approach to problem solving and an investigative and inquisitive mind
• Experience in collating and documenting requirements
• People leadership experience & good people management skills with experience of creating and managing effective teams
• Knowledge of agile and devops methodologies (preferred)
• Knowledge of BI tools such as Business Objects and Tableau (preferred)
Get to know us
If you want to know more about us and what we do, then visit our website: www.vodafone.com.tr
Instagram: https://www.instagram.com/vodafonekariyer/
Youtube: https://www.youtube.com/user/VFTurkiye
Diversity and Inclusion