| Department: Dean, Optometry
| Salary: Commensurate with experience
| Description: Analyzes, develops and modifies application programs and ad-hoc programs, under moderate supervision. May provide support to enterprise systems.
1. Codes, tests, debugs, modifies and troubleshoots application programs and ad-hoc programs in accordance with shop standards.
2. Analyzes complex application processes and systems and their underlying data structures; identifies and resolves problems.
3. Installs, tests and troubleshoots vendor-supported applications.
4. Assists users with understanding, testing and using applications and programs, which includes running programs for users.
5. Documents data structures, run streams, applications, programs and other objects according to generally accepted practices.
6. Uses non-core technologies to design, code, test, debug, modify and troubleshoot systems, such as voice activated responses, electronic data interchange and web interfaces.
7. Learns new technologies and techniques. 8. Performs other job-related duties as assigned.
Basic qualifications
· (Preferably 3+ years) Experience in designing, implementing large scale Data Lake and Data Warehouse in the cloud
· Experience in using one or more query languages (e.g. SQL, HiveQL, SPARQL), schema definition languages (e.g. DDL, SDL, XSD, RDF), and scripting languages (e.g. Python, Scala) to build a data solution
· Understanding of distributed system concepts from storage and compute perspectives, including data persistence solutions (e.g. HDFS vs RDBMS), data integration techniques (e.g. ETL vs federation), database optimization (e.g. partitioning, distribution, indexing), and join algorithms (e.g. hash vs nested loop)
· Experience in CI/CD automation for a data lake using CDK (Cloud Development Kit) or Terraform
Preferred qualifications
· Experience in building data management platforms with AWS services such as Athena, Glue, Lake Formation, Step Functions, Lambda, S3, DynamoDB, Relational Database Service (RDS), Amazon EMR and Amazon Redshift
· Experience with healthcare data formats such as HL7/FHIR, genomics data, and medical imaging data
· Understanding of healthcare infrastructure and security requirements · Understanding of database and analytical technologies in the industry including MPP and NoSQL databases, Data Warehouse design, and BI Ops
ATTACHMENTS
Candidates interested in applying for the position must submit the following documents with the application:
· Cover letter describing the manner in which your experience applies to the posting.
· Resume
· Salary History (list Employer name, dates, and last salary)
· Three work references, including current and past supervisors. NOTE: We will maintain your confidentiality and notify you in advance of making contact with any of your references. References will be contacted only after the interviewing process has been completed.
Experience will be considered in lieu of education.
Education will be considered in lieu of experience.
MQ: Requires a thorough understanding of both theoretical and practical aspects of an analytical, technical or professional discipline; or the basic knowledge of more than one professional discipline. Knowledge of the discipline is normally obtained through a formal, directly job-related 4 year degree from a college or university or an equivalent in-depth specialized training program that is directly related to the type of work being performed. Requires a minimum of one (1) year of directly job-related experience.
| All positions at the University of Houston-System are security sensitive and will require a criminal history check. The University of Houston System and its universities are an Equal Opportunity Institution.