Freelance Excel Developer and Automation Specialist

Affinity Med Solutions

21h•$30 - $32•Remote

About The Position

We're looking for an exceptional Excel Developer & Automation Specialist to help streamline and automate business processes for a growing healthcare revenue cycle management company specializing in orthopedic medical billing. This is not a basic data entry or spreadsheet role. We're seeking someone who loves solving complex problems, building intelligent Excel solutions, and creating automation that saves hours of manual work.

Requirements

Expert-level Microsoft Excel skills.
Strong experience with VBA/macros and Excel automation.
Advanced knowledge of Power Query and Power Pivot.
Ability to work with large datasets and optimize workbook performance.
Excellent problem-solving skills and attention to detail.
Strong communication skills and the ability to explain technical concepts clearly.
Ability to work independently and meet deadlines.

Nice To Haves

Experience in healthcare, medical billing, revenue cycle management, or insurance is a significant advantage.
Familiarity with reporting, financial analysis, or operational dashboards.
Experience integrating Excel with other Microsoft 365 applications is a plus.

Responsibilities

Design and build advanced Excel workbooks from the ground up.
Create complex formulas using functions such as XLOOKUP, INDEX/MATCH, LET, LAMBDA, FILTER, SUMIFS, and dynamic arrays.
Develop dashboards, reports, and KPI trackers.
Automate repetitive tasks using VBA, Office Scripts, Power Query, and Power Pivot where appropriate.
Clean, transform, and organize large datasets.
Improve existing spreadsheets by making them faster, more efficient, and easier to use.
Collaborate directly with leadership to create custom business solutions.