Associate Database Developer at University of California San Francisco (UCSF)

Roles and responsibilities:

Using Micrososft SQLServer, MySQL and PostgreSQL the incumbent will:

• Develop and implement ETL programs to load various databases on a continuous and ongoing basis into a master database for analysis
• Develop queries, views, indexed views and other database objects to facilitate querying, reporting, and analysis
• Design and develop dashboards, charts and reports using PowerBI and SSRS
• Manage and configure power BI and test new versions and releases of PowerBI
• Maintain data standards, including adherence to the Data Protection Act
• Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
• Write training guides and system implementation technical documents
• Work closely with IT project managers and system developers
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security
• Assist in the development of interfaces for interoperability to enable data syncing between databases
• Work with other members of the informatics team, in collaboration with the Senior Manager for Global Health Informatics in San Francisco
• Any other duties assigned related to this job description

Minimum Requirements:

• An appropriate degree in computer science, Information Technology or software engineering with an interest in database development or at least 2 years of demonstrable experience in database development
• Demonstrated experience in working with databases and SQL and developing database centric applications in one particular DMBS, either SQL Server or PostgreSQL including writing complex SQL queries
• Interest in business intelligence and using Power BI
• Certification in a popular DMBS is considered a major advantage
• Experience with one or more of the following domains are considered advantages:
  • (Bio)statistics
  • Monitoring and Evaluation
  • Epidemiology
  • HIV
  • Working in the health sector
  • Linux
  • GIT workflows

Additional Requirements:

• Must be willing to work occasionally during evening hours to participate in phone calls – such time may be compensated
• Some components of the job may be executed off-site, for example at a government entity
• The incumbent must be willing to liaise and collaborate with other staff, and train them in the design, development and maintenance of these databases and dashboards
• Willing to travel outside the office environment to remote areas of the country to training and implement systems developed.