Data Analyst — Operational Insights & Dashboards

Shield HealthCare - Medical Supplies for Care at Home Since 1957; Santa Clarita (CA); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Medical, Dental, and Vision

401(k) with Company Match

Paid Time Off

Flexible Spending Account

Life & Disability Insurance

Education Assistance

Employee Referral Program

Job summary

Shield HealthCare in Valencia, CA is hiring a Data Analyst to support business operations by building advanced data models, dashboards, and reports. You will extract data from AS400/SQL, analyze large datasets, and partner with internal teams to improve cash collection, write-offs, and AR balances while communicating findings clearly to stakeholders.

The role requires strong analytical skills, advanced Excel proficiency, and the ability to manage multiple priorities with tight deadlines in an

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

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

Skills

Advanced Excel

Data analysis

SQL queries

Communication

Detail-oriented

Education

BS in Business/Finance/CS

Tools

AS400/SQL

Excel VBA

Microsoft 365

Job description

Shield HealthCare in Valencia, CA is hiring a Data Analyst to support business operations by building advanced data models, dashboards, and reports. You will extract data from AS400/SQL, analyze large datasets, and partner with internal teams to improve cash collection, write-offs, and AR balances while communicating findings clearly to stakeholders.

The role requires strong analytical skills, advanced Excel proficiency, and the ability to manage multiple priorities with tight deadlines in an