CTSI Research Database Programmer
Core
Design and implement database Extract-Transform-Load (ETL) procedures, data transfers, and automated reporting schemes for research-focused application systems.
Role type
Database Programmer / ETL Developer
Builds
Research data pipelines, reporting schemes, and database management solutions for clinical and translational science projects.
Domain
Healthcare / Biomedical Research
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL query development, ETL procedure design, database system administration, data flow analysis, software testing plan implementation, automated reporting creation, data conversion, multi-platform SQL development (Oracle, SQLServer, Postgres)
Preferred skills
Healthcare/biomedical research operations experience, database performance profiling, index creation, agile software development, Git version control
Technologies
Oracle, SQLServer, Postgres, Epic, Git
Responsibilities
Design and implement database ETL procedures and jobs; oversee database design, development, management, and reporting for large projects; implement complicated queries and create automated reporting schemes; perform data transfers and conversions; troubleshoot software and hardware issues; create and maintain user manuals and documentation; design software testing plans.
Seniority
Mid-level, hands-on IC