Database Analyst Programmer-Associate (On-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.
• 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.