As/400 Data Jobs

1 job found

Today

Data Analyst

Shield HealthCare Valencia, CA

Valencia, CA

Today

$70k - $90k/yr Full time Analytical Skills Analytics As/400

Apply Now

Job Description

Shield HealthCare is hiring an on-site Data Analyst in Valencia, CA to build advanced analytics models, reporting, and dashboards that support operational performance.

Responsibilities

Build and maintain advanced data models in Excel or other applications using complex formulas and business rules
Extract and analyze data by writing queries from AS400 (or SQL) data management systems
Collaborate with internal teams to continuously improve operational performance and model accuracy
Create customized reports for internal and external stakeholders and communicate findings clearly and concisely
Produce management reporting that highlights operational results and emerging trends
Improve order review accuracy to support higher cash collection rate, lower write-offs, and reduced Accounts Receivable balances
Assist with implementation of new software application solutions as needed
Manage multiple priorities with aggressive deadlines, including appropriate follow-up and closure
Support creation and maintenance of company dashboards
Complete special projects aligned to team and organizational objectives and continuous improvement initiatives

Requirements

BS in Business, Finance, Computer Science, or an 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 Excel capability, including pivot tables, multi-layer IF statements, lookup formulas, and VBA (a plus)
Experience writing queries in AS400/SQL or similar
Strong analytical and problem-solving skills
Ability to work independently with strong accountability
Strong written and verbal communication skills
Strong organizational skills, with extreme attention to detail; able to manage multiple priorities, respond to changing business needs, and meet critical deadlines

Salary

USD 70,000 - 90,000 per year

Education

BS in Business, Finance, Computer Science

Location

Valencia, CA (onsite)

Technologies

Excel, AS400, SQL, Microsoft 365, Outlook, PowerPoint, Word, SharePoint, Teams, VBA

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

View full job page →

Get As/400 Data Jobs alerts

New As/400 Data Jobs, daily.