Assist with designing, implementing, and maintaining databases in a server environment.
Write, test, and debug stored procedures and queries; map data and maintain database integrations.
Work with teams to define data requirements and create standardized data models, validation logic, and quality-control processes.
Build and maintain reports and dashboards from research data, and track study metrics such as recruitment, retention, attrition, and participant characteristics.
Summarised from the posting by AI and can be wrong. The full description is the source.
Requirements
Experience
Internship or volunteer experience with specific coding experience (preferred)
2 or more years of experience with databases, spreadsheets, data management, data analysis, or related information systems (preferred)
Experience with regulatory-grade data (preferred)
Experience with ERP, CRM, eCRF, EMR, or similar clinical/research data systems (preferred)
Education
Bachelor’s degree in computer science, information systems, data analytics, or a related field
Skills
Fundamental knowledge of common database operations
Proficiency with Microsoft Excel, including charts, pivot tables, macros, and data functions
Proficiency in relevant database software and tools
Strong analytical skills
Full job description
From UT Health San Antonio Staff Positions’ careers site
The Database Analyst Programmer-Associate will support data-driven clinical research at the Glenn Biggs Institute for Alzheimer’s and Neurodegenerative Diseases. Working with cross-site research and operational teams, this role will help translate study needs into reliable data systems, standardized data collection processes, quality-control tools, and meaningful reports. The incumbent will contribute to integrating and analyzing research data that help study teams monitor recruitment, retention, participant populations, and overall progress toward study goals.
Assists in the design, implementation, and maintenance of new and existing databases in a server environment.
Show full descriptionShow less
Designs, writes, tests, and debugs database stored procedures and simple queries to extract, calculate or manipulate information.
Assists in creating database mappings to transform data from multiple systems developing and maintaining integrations between database systems.
Works with departments to understand data collection, storage, and reporting needs for new systems.
Assists cross-site research and operational stakeholders with defining business and data requirements, translating operational needs into standardized data models, validation logic, and quality-control processes.
Builds and maintains reports and dashboards using data from multiple research sources; assists with querying, integrating, and validating datasets and tracking key study metrics, including recruitment, retention, attrition, and participant population characteristics.
Performs all other duties as assigned.
Fundamental knowledge in common database operations.
Proficiency with Microsoft Excel along with a solid understanding of charts and pivot tables, macros and data functions.
Proficiency in relevant database software and tools.
Strong analytical skills to resolve complex issues.
Strong verbal, written and interpersonal communication skills.
Education:
Bachelors degree in a computer science, information systems, data analytics, or a related field is required.
Experience:
None required.
Internship and volunteer roles with specific coding experience is preferred.
2 or more years of experience working with databases, spreadsheets, data management, data analysis, or related information systems is preferred.
Experience with regulatory grade data is preferred.
Preferred - Technical Skills:
Analytics & Business Intelligence: Power BI, Tableau, SQL, Python, Excel.
Data & Modeling: PostgreSQL, data modeling, ETL/ELT, Databricks.
Systems & Development: REDCap, Airflow, Git/GitHub, API integration, Docker, Flask.
Experience with enterprise resource planning (ERP), customer relationship management (CRM), electronic case report form (eCRF), electronic medical record (EMR), or similar clinical/research data systems.