Freelance Excel Developer and Automation Specialist
Affinity Med Solutions · Park Ridge, NJ · 1 mo ago
RemoteRemoteInformation TechnologyFull-time
Freelance, remote, project-based role with ongoing opportunities for an Excel Developer & Automation Specialist to streamline and automate business processes in healthcare revenue cycle management.
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.
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.
Preferred Qualifications
- Experience in healthcare, medical billing, revenue cycle management, or insurance.
- Familiarity with reporting, financial analysis, or operational dashboards.
- Experience integrating Excel with other Microsoft 365 applications.
What We're Looking For
We value someone who doesn’t just complete tasks—they improve processes. We want a creative thinker who can identify opportunities to automate workflows, reduce manual effort, and build tools that make our team more productive.
Schedule
- Freelance / Independent Contractor
- Remote
- Flexible hours
- Opportunity for ongoing projects based on performance