Reports to: Senior Director, Business Intelligence
Purpose: The job holder is responsible for architecting data solutions that benefits the business. A Business Intelligence (BI) architect promotes clarity and efficiency in using data to drive decision-making.
Responsibilities:
- Analyze data to uncover hidden patterns and insights through data mining, machine learning, operations research and statistical analysis
- Develop data visualizations and other reports to support data-driven decision making and strategic planning
- Creates high-level data solution design for 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
- Work on deep data mining exercises to uncover hidden data insights
- 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 extract, transform and load (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
- Develops systems and procedures to ensure the availability and reliability of The American University in Cairo’s (AUC) BI environment
- Handle software upgrades and installations
- Perform other related duties as requested by direct supervisor
Requirements:
Minimum Education Requirements:
- Bachelor’s degree in computer science or any related field
Experience:
- A minimum of 10 years of experience out of which 4 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 required, preferably Oracle or SQL Server
- Data analysis experience required
- Previous experience with IBM Data Stage, IBM Cognos, SAP SAC, SAP BW is a plus
- Previous experience with Big Data Ingestion and Analysis solutions is a plus
- Python and R experience is a plus
Skills:
- Outstanding communication and presence in front of senior level management required
- Ability to communicate clearly in writing and verbally
- Project planning capabilities
- Management skills
This position is open until November 15, 2022
Placement is based on the candidate’s experience and skills. Only candidates who make it to the short list will be contacted.
"The American University in Cairo is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Individuals with disabilities are encouraged to apply."
“We thank all individuals who have expressed interest in working at The American University in Cairo.”
Similar Positions
-
Head Data System Architect , Delft University of Technology, Netherlands, 1 day ago
Designing the nation-wide data infrastructure with which the Netherlands will create eXtra Resilient (XR), sustainable, and climate-adaptive crops by adopting a smart data approach. We are searchi...
-
Machine Learning Data Engineer, Digital, Data, & Design Institute, Harvard University, United States, 17 days ago
08-Mar-2024 Harvard Business School 65263BR Position Description The ML Data Engineer will be a key member of the D^3 operations team responsible for proper management of cloud infrastructure to e...
-
Applied Machine Learning Scientist Iii, Teladoc Health, Spain, 15 days ago
13 Mar 2024 Job Information Organisation/Company Teladoc Health Research Field Computer science Researcher Profile Recognised Researcher (R2) Country Spain Application Deadline 11 Apr 2024 - 00:00...
-
Senior Systems Analyst, University of Pittsburgh, United States, about 21 hours ago
Senior Systems Analyst Office of the Registrar - Pennsylvania-Pittsburgh - (24001710) The Office of the University Registrar is an office focused on providing the highest levels of student, facult...
-
Solutions Architect (Smartsheet), SAIT Polytechnic, Canada, about 7 hours ago
Solutions Architect (Smartsheet) Calgary, AB Academic – Centre of Applied Education Innovation / APT Permanent Salary / Hybrid Apply for this job SAIT’s Centre for Applied Education Innovation (CA...
-
It Business Analyst, Harvard University, United States, 24 days ago
29-Feb-2024 Harvard Business School 65188BR Position Description Are you excited by the idea of joining a world-class organization at the intersection of higher education and technology? Are you d...