Our client, a healthcare consulting firm, is seeking a Billing and Reporting Specialist for a direct hire role in Milton, GA. This is a fully onsite role, we are seeking local candidates only at this time.

The Billing and Reporting Analyst will be responsible for managing all aspects of billing, reporting, and reconciliation related to pharmacy and medical claims. The ideal candidate should possess strong Excel skills to manage weekly billing and invoicing processes, will be a proactive problem-solver, task-oriented, and capable of presenting data to clients in a clear and concise manner.

Duties and Responsibilities:

Billing and Reconciliation:

• Perform weekly audit processes to ensure billing accuracy and identify discrepancies.
• Execute weekly billing processes for pharmacy and medical claims, ensuring timely and correct invoicing.
• Conduct weekly reconciliations of Accounts Receivable and Accounts Payable to ensure consistency and accuracy.

Reporting and Data Management:

• Generate and deliver monthly reporting requirements for both pharmacy and medical divisions, ensuring all necessary details are captured.
• Manage monthly data transfers to third-party vendors, including pulling monthly claim files and verifying National Drug Code (NDC) code accuracy.
• Utilize Brokerage Builder to run pre-built reports and learn to leverage the system for client outreach and weekly invoicing.
• Develop and present monthly reports to clients, focusing primarily on pharmacy claims with some medical claims included as needed.

Data Analysis and Client Interaction:

• Use advanced Excel skills, including pivot tables and complex formulas, to analyze and compare data from multiple sources, ensuring accuracy and integrity of the reports.
• Use pivot tables, complex formulas, and comparisons across multiple Excel files to analyze medical and pharmacy claims data.
• Learn the systems and processes used for billing and reporting, adapting to new tools and workflows.
• Provide analytical support, conduct research, and solve problems to address client inquiries, resolve billing discrepancies, and ensure satisfaction.

Required Skills and Qualifications:

• Excellent communication skills, both written and verbal.
• Analytical with strong problem-solving skills.
• Strong time management, organizational skills and attention to detail.
• Comfortable working in fast paced environments.
• Adaptability and flexibility.
• Willingness and ability to learn about company’s products, services, and processes.
• Coachable with a willingness to learn and a desire to succeed.
• Process oriented, with a focus on continuous improvement.
• Self-Motivated.
• Strong data input skills.

Job Experience Preferences:

• A degree is preferred, but relevant and measurable experience will also be considered.
• 2 to 5 years of relevant experience.
• Previous experience in pharmacy or medical back-office operations, with a strong understanding of related terminology and pharmacy fulfillment processes.
• Strong Excel proficiency, specializing in complex formula development, in-depth pivot table analysis, and large-scale data manipulation.
• Ability to quickly learn and adapt to proprietary systems, such as Brokerage Builder.

Salary: $50,000 to $55,000 per year.