SQL Database front-end/full stack design for health program
Budget: $25 – $50 USD
This is State -funded project that aims to increase the number of providers and infrastructure to provide services to patients across the state. The candidate will work primarily with the program evaluator and the implementation team on setting a platform to evaluate program activities and test the impact of the program in preparation of reporting to the sponsor and oversight bodies.
The Database Developer/Specialist will support the development and maintaining of database with interactive web-based data entry and reporting capabilities, to be used by clinicians in remote locations who submit required clinical program data to the central program site.
Front to back activities include:
• Creating databases, including designing, building, and updating database structure (e.g., MS SQL, mySQL), study-related instruments and user interface for remote data collection and reporting (front-end/full-stack design, e.g., JavaScript, React.JS and Next.JS, Tableau).
• Working with users and evaluators to identify/interpret business rules, needs, and specification, to develop proper and efficient data solutions.
• Managing, integrating, and validating data from clinical sites, to ensure data quality, consistency, and security, as well as protection of participants’ confidentiality.
• Developing database documentation.
• Proactively conducting performance testing and creating queries to import, manipulate and extract data from databases, included basic analyses to assure clean data quality and integrity.
• Creating systems for tracking and record keeping for all study-related data received from sites (e.g., recruitment, clinical services provided to patients, retention).
• Supporting the development of study protocols and operations manuals for onboarding for new staff in remote clinical sites on how to interact with data systems.
• Adapt system to data needs by clinical sites, to help implement performance metrics and quality improvement action plans for clinical sites if program targets are not met.
• Tracking and coordinating elements of the evaluation program to assess impact of any proposed changes on the data collection systems.
• Build systems to prepare reports (quarterly, annual, ad hoc outcomes, processes, financial reports) to funders and stakeholders, as well as on local metrics for sites (e.g., dashboards).
• Diagnosing and solving system problems, including making recommendations on software, infrastructure, and database systems improvements.
• Handling platform security for users, including permissions, roles, and definitions.
• Participating in implementation team meetings
This summary describes the general level of work being performed front to back, but is not anticipated all will be done all together. The duties may change from time to time and/or based on business need. We reserve the right to add or delete duties and responsibilities at the discretion of the hiring authority.
Qualifications:
• Graduation from an accredited college or university with a bachelor’s or master's degree in healthcare administration, system/business administration, information technology, statistics, public health, nursing, social sciences or related.
• 2 ys experience in database design development, administration, management and reporting
• Knowledge of relational database concepts, theory, and design
• Experience with structured query language (MySQL, MS SQL, PostgreSQL) or data warehousing tools
• Experience with full stack development frameworks (e.g React.js, Next.js, and Node.js)
• Experience with BI/data visualization /analytics platforms (e.g Tableau) build reports and dashboards
• Experience with Data collection (e.g REDCap) a plus
• Familiarity working with clinical data, EMR/EHR in an academic health research environment a plus
• Experience with statistical tools (e.g SAS, R, SPSS) a plus
The Database Developer/Specialist will support the development and maintaining of database with interactive web-based data entry and reporting capabilities, to be used by clinicians in remote locations who submit required clinical program data to the central program site.
Front to back activities include:
• Creating databases, including designing, building, and updating database structure (e.g., MS SQL, mySQL), study-related instruments and user interface for remote data collection and reporting (front-end/full-stack design, e.g., JavaScript, React.JS and Next.JS, Tableau).
• Working with users and evaluators to identify/interpret business rules, needs, and specification, to develop proper and efficient data solutions.
• Managing, integrating, and validating data from clinical sites, to ensure data quality, consistency, and security, as well as protection of participants’ confidentiality.
• Developing database documentation.
• Proactively conducting performance testing and creating queries to import, manipulate and extract data from databases, included basic analyses to assure clean data quality and integrity.
• Creating systems for tracking and record keeping for all study-related data received from sites (e.g., recruitment, clinical services provided to patients, retention).
• Supporting the development of study protocols and operations manuals for onboarding for new staff in remote clinical sites on how to interact with data systems.
• Adapt system to data needs by clinical sites, to help implement performance metrics and quality improvement action plans for clinical sites if program targets are not met.
• Tracking and coordinating elements of the evaluation program to assess impact of any proposed changes on the data collection systems.
• Build systems to prepare reports (quarterly, annual, ad hoc outcomes, processes, financial reports) to funders and stakeholders, as well as on local metrics for sites (e.g., dashboards).
• Diagnosing and solving system problems, including making recommendations on software, infrastructure, and database systems improvements.
• Handling platform security for users, including permissions, roles, and definitions.
• Participating in implementation team meetings
This summary describes the general level of work being performed front to back, but is not anticipated all will be done all together. The duties may change from time to time and/or based on business need. We reserve the right to add or delete duties and responsibilities at the discretion of the hiring authority.
Qualifications:
• Graduation from an accredited college or university with a bachelor’s or master's degree in healthcare administration, system/business administration, information technology, statistics, public health, nursing, social sciences or related.
• 2 ys experience in database design development, administration, management and reporting
• Knowledge of relational database concepts, theory, and design
• Experience with structured query language (MySQL, MS SQL, PostgreSQL) or data warehousing tools
• Experience with full stack development frameworks (e.g React.js, Next.js, and Node.js)
• Experience with BI/data visualization /analytics platforms (e.g Tableau) build reports and dashboards
• Experience with Data collection (e.g REDCap) a plus
• Familiarity working with clinical data, EMR/EHR in an academic health research environment a plus
• Experience with statistical tools (e.g SAS, R, SPSS) a plus