Excel Specialist

Started in 2016, FreedomCare is a Healthcare company that is innovating and revolutionizing the way home care is delivered.  We bring dignity and support to patients needing care in their homes and to the caregivers who care for them.  We’re the largest consumer-directed home care agency in NY State, and are continually expanding our areas of focus including operations in other states and tech-based innovations.  

We pride ourselves on our values which drive the level of care that we deliver to our patients:

• Here For You (An attitude of service, empathy, and availability)
• Own It (Drive and ownership)
• Do the Right Thing (High integrity)
• Be Positive (Great attitude and a can-do positive approach to challenges)

Join our team and make a positive impact on the lives of others! We are looking for an Authorizations Data Analyst II for our Finance team.

This is a remote position with potential travel into our main office in New York or the FreedomCare hub closest to you for meetings and/or collaboration.

Department & Position Overview:

The Authorizations Data Specialist II is a key member of the Finance department responsible for aiding the Authorizations team.  As an individual contributor, the Specialist helps to ensure the continuity of care for patients by creating a seamless process between visit creation, scheduling, and payroll processing for caregivers.  To accomplish this the Data Specialist will heavily support the teams’ reporting needs. 

This role primarily involves compiling and analyzing data to create detailed Excel reports, monitoring authorizations and timesheet accuracy, and supporting continuous process improvements to guarantee a seamless payroll experience for caregivers. The ideal candidate will have a strong attention to detail, expertise in Excel, ability to work effectively as a collaborator, and should possess an understanding of CDPAP or homecare services. 

Every Day You Will:

• Compile lists of case work to delegate to team for review whether that is for the continuations team, the pink visits team, errors and mismatches to correct, and the out of state team 
• Manage the “pink visits” squad within the authorization team which proactively corrects visits with authorization related issues in preparation for caregiver payroll processing 
• Organize issues for the team to review, proactively generate future reports to account for schedule/units issues and requests from plan with tracking and interdepartmental communication with coordinators to update schedules accordingly with a goal of no issues pre-payroll processing 
• Use Excel and data organizing skills to upload authorization data into our software 
• Aggregate authorizations data for imports and audits 
• Generate reports for “continuations team” so that they can effectively request continuations from contracts that we work with, with a goal of zero cases being placed on hold  
• Ensure data syncs between our two software and conduct regular audits ensuring accuracy 
• Serve as a PM/IT liaison and work with Developers to further optimize systems and processes finding automation and efficiencies where possible; address concerns and facilitate a smooth communication process 
• Prepare and present regular reports on audit findings, trends, and performance metrics to management, offering insights and recommendations to enhance operational efficiency 
• Work internally with the Finance teams like the collections team/payroll resolution teams to help correct or avoid payroll or care continuation issues 
• As FreedomCare grows and expands, create new state processes that are appropriate and compliant with each state and their requirements and systems 
• Provide ongoing Excel training and support to other Authorization specialists or Team Leads as needed 
• Other project work and duties as assigned 

Ideal Candidate Will Possess:

• Bachelor’s degree and 2-4 years of related experience strongly preferred 
• Must have prior data reporting experience and advanced Excel skills included but not limited to, Vlookup/Index/Xlookup, pivot tables, concat, if statements, macros, countifs, sumifs, conditional formatting. 
• As an SME on the team with data and Excel processes, the Authorization Data Specialist should be a skilled specialist with solid working proficiency and must possess a strong analytical mindset and problem-solving skills 
• Ability to work cross-functionally with members of other teams such as Developers to create continued automation as well as internally with Team Leads to improve processes and produce 
• Must have high regard for accuracy and attention-to-detail to avoid issues that create payroll disruption for caregivers or delays in care 
• Displays solid business acumen by understanding the role and impact of the Authorizations department and follows all SOPs, practices, and guidance given 
• Must be able to operate independently to some degree with occasional or limited oversight and direction  
• As a skilled specialist, completes task in resourceful and effective ways and can evaluate and select strong solutions for the team 
• Must have an excellent ability to establish and maintain harmonious relations with internal and external customers by being courteous and helpful, showing appreciation and respect for others’ needs, expectations and perspectives. 
• Flexible and adaptable to change and working on a large scope or volume of work 
• Should be a strong and effective communicator both in writing and verbally to convey and receive information inter- and intra-departmentally 

Why work at FreedomCare?

We are here for you and committed to providing a best-in-class employee experience. We offer competitive compensation, medical benefits, retirement plans, wellness programs, fun company events and ongoing learning opportunities to grow your career.

This is a place where your voice matters, where we build great relationships, and your work has meaning and a tangible positive impact on others!

At FreedomCare, we celebrate diversity and are committed to creating an inclusive environment for all employees. We are an Equal Opportunity Employer and do not discriminate based upon race, religion, color, national origin, ancestry, age, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, status as a protected veteran, status as an individual with a disability, citizenship or immigration status, or other applicable legally protected characteristics.

At FreedomCare, base pay is one part of our total compensation package and is determined within a range. This provides our employees with the opportunity to professionally grow and develop within a role. The base pay range for this role is between $20.00 and $26.00 an hour at the commencement of your first year of employment. Compensation decisions are dependent upon a variety of factors which may include, but are not limited to: skill set, years of relevant experience, education, location, and licensure/certifications.