Position Summary:
Under the supervision of the Head, the Data Management Scientist will play a critical role in the efforts of Institutional Reporting and Data Governance (IRDG) in the Office of the President (OP) to build data integration and warehousing solutions to support analytical applications for institutional-wide reporting, data governance, and ultimately data informed executive decision-making at KAUST.
Major Responsibilities:
Data Repositories and Data Marts:
- Automate the compilation, merging, cleaning, manipulation, organization, and maintenance of data
- Write well documented (and backed up) programs/scripts/queries
- Create documentation (and/or training materials)
- Independently review, verify, reconcile, and update databases
Data Integrity:
- Conduct data validation, diagnostics, and cleaning exercises and audits
Implementation of Machine Learning:
- Develop automated internet and internal ERP crawling platforms
- Automate the capturing, consolidation, and extraction of relevant structured and unstructured data/information
Datamart Documentation:
- Documentation on the structure of databases, and the format which elements are maintained in those databases
- Create codebooks that describe contents of databases and descriptions of variables and codes (and transformations) within
- Produce mappings/cross-walks of various databases and/or tables
Other Activities/Duties:
- Automation of customized and/or extended tabular, graphical, and/or analytical reports
- Website development, applications, and analytics
- Provide technical training to facilitate organizational-wide informational needs
- Work closely with IT on technical issues surrounding: accounts, licenses, software acquisition/installation/updates, website/web applications, servers, databases, etc.
Competencies:
Required:
- Advanced Excel proficiencies
- Experience with collaboration and web content management applications (i.e., SharePoint, Google Docs, SmartSheet, etc.)
- Demonstrable experience with web forms and survey administration tools (i.e., Wufoo, FormStack, GoogleForms, SurveyMonkey, Qualtrics, etc.)
- Familiarity with storage and processing of big data (i.e., Hadoop, Cloud Dataflow, Big Query, Google Mesa, etc.)
- Familiarity with implementation and maintenance of ETL methodologies and solutions, business objects, query, and reporting functionalities in ERP systems (i.e., SAP, Hyperion, Oracle, Banner, PeopleSoft, etc.)
- Strong and demonstrable skills in the management and manipulation of large and complex relational databases (i.e., SAP HANA, SQL Server, Access, etc.)
- Technical expertise with database administration and various development, programming, and writing complex queries (SQL, NoSQL, .NET, VB, C/C++, Python, etc.)
- Programming expertise with web development frameworks, web-based service technologies, and web programming languages (Java, PHP, JavaScript, jQuery, Bootstrap, CSS, HTML5, XML, JSON, Ajax, etc.)
- Experience with Unix/Linux operating systems, shells, and tools such as grep, find, wget, awk, etc.
Preferred:
- Understanding of, and commitment to, KAUST’s vision, mission, and values
- Familiarity with KAUST databases and systems and deep understanding of linkages and dependencies across institutional student, faculty, research, financial, HR, and other data
- Demonstrable SAP business intelligence reporting tools and information builder experience (i.e., SAP Crystal Reports, SAP Business Explorer, SAP Lumira, etc.)
- Programming experience in SAP HANA XSA
- Experience designing, installing, and configuring new/existing Unix/Linux systems; Unix/Linux environment troubleshooting, remediation, etc.
- Experience in building self-updating real-time front end components using HTTP/REST API calls and the Websocket protocol
- Experience with statistical analysis software (i.e., Stata, R, SAS, etc.)
- Experience with mathematical open source packages (i.e., NumPy, SciPy, Pandas, etc.)
Qualifications:
Required:
Bachelor’s degree in an analytical field (i.e., Computer Science, Engineering, Mathematics, Business Analytics, Operations Research, Economics, Quantitative Social Science)
Preferred:
Master’s or PhD degree in an analytical field (i.e., Computer Science, Engineering, Mathematics, Business Analytics, Operations Research, Economics, Quantitative Social Science) from an accredited college or university
Experience:
Required:
At least five (7) years of related post-baccalaureate professional experience
Experience in a formal organizational setting focused on ERP systems, data warehouses, database management, programming, automation, machine learning, APIs, visualization, web applications, analytics
Preferred:
Experience in a university environment and/or setting
Experience in an institutional research, planning, information management, analytics, and/or similar office/function
Similar Positions
-
Senior Applied Research Scientist Knowledge Graphs And Generative Ai, SAP, Germany, 7 days ago
1 May 2024 Job Information Organisation/Company SAP Research Field Computer science Researcher Profile Recognised Researcher (R2) Country Germany Application Deadline 30 May 2024 - 00:00 (UTC) Typ...
-
Systems Administrator, University of Pittsburgh, United States, 1 day ago
Systems Administrator SCI-Office of the Dean - Pennsylvania-Pittsburgh - (24003134) The systems engineer position is responsible for provisioning and maintaining systems and associated infrastruct...
-
Informatics Operations Software Engineer, University of Colorado, United States, about 14 hours ago
Informatics Operations Software Engineer - 33532 University Staff Description University of Colorado Anschutz Medical Campus Colorado Center for Personalized Medicine Job Title: Informatics Opera...
-
Scientific Software Developer, CMCC Foundation, Italy, 8 days ago
29 Apr 2024 Job Information Organisation/Company CMCC Foundation Research Field Computer science Researcher Profile First Stage Researcher (R1) Recognised Researcher (R2) Country Italy Application...
-
System Administrator Of Linux Systems With Experience In Databases And Virtualization Clusters (Ref. Melis Psr Indf 2024 19), Universitat Pompeu Fabra, Spain, 12 days ago
25 Apr 2024 Job Information Organisation/Company Universitat Pompeu Fabra Department Department of Experimental and Health Sciences Research Field Computer science Researcher Profile First Stage R...
-
Sr. Software Engineer, Hbs Online, Harvard University, United States, about 9 hours ago
03-May-2024 Harvard Business School 65793BR Position Description Harvard Business School Online is Harvard Business School’s (HBS) vision of business education reimagined for the digital age. Our ...