System Analyst – REDCap Application Support

AllianceIT Inc; Lansing (MI); Hybrid; USD 90,000 - 120,000; Full time

Job summary

AllianceIT Inc. seeks an experienced System Analyst 6 to support a REDCap application on AWS. The role focuses on PHP/MySQL maintenance, API integrations, and operational support to ensure a secure, reliable platform.

You'll collaborate with AWS admins, security teams, and business stakeholders, handle upgrades, scripting in PHP/Python, and monitor performance in a hybrid on-site schedule in Lansing, MI.

Qualifications

• Bachelor’s Degree required.
• 5+ years of PHP Microservices development experience.
• 5+ years of MySQL database management experience.
• 5+ years of PHP configuration and troubleshooting.
• 5+ years of Python scripting for data loading and querying.
• 5+ years of RESTful API design and integration.
• 5+ years of experience supporting enterprise web apps on AWS.

Responsibilities

• Support REDCap on AWS with user/project management, reports, and surveys.
• Coordinate and implement REDCap updates, patches, and version upgrades.
• Install, configure, and support REDCap External Modules on Linux/AWS (Apache/Nginx).
• Develop and troubleshoot REDCap API integrations and data flows.
• Serve as primary technical contact for REDCap issues.
• Maintain OIDC, AD/LDAP, and SSL/TLS certificates.
• Prepare data load scripts using REDCap tools and APIs.
• Coordinate with AWS teams on servers, storage, networking, security, backups, monitoring.
• Provide day-to-day operational support and user documentation.

Skills

PHP Microservices

MySQL

PHP Configuration

Python scripting

RESTful APIs

AWS

Education

Bachelor's Degree

Tools

Linux

Apache

Nginx

Azure DevOps

Job description

System Analyst 6 – REDCap Application Support

Duration: 1 year+ contract

Work: Hybrid — No remote

Location & Schedule: Lansing, Michigan. In-office 2 days a week upon start. Wednesdays and Thursdays are required onsite days and cannot be altered.

Interview: In-person and virtual. 1st round is virtual and 2nd round is in-person. Interviews will include a mix of soft-skill and technical-skill questions, with a focus on communication and leadership skills.

Location Requirement: Candidates must be local to the Lansing, Michigan area within 75 miles at the time of submission.

Resume: Resumes are kept to 4–5 pages.

References: 2–3 professional references are required and should be attached in a separate document.

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

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

Primary Skills: PHP Microservices, MySQL, PHP Configuration & Troubleshooting, Python, RESTful APIs, AWS