System Analyst

QuickSilver IT Solutions LLC; Michigan; Hybrid; USD 80,000 - 120,000; Full time

Job summary

QuickSilver IT Solutions LLC in Michigan is seeking a System Analyst 6 to provide operational and technical support for an existing REDCap application hosted on AWS. The role involves maintenance, troubleshooting, version upgrades, and integration with internal/external systems.

You will collaborate with DTMB teams, Vanderbilt REDCap support, and security teams to ensure a secure, reliable REDCap environment with HIPAA audit logging.

Qualifications

• Bachelor's Degree in a relevant field is required.
• 5+ years of PHP Microservices development and MySQL experience.
• 5+ years of PHP configuration and troubleshooting.
• 5+ years of Python scripting for data loading and queries.
• 5+ years of RESTful API design/development and AWS hosting.

Responsibilities

• Support the REDCap application hosted in AWS with user/project management, reports and surveys.
• Coordinate REDCap updates and version upgrades with Vanderbilt University.
• Install and support REDCap External Modules using PHP on Linux/AWS (Apache/Nginx).
• Develop and troubleshoot REDCap APIs and automate data flows.
• Serve as the primary technical contact for REDCap-related issues.
• Ensure HIPAA compliance, audit logging, and security best practices.
• Coordinate with vendors, DBAs, security teams and business users.
• Prepare data loading scripts to REDCap databases via tools or APIs.

Skills

PHP Microservices development

MySQL database management

PHP configuration and troubleshooting

Python scripting for loading and query

RESTful APIs

AWS hosting and cloud infrastructure

Education

Bachelor's Degree

Tools

Azure DevOps

OIDC/SAML

Apache/Nginx

Job description

Our Direct Client in Michigan is looking for: System Analyst 6

Position ID 165735

W2 or C2C

-2-3 professional references are required. Please attach them in a separate document

-Interview Process: In-person and virtual interviews. 1st round is virtual, 2nd round is in-person. Mix of soft skill and technical skill interviews, looking for somebody with good communication and leadership skills. Interviews will involve the manager, business relationship manager, and potentially other members of the team.

-Assignment duration: Projected to be a 1 year+ contract dependent on business need

-Hybrid work schedule (non-negotiable): Position will be hybrid, in office 2 days a week upon start. Wednesdays and Thursdays are required on-site days and cannot be altered.

-local to Lansing, Michigan area (within 75 miles) at time of submission are preffered.

-Candidates must meet all these requirements from the beginning (non negotiable)

System Analyst 6 (REDCap Application Support)

Position Summary

The State of Michigan 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, DTMB infrastructure teams, AWS administrators, security teams, and Vanderbilt University 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 in collaboration with Vanderbilt University.
• 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 the scripts to load data to Redcap database using Data import tool or using 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 (PHP and SQL).
• Maintain MySQL databases, perform queries and 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 State 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 Public Health program stakeholders.

Top Required skills

• Five or more years of experience with PHP Microservices development with 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 query 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.

-Education: Bachelor's Degree Required

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 with 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 query 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 (EC2, S3, VPC, 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 experience.
• AWS Cloud Practitioner, SysOps Administrator, or Solutions Architect certification.
• Knowledge of HIPAA, security, and data privacy best practices.

Technical Skills

• PHP configuration and troubleshooting
• Amazon Web Services (AWS) Cloud services (EC2, S3, VPC, security groups)
• HTML, CSS, JS front-end coding