adp
Data Analyst
Shield HealthCare
Valencia, USA
Full-time
Mid · 3+ years experience
Onsite
USD 70000-90000 yearly / year
Discovered 1 months ago
AS400SQLVBA
Key Skills for This Role
AS400SQLVBA
Full Job Posting
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.
About Shield HealthCare
Home Healthcare494 employeesFounded 1957
Shield HealthCare is a U.S. home medical-supply provider delivering incontinence, urological, ostomy, enteral-nutrition, diabetes, and wound supplies.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Shield HealthCare
Supervisor, Distribution
Valencia, USA
Discovered 1 weeks agoFull-time
Data Integration Engineer
Valencia, USA
Discovered 1 weeks agoFull-time
Associate Product Manager
Valencia, USA
Discovered 1 weeks agoFull-time
Warehouse Clerk
Carrollton, USA
Discovered 1 weeks agoFull-time
Warehouse Clerk
Carrollton, USA
Discovered 1 months agoFull-time
Customer Service Agent
Valencia, USA
Discovered 1 months agoFull-time
Territory Sales Representative
Sacramento, USA
Discovered 1 months agoFull-time
Eligibility and Risk Specialist
Valencia, USA
Discovered 1 months agoFull-time