System Analyst 6 - (REDCap Application Support)

Title: System Analyst 6 REDCap Application Support

Duration: 1 year+ contract, dependent on business need

Work: Hybrid

Location & Schedule: Lansing, Michigan.

Interview: In-person and virtual interviews. 1st round is virtual and 2nd round is in-person.

Location Requirement: Candidates must be local to the Lansing, Michigan area within 75 miles at the time of submission. This requirement is non-negotiable.

Job Description

Position Summary

The position is seeking an experienced PHP/MySQL developer with knowledge and skills in PHP Microservices development, MySQL database management, and cloud infrastructure and applications management to provide operational and technical support for an existing REDCap application hosted on Amazon Web Services (AWS). The resource will be responsible for the maintenance, troubleshooting, version upgrades, user support, vendor coordination, and integration of the REDCap application to ensure a secure, reliable, and highly available platform.

This position requires close collaboration with business stakeholders, infrastructure teams, AWS administrators, security teams, and REDCap support.

Key Responsibilities

• Support the REDCap application hosted in AWS with user/project management, reports, and surveys.
• Coordinate and implement REDCap software updates, patches, and version upgrades.
• Install, configure, and support REDCap External Modules using PHP on Linux/AWS environments including Apache/Nginx.
• Develop, maintain, and troubleshoot REDCap API integrations with internal and external applications and automate data flows.
• Serve as the primary technical contact for REDCap-related issues.
• Implement and maintain OIDC integration, Active Directory/LDAP, and SSL/TLS certificates.
• Prepare scripts to load data to the REDCap database using the Data Import Tool or REDCap APIs.
• Coordinate with AWS infrastructure teams regarding servers, storage, networking, SSL/TLS certificates, security groups, backups, and system monitoring.
• Provide day-to-day operational support, including troubleshooting application, infrastructure, and user issues, documentation, and training.
• Monitor application performance and proactively identify and resolve issues.
• Support disaster recovery, backup validation, and system recovery activities.
• Develop automation scripts for reporting and data validation using PHP and SQL.
• Maintain MySQL databases, perform queries, and conduct validation.
• Maintain technical documentation, standard operating procedures, and configuration documentation.
• Coordinate issue resolution with vendors, developers, database administrators, security teams, and business users.
• Participate in change management, release management, and production support activities.
• Ensure compliance with security standards, applicable data privacy requirements, HIPAA compliance, and proper audit logging.
• Create and maintain Azure DevOps work items for REDCap enhancements, defects, upgrades, API development, and maintenance activities.
• Maintain priorities, assignments, status, dependencies, and target completion dates.
• Monitor dashboards and reports to identify aging or overdue work.
• Provide status reporting to IT leadership and program stakeholders.

Required Education

• Bachelor s Degree

Top Required Skills

• Five or more years of experience with PHP Microservices development, configuration, and troubleshooting.
• Five or more years of experience with MySQL database management.
• Five or more years of experience with PHP configuration and troubleshooting.
• Five or more years of experience with Python scripting for loading and querying data.
• Five or more years of experience designing, developing, implementing, and troubleshooting RESTful APIs.
• Five or more years of experience supporting enterprise web applications hosted on AWS.

Top Preferred Skills

• Experience supporting REDCap in a public health, healthcare, higher education, or research environment.
• Experience with REDCap API integration and External Modules implementation.
• Experience with Twilio/SMS survey gateway.

Other Highly Desired Qualifications

• Five or more years of experience with PHP Microservices development, configuration, and troubleshooting.
• Five or more years of experience with MySQL database management.
• Five or more years of experience with PHP configuration and troubleshooting.
• Five or more years of experience with Python scripting for loading and querying data.
• Five or more years of experience designing, developing, implementing, and troubleshooting RESTful APIs.
• Five or more years of experience supporting enterprise web applications hosted on AWS.
• Experience using AWS Cloud services such as EC2, S3, VPC, and security groups.
• Experience with Apache or Nginx web servers.
• Experience with OIDC/SAML integration.
• Experience with SSL/TLS certificate management and HIPAA compliance.
• Experience managing application security, authentication, and user access.
• Experience coordinating software upgrades and vendor support.
• Experience with end-user support, documentation, and training.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent written and verbal communication skills.
• Experience supporting REDCap in a public health, healthcare, higher education, or research environment.
• Experience with REDCap API integration and External Modules implementation.
• Experience with Active Directory, LDAP, or Single Sign-On (SSO).
• Experience using ServiceNow or another enterprise ticketing system.
• Experience with DevOps or similar tools.
• Experience supporting API integrations with enterprise applications.
• Experience with Python scripting for automation.
• Experience with SSIS/SQL Server Agent.
• Experience with Twilio/SMS survey gateway.
• AWS Cloud Practitioner, SysOps Administrator, or Solutions Architect certification.
• Knowledge of HIPAA, security, and data privacy best practices.

Technical Skills

• PHP Microservices Development
• MySQL Database Management
• PHP Configuration and Troubleshooting
• RESTful APIs
• Amazon Web Services (AWS) Cloud Services EC2, S3, VPC, Security Groups
• Apache/Nginx Web Servers
• OIDC/SAML Integration
• Writing, Testing, and Debugging PHP
• Python Scripting
• HTML, CSS, and JavaScript Front-End Coding
• REDCap API Integration
• REDCap External Modules Implementation
• REDCap Administration User/Project Management, Reports, and Surveys
• SSL/TLS Certificate Management and HIPAA Compliance
• Identity and Access Management
• Application Monitoring
• Backup and Disaster Recovery
• Vendor Coordination
• Technical Documentation
• Analytical Problem-Solving and Troubleshooting
• Adept Learner

Deliverables

• Maintain a secure, stable, and available REDCap environment.
• Complete REDCap upgrades and patches according to vendor recommendations.
• Ensure successful operation of REDCap integrations, APIs, and External Modules.
• Develop automation scripts for reporting and data validation using PHP and SQL.
• Implement and maintain OIDC integration, Active Directory/LDAP, and SSL/TLS certificates.
• Maintain MySQL databases, perform queries, and conduct validation.
• Resolve production issues within established service levels.
• Support user onboarding, access management, and troubleshooting.
• Maintain system documentation and operational procedures.
• Provide knowledge transfer and operational documentation to staff.

Soft Skills

• Excellent customer service and communication skills.
• Ability to work independently with minimal supervision.
• Strong organizational and time management skills.
• Ability to manage multiple priorities simultaneously.
• Experience collaborating with cross-functional technical and business teams.

Primary Skills: PHP, PHP Microservices, MySQL, Python, RESTful APIs, AWS

Secondary Skills: REDCap, REDCap API, External Modules, Apache/Nginx, OIDC/SAML, LDAP/Active Directory, SSL/TLS, HIPAA, Azure DevOps, ServiceNow, HTML, CSS, JavaScript, Docker, Git/GitHub, Twilio