Automation Specialist

Position Purpose

The Automation Specialist is responsible for identifying, developing, and implementing process improvements and automation solutions that enhance operational efficiency within the Audit Reimbursement Department. The role evaluates existing policies, procedures, and workflows to recommend improvements ranging from process optimization to complete procedural redesigns when necessary, streamlining operations, reducing manual effort, improving accuracy, and supporting continuous improvement initiatives.

• Evaluate activities, performance and systems within a specific area for standards and workflow simplification.
• Compile data for analysis and prepare reports and presentations for management using applicable programming languages and software products.
• Review system enhancements/upgrades to determine applicability of customer file modification requirements.
• Facilitate timely and accurate updates to reference files based on customer requests.
• Coordinate testing and debugging of new or modified software, creating test matrices and supporting documentation.
• Develop and execute formal test plans to ensure delivery of quality software applications.
• Monitor software implementations for exceptions and verify that changes to the systems’ operational process had the desired effect.
• Identify and document systems problems and assist in their resolution.
• Research system problems and identify potential solutions, investigating and diagnosing issues, formulating solutions, initiating change sheets, defining business requirements, and testing corrections.
• Research any questionable standard system or local component problematic situations to assure compliance and accuracy.
• Under general direction, define business requirements, test, and lead small to moderate projects.
• Assist management in performing business reviews by analyzing internal/external projects and changes.
• Ensure changes do not negatively impact productivity and procedures.
• Make recommendations to improve productivity, cost‑effectiveness and timeliness.
• Communicate with management and departmental personnel to document workflow procedures and assist in preparing verbal and written communication about business changes.
• Prepare written reports and analyses pertaining to testing results and related data, including recommendations for customers on improving operational workflows.

• Bachelor’s degree OR four (4) years of job‑related business experience OR Associate’s degree AND two (2) years of job‑related work experience.
• Minimum of two (2) years of job‑related business systems analysis, research and/or customer support experience.
• Working knowledge of business support and systems concepts.
• Ability to communicate effectively with technical and non‑technical audiences.
• Good teamwork and interpersonal skills.
• Good analytical and conceptual skills.
• Fundamental understanding of user acceptance test plans and test matrices, project plans, scope and design documents.
• Working knowledge and understanding of how projects and implementations affect an organization and can link them to business processes.
• Working knowledge of mainframe electronic data processing system change methodology.
• Knowledge of Microsoft Office applications.

• Advanced proficiency in Microsoft Excel, including advanced formulas (VLOOKUP, INDEX/MATCH, array formulas), pivot tables and data visualization tools.
• Proven experience in VBA scripting and Excel macro development; ability to write clean, efficient, and well‑documented VBA code.
• Knowledge of Medicare Cost Reporting.

• Position:
  Full‑time, 100% remote (40 hours per week). Onsite work at the South Carolina office is optional.
• Location:
  
  Palmetto GBA – a subsidiary of Blue Cross Blue Shield of South Carolina.
• Position is not eligible for sponsorship now or in the future.

As a Service Contract Act (SCA) employee, you are required to enroll in the company health insurance even if you already have other coverage. Until enrollment is complete, you will receive supplemental pay for health coverage. Coverage begins on the first day of the month following 28 days of…