DWH Development Senior Specialist

Vodafone Telekomünikasyon A.Ş.

Vodafone, one of the largest telecommunications companies in the world, has mobile operations in 26 countries (partnering with mobile networks in 55 more) and fixed broadband operations in 17 markets, serving 446 million mobile customers and 12 million fixed broadband customers around the world. Vodafone is strongly committed to lead the digital transformation in the Turkish Market, where the company has been operating and investing heavily since 2006.

• Graduate from computer engineering, computer science engineering or related disciplines 
• At least 2 years experience on DWH domain. 
• Fixed line telecommunication business know-how is a plus
• Oracle 11g and  P/L SQL is required
• ODI is required other ETL tool knowledge is a plus 
• Strong communication skills 
• Advanced Data modelling and data transformation skills 
• Project and demand management knowledge is required.

İŞ TANIMI

We are seeking a DWH Development Senior Specialist with the will and ambition to work in high performing Vodafone Team responsible for Leading Digital Transformation in Turkey, reporting to DWH Development Manager of  Vodafone Turkey.
                                       

• Work with and support customers engaged in BI Prime and Component projects to ensure all customer impacts to existing reporting 
• Conducting Data Discovery activities on the Data Warehouse and Source Systems to analyse data and determine that it is ‘fit for purpose’
• Ensure true business needs are clearly identified and clearly understood at the root so that the most effective and efficient solutions can be derived. 
• Manage scope of the Solution Design Documentation and comply with change management procedures. 
• Be able to create and/or update the Requirements Traceability Matrix to ensure requirements are managed throughout the lifecycle of development. 
• Collect system/business requirements for Business Intelligence, Reporting and Analytics solutions.
• Profile and analyse source systems, working with source system and application owners to understand source data structures. 
• Facilitate the discovery of entities, attributes, relationships, and business rules from the technical experts and the business users
• Work together as part of IT delivery ensuring DWH deliverables are providing on time in each gate i.e. Mapping Document, Design document etc.
• Design and develop data model and ETL mappings including diagram and source to target mappings document, ensuring the business requirement is met.
• Modify the physical data model for efficient data access paths.
• Generate DDL to create tables, and views
• Ensure best performance for ETL by identifying needed indexes, partitions, materialized views …etc.
• Work closely with Support team to assist of daily batch.
• Work closely with the Architecture Team to ensure the design is meeting standards and delivering the right quality to the business  
• Maintain technical and business Metadata in the Data Warehouse.
• Maintaining and enhancing the 3NF data model.
• Maintaining and enhancing the dimensional model and presentation layer.
• Source to Target Mapping specifications. 
• Presentation layer design preferred
• 2+ years of Data-Warehousing experience including 1+ years data modelling. 
• Proficient in 3rd normal form relational modelling and dimensional modelling for data marts
• Data mapping specification writing skills
• Proficient in working on data modelling tools. Preferred PowerDesigner
• Expert SQL and Database skills on Oracle
• Experience with a number of ETL tools. Preferred ODI, Ab Initio.
• Has good knowledge of Telecom – Prepaid, Postpaid, CRM etc.
• Excellent interpersonal and communication skills
• Alignment with Vodafone Group around modelling governance. 
• Ensure that deliverables are peer reviewed to assure and improve quality. 
• Review design and testing documents and work with technology and testing teams to ensure business requirements are satisfied. 
• Support testing in confirming the validity and testing of the requirements (that is, confirm that the requirements meet the business needs from both a technical and non technical perspective). 
• Identify areas for improvement/development and ensure that any necessary changes are identified and implemented. 
• Develop and coordinate through BI specialists to develop and provide data, report and dashboards as prioritised.
• Identify, manage and resolve end to end to user experience issues.
• Facilitate the Finance and Commercial month end reporting cycle through communicating the schedule and managing any delivery impacts to timing and quality to stakeholders.
• Streamlining & automating processes understanding business question / requirements while ensuring information accuracy and speed of delivery
• Work collaboratively with other team members to deliver task.
• Develop, refine and rollout common processes and procedures for technical business analysis. 
• Drive insights and innovation proactively and as requested
• Seeking automation and simplification on already running processes and also new requirements
• Communicate to all impacted stakeholders any data quality, timing or definition issues discovered in relation to existing strategic or tactically developed reports.
• Manage and support the Production support/DQ/DQ volume monitoring process through engagement with the business, communications, triage of request and operational processes.
• In conjunction with other BI teams, develop and instill a continuous improvement culture via a focus on innovation, simplification and relentless focus to standardisation.
• Advocate and influence single version of the truth, end user experience simplification and elegance.
• Drive the use of Self service BI/Analytics
• Identify and promote the definition and reuse of common business processes and practices. 
• Adhere to Vodafone policies and procedures as introduced and varied from time to time
• Impact on Business: Financial, sales, CVM, regulatory, COPS legal etc
• understand the reporting requirement, discuss and provide insights by looking at the trends, data displayed in the report.