IT Demand & Delivery - DWH Manager

A leading telecommunication company in Saudi Arabia, is seeking an experienced IT Demand & Delivery - DWH Manager to join their team. The IT Demand & Delivery - DWH Manager will be responsible for managing the demand and delivery of data warehouse solutions to meet the business needs of the organization.

In this role, you will work closely with business stakeholders, IT teams, and external vendors to define data requirements, develop data warehouse strategies, and oversee the delivery of data warehouse projects. You will also be responsible for ensuring the availability, security, and integrity of data within the data warehouse environment.

Key Responsibilities:

• Collaborate with business stakeholders to identify and prioritize data requirements.
• Develop and implement data warehouse strategies and roadmaps.
• Lead the design and development of data warehouse solutions.
• Oversee the delivery of data warehouse projects, ensuring adherence to project timeline and budget.
• Ensure the availability, security, and integrity of data within the data warehouse environment.
• Provide guidance and support to the IT team and external vendors in data warehouse development and maintenance.
• Stay up-to-date with emerging trends and technologies in data warehousing.
• Continuously improve data warehouse processes and methodologies.
• Collaborate with cross-functional teams to resolve data-related issues.
• Manage relationships with data vendors and suppliers.

Requirements

• • Developed Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in MicroStrategy.
• • Developed various advanced interactive visualizations such as Heat map, Bubble chart, Tree map, and Line charts in MicroStrategy
• • 8 - 10 years of Database Design experience in Teradata.
• • SQL and Database experience with Teradata
• • Hands on experience in SQL, PL/SQL routines development
• • Telecom Domain knowledge.
• • Good communication skills (both written as well as oral). Communicates equally well with business people and technical team members.
• • Creating high level Common Semantic layer Architecture based on customer expectations. Review it with SMEs from client side and baseline the high-level model.
• • Owning the end to end Semantic modelling work
• • Analyze business requirements to determine the data elements needed in the Semantic Layer
• • Create necessary access layer objects for Facts, Dimensions to meet the business requirements
• • Should have good knowledge of Star Schema Design.
• • Must have good knowledge of OLAP queries, Aggregates, and usage of analytical functions in SQL queries
• • Interact with Business SMEs to understand required data elements, the business rules governing them and confirm definitions
• • Create, manage and modify conceptual, logical and physical data models for Semantic Layers. Present data models to business and technical audiences for review and validation
• • Apply views, indexes and tables as required to meet the defined performance service levels (SLAs) for application access of the data warehouse.
• • Resource should have good understanding in PL SQL.
• • Should be able to develop, test, debug and optimize the stored programs units.
• • He should understand telecom terminology.
• • He should have understanding of Teradata CLDM
• • Experience in team leading/ technical manager role.