Business Intelligence Developer, Office of Strategy Management and Institutional Research (7000101)

Reports to: Manager, Data Analytics and Business Intelligence

Purpose: A business intelligence architect is responsible for architecting data solutions that benefits the business. The job holder should promotes clarity and efficiency in using data to drive decision-making. 

Principal Accountabilities: 

  • Create high-level data solution design for Business Intelligence (BI) and Data Warehousing (DW) projects (conceptual model, source-to-target mapping) that align with the enterprise data strategy and translate business needs into long­term information architecture solutions
  • Support and facilitate workshops and interviews to elicit information needed to develop logical and physical data models
  • Develop and refine the enterprise data warehouse logical data model, including entities, attributes, and relationships. Develop and refine the enterprise data warehouse physical data model, including tables, columns, and relationships
  • Collaborate with the governance team to develop data dictionaries with agreed-upon definitions for all entities and attributes
  • Perform data profiling to identify and understand anomalies
  • Map logical/physical attributes/columns to existing software systems, identify gaps where data in existing systems do not exist to support the Target Data Architecture (TDA), and identify transformations where data must be altered from the source systems to be accommodated in the TDA. Conduct validation exercises to check data validity post transformation
  • Develop data quality cleansing rules for data elements within scope. Architect overall master data warehouse for data elements that are used by multiple information systems.
  • Analyze deficiencies in reporting capabilities and make improvements to the data model as necessary
  • Design ETL jobs to Extract data from source systems and load it into the data-warehouse model with reliable error/exception handling or rollback framework and continuously adapt the design according to business requirements
  • Perform the unit testing, system integration testing and assist with user acceptance testing
  • Document the ETL detailed design and test results
  • Develop systems and procedures to ensure the availability and reliability of the AUC’s BI environment
  • Handle software upgrades and installations
  • Develop data visualizations and other reports to support data-driven decision making and strategic planning


Minimum Education Requirement: Bachelor’s degree in computer science or any related field


  • Minimum 10 years of progressively responsible experience out of which four in a related field
  • Conceptual data modeling experience required
  • Logical data modeling experience (third normal form) required
  • Physical data modeling experience required
  • Prior work and familiarity with databases (preferably Oracle or SQL Server) required
  • Data analysis experience required


  • Outstanding communication and presence in front of senior level management required
  • Ability to communicate clearly in writing and verbally
  • Project planning capabilities
  • Management skills 

Position is open until September 2, 2018


Placement is based on the candidate’s experience and skills. Only candidates who make it to the short list will be contacted. If interested, please send an updated and detailed resume to, stating “7000101 Business Intelligence Developer” in the subject line.


“We thank all individuals who have expressed interest in working at The American University in Cairo.”