> Markdown version of [/jobs/ext/2558634-data-analyst](https://www.wearedevelopers.com/jobs/ext/2558634-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Shield HealthCare - **Location:** Santa Clarita, CA, United States - **Experience:** Experienced - **Salary:** $70,000.0 - $90,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Word, Microsoft Excel, Microsoft Windows, Data Analysis, Software Applications, IBM System I, Big Data, Microsoft Outlook, Excel Formulas, Pivot Tables, Microsoft PowerPoint, Microsoft SharePoint, SQL Databases, Information Technology, Vba Programming Language, Data Management - **Published:** August 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=de708b9cfaf5d3de ## About the Role * 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 ## Description 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., * 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 ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)