Automation Specialist

Palmetto GBA•W@H South Carolina, SC

2d•Remote

About The Position

The Automation Specialist is responsible for identifying, developing, and implementing process improvements and automation solutions that enhance operational efficiency within the Audit Reimbursement Department. This role evaluates existing policies, procedures, and workflows to recommend improvements ranging from process optimization to complete procedural redesigns when necessary. The Automation Specialist collaborates with department stakeholders to streamline operations, reduce manual effort, improve accuracy, and support continuous improvement initiatives. Logistics: Palmetto GBA - one of BlueCross BlueShield's South Carolina subsidiary companies. Location: This is a full-time, 100% remote position (40 hours per week) Monday - Friday. Candidates may choose to work onsite at the South Carolina office if preferred. SCA Benefit Requirements: BlueCross BlueShield of South Carolina and its subsidiary companies have contracts with the federal government subject to the Service Contract Act (SCA). As a Service Contract Act (SCA) employee, you are required to enroll in our health insurance, even if you already have other health insurance. Until your enrollment is complete, you will receive supplemental pay for health coverage. Your coverage begins on the first day of the month following 28 days of full-time employment. Sponsorship: This position is not eligible for sponsorship now or in the future.

Requirements

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.
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, including the ability to express basic technical and business concepts to management, peers and the business units.
Good teamwork and interpersonal skills.
Good analytical and conceptual skills.
Fundamental understanding of user acceptance test plans and test matrices, project plans, and scope and design documents.
Working knowledge and understanding of how projects and implementations affect an organization and can effectively link it to business processes.
Working knowledge of mainframe electronic data processing system change methodology.
Knowledge of Microsoft Office applications.

Nice To Haves

Advanced proficiency in Microsoft Excel; expert knowledge of advanced formulas (e.g., VLOOKUP, INDEX/MATCH, array formulas), functions, 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 for automation and custom solutions.
Knowledge of Medicare Cost Reporting

Responsibilities

Evaluates the activities, performance and systems within a specific area for standards and workflow simplification.
Compiles data for analysis and prepares reports and presentations for management using applicable programming languages and/or software products.
Reviews system enhancements/upgrades to determine applicability of customer file modification requirements.
Facilitates timely and accurate updates to reference files based on customer requests.
Coordinates testing and debugging of new or modified software.
Creates test matrices and supporting documentation.
Develops and executes formal test plans to ensure delivery of quality software applications.
Monitors software implementations for exceptions and to verify that changes to the systems' operational process had the desired effect.
Identifies and documents systems problems and assists in their resolution.
Researches system problems and identifies potential solutions.
Investigates and diagnoses system problems, formulates solutions, initiates change sheets, defines business requirements, and tests corrections.
Researches any questionable standard system or local component problematic situations to assure compliance and accuracy.
Under general direction, defines business requirements, tests, and leads small to moderate projects.
Assists management in performing business reviews by analyzing internal/external projects and changes.
Ensures changes do not have a negative impact on productivity and procedures.
Makes recommendations to improve productivity, cost effectiveness and timeliness.
Communicates with management and departmental personnel to document workflow procedures.
Assists in preparing verbal and written communication about business changes with management or other staff members.
Prepares written reports and analyses pertaining to testing results and related data, including recommendations for customers on improving operational workflows.