[Hiring] Production Ops System Analyst @Matrix Medical Network

Role Description

The Production Operations Systems Analyst supports the stability, functionality, and continuous improvement of operational tools and data systems that drive production performance. This role serves as the primary Tier 2 support resource for internal production, membership, and CSD-related systems, ensuring issues are resolved efficiently and root causes are identified.

In addition to day-to-day support, this role contributes to automation initiatives, system enhancements, and ongoing maintenance of internally developed tools, including Excel/VBA-based applications and SQL-backed systems. The ideal candidate is technically strong, highly analytical, and comfortable working across a wide range of both proprietary and third-party software solutions.

Responsibilities

• Tier 2 Systems & Application Support
  • Serve as Tier 2 support for production and membership-related systems, troubleshooting escalated issues and identifying root causes.
  • Investigate and resolve data discrepancies, system errors, and workflow interruptions impacting operational teams.
  • Write and execute SQL queries to research issues, validate data, and support resolution efforts.
  • Partner with IT when deeper infrastructure or system-level intervention is required.
  • Document recurring issues and contribute to knowledge base and process documentation.
  • Monitor system performance and proactively identify areas of risk or inefficiency.
  • Configure and maintain data across a wide range of systems.
• Projects & Automation
  • Support automation initiatives to streamline reporting, workflows, and operational processes.
  • Develop and enhance Excel-based tools using advanced formulas, VBA, and macros tied to SQL back-end databases.
  • Assist in improving reporting capabilities through query optimization and process automation.
  • Participate in system enhancements and cross-functional operational projects.
  • Identify opportunities to reduce manual processes and improve scalability.
• Internal Tool Maintenance & Optimization
  • Maintain and support internally developed tools, including Excel/VBA interfaces and web-based applications built on .NET frameworks.
  • Perform routine system checks, updates, and enhancements to ensure stability and usability.
  • Support front-end interface updates (C#, CSS, HTML) in partnership with IT as needed.
  • Assist with basic database administration tasks, including data validation, stored procedure review, and environment support.
  • Support light system administration activities such as application configurations and web server coordination, as needed.

Qualifications

• Bachelor’s degree preferred (Information Systems, Business, Data Analytics, or related field); equivalent work experience will be considered.
• 2–5 years of experience in systems support, data operations, production support, or application support roles.
• Experience supporting operational teams in a fast-paced environment.
• Exposure to internal tools, proprietary systems, or multi-platform software environments.
• Advanced Microsoft Excel skills, including complex formulas, pivot tables, and VBA/macros.
• Working knowledge of SQL Server and ability to write intermediate-level queries.
• Understanding of database structures and data validation practices.
• Proficiency in Microsoft Office 365.
• Experience supporting or maintaining Excel front-end applications tied to SQL back-end databases (preferred).
• Familiarity with .NET framework applications (C#, HTML, CSS) (preferred).
• Experience with Tableau or similar BI tools (preferred).
• Basic understanding of web server configurations or light systems administration (preferred).
• Strong analytical and troubleshooting skills.
• Ability to translate business problems into system-based solutions.
• Detail-oriented with a strong focus on data integrity.
• Ability to manage multiple priorities in a production-driven environment.
• Strong cross-functional communication skills.
• Quick learner with the ability to adapt to new software platforms and proprietary systems.
• Continuous improvement mindset.

Benefits

• Medical, Dental, Vision.
• Paid time off.
• Paid holidays.
• 401K with company matching.
• Voluntary life insurance.
• Short term disability.
• Long term disability.
• Employee assistance program.
• Health savings account.
• Flexible spending accounts.
• Additional voluntary benefits available.