Data Analyst
About this role
Since 1957, Shield Healthcare has provided high-quality healthcare services while focusing on customer satisfaction and employee achievement. We are dedicated to fulfilling the medical supply needs of consumers and the caregiving community while maintaining a 99% overall customer satisfaction rating. Over the years, Shield HealthCare has expanded nationally with current service locations in California, Colorado, Illinois, Ohio, Texas and Washington.
Shield HealthCare is looking for a Data Analyst in our Valencia, CA corporate office to support business operations through the development of advanced data driven models to collect, analyze, and report data into meaningful business reports to drive informed decision making and improve operational performance. This role utilizes software applications to create queries, analyze data sets, prepare reports and dashboards, and partners with internal teams to increase order review accuracy that will lead to an improvement of cash collection rates, write-offs and Accounts Receivable balance. This position requires strong analytical skills, advanced Excel proficiency, experience working with large data sets, and the ability to clearly communicate findings to business stakeholders.
This is an on-site position in Valencia, CA.
JOB RESPONSIBILITIES:
- Create and maintain advanced models (Excel or other application) with complex formulas and business rules
- Extract data utilizing queries from AS400 (or SQL) data management system
- Partner with internal departments to continuously improve operational performance and models
- Develop and prepare customized reports for both internal and external stakeholders, presenting findings in a clear and concise manner
- Prepare management reports that highlight operational results and trends
- Enhance order review accuracy to improve cash collection rate, reduce write-offs and Accounts Receivable balance
- Assist in the implementation of new software application solutions as needed
- Handle multiple priorities with aggressive deadlines and ensure appropriate follow-up and closure
- Support in the creation and preparation of company dashboards
- Complete special projects as assigned, supporting team and organizational objectives and continuous improvement initiatives
QUALIFICATIONS:
- BS in Business, Finance, Computer Science or equivalent combination of experience and education
- 3-5 years of experience in data analysis, reporting, and working with large data sets
- Proficiency in Microsoft 365 (Excel (Expert), Outlook, PowerPoint, Word, SharePoint, Teams)
- Advanced proficiency in Excel, including pivot tables, multi-layer IF statements, lookup formulas, VBA a plus
- Experience writing queries in AS400/SQL or similar
- Strong analytical and problem-solving skills
- Ability to work independently and maintain accountability
- Strong written and verbal communication abilities
- Strong organizational skills, with extreme attention to detail, with the ability to manage multiple priorities, respond to changing business needs, and meet critical deadlines
SALARY & BENEFITS:
- $70-90k annually
- Medical, Dental, and Vision
- 401(k) with Company Match
- Sick and Vacation Days
- Flexible Spending Account
- Life & Disability Insurance
- Education Assistance
- Employee Referral Program
Career-minded individuals will find our business challenging and our reputation for excellence just one of the rewards we have to offer. To further enhance this tradition of excellence, our employees participate in continuous training and development programs in a variety of disciplines.
The posted range for this position is $70-90k annually which is the expected starting base salary range for an employee who is new to the role to fully proficient in the role. Many factors go into determining employee pay withing the posted range including education, prior experience, training, current skills, certifications, location/labor market, internal equity, etc.
Shield Healthcare, Inc. is an Equal Employment Opportunity Employer and does not discriminate against applicants or employees on the basis of race, color, religion, creed, national origin, ancestry, disability that can be reasonably accommodated without undue hardship, sex, sexual orientation, gender identity, age, citizenship, marital or veteran status, or any other legally protected status.
Company at a glance
With 65 years of medical supply experience, Shield is a leading provider of incontinence, urological, enteral nutrition, advanced wound care, diabetes and ostomy supplies. Our mission is to serve the medical supply needs of patients at home with excellence, compassion and exceptional service.
We offer direct billing to Medi-Cal, Medicaid, Medicare and managed care plans. Shield HealthCare benefits include on-staff product experts, including Registered Dietitians and Lifestyle Specialists to support patients and their families.
Since 2007, Shield HealthCare has been granted formal accreditation status by the Community Health Accreditation Program's (CHAP) Board of Review. From our 2021 annual customer survey of more than 3,000 active customers conducted by Press Ganey Associates Inc., we are proud to say that 98% of our customers would recommend us to friends and family.
Shield HealthCare is firmly committed to community involvement, supporting a variety of health organizations and causes each year. We also advocate for and support our customers by:
- Engaging advocates for legislative support for home care benefits
- Participating in Medicare advisory groups in all regions
- Emphasizing compliance with insurance carrier regulations
- Taking leadership in state supplier associations
Dedicated to employee achievement, Shield HealthCare provides over 20,000 hours of ongoing employee training every year. We also support health care professionals and the caregiving community through educational in-services, nursing education days, webinars, educational materials, and more than 2,000 articles and videos featured in our vibrant, interactive online communities.
For more information on joining our team, visit www.shieldhealthcare.com/careers.
Top Benefits
- Medical
- Dental
- Vision
- 401(k) with Company Match
- Sick Days
- Vacation Days
- Flexible Spending Account
- Life Insurance
- Disability Insurance
- Education Assistance
- Employee Referral Program
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?