Browse Jobs
For Employers
Post JobLog inGet Started

Data Architect

Dexef
Maadi, Cairo
Posted 4 years ago
14Applicants for1 open position
  • 10Viewed
  • 0In Consideration
  • 2Not Selected
Search other opportunities

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

Search other opportunities
JobsInstallation/Maintenance/RepairData Architect