Data Architect
Dexef -
Maadi, CairoPosted 4 years ago14Applicants for1 open position
- 10Viewed
- 0In Consideration
- 2Not Selected
Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Under general guidance, provides for the maintenance, development, enhancement, and overall performance and function of the data warehouse environment.
- Responsible for quality control and auditing of data marts. Develops data workhouse backup and recovery strategies.
- Provides technical assistance in trouble-shooting and debugging routine data warehouse related problems
- Translates business needs into long-term architecture solutions. Defines, designs, and builds moderately complex dimensional databases and identifies/defines additional attributes. Evaluates the reusability of current data dimensions for additional uses and analyses.
- Develops data mappings, data extractions, data transformations that support the agency’s data warehouse environment. Confers with end-users to ensure alignment between the data warehouse environment and user needs.
- Plans and oversees the technical transitions between development, testing, and production phases of data warehouse deployment. Facilitates change control and problem management among data warehouse development and support teams.
- Recommends potential improvements to the data warehouse environment to include data from all functions of the organization using data manipulation, transformations, and cleansing tools.
- Recommends and analyzes specifications for end-users semantic layers and multi-dimensional models across all Business Intelligence tools and environments to meet user needs.
- Troubleshoots and tunes existing moderately complex data warehouse environments to maintain optimum performance. Conducts research to determine the viability of new data warehouse applications and/or additional attributes. Recommends changes in data warehouse software environment.
- Coordinates the efforts of consultant development support to efficiently deliver data warehouse solutions. Enforces processes to ensure a consistent, well designed, and integrated data warehouse environment.
- Supports the design of the data and technical architecture for the data warehouse environment to ensure that the designs maintain an enterprise model, as requested.
Job Requirements
Knowledge Of:
- Database design considerations that support the data warehouse deployed methodologies.
- Data warehouse design method and techniques.
- Informatica PowerCenter, PL-SQL, Unix, Vi editor, shell scripting, and Toad.
- Data modeling using ERWIN, data warehouse development, database structure and implementation techniques, table, and index management, SQL tuning for Oracle.
- Any combination of education and experience equivalent to a bachelor’s degree in information systems or related field with a minimum of three years of complex analysis in data warehousing and programming or system administration.
Featured Jobs
Similar Jobs
- Senior Data Warehousing & Busi...The Micro, Small & Medium Enterprise Development Agency - Dokki, Giza2 days ago