Onsite Data Analyst: Excel/SQL Dashboards

DKKD Staffing; California (MO); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401(k) matching

Paid time off

Job summary

DKKD Staffing is hiring a Data Analyst (IT/Business Analyst) to work 100% onsite in Valencia, CA. You will build advanced Excel-based data models, extract data from AS400/SQL, and deliver reports and dashboards focused on healthcare operations.

The role requires 3–5 years of data analysis experience, exceptional Excel/VBA skills, and the ability to work independently in a fast-paced environment while communicating clearly with stakeholders.

Qualifications

• Eligibility: US Citizen or Permanent/Green Card holder
• Education: BS in Business, Finance, CS or equivalent
• Experience: 3-5 years in data analysis and reporting with large datasets
• Microsoft 365 proficiency: Excel (Expert), Outlook, PowerPoint, Word, SharePoint, Teams
• Advanced Excel: Pivot tables, multi-layer IF statements, lookup formulas; VBA is a plus
• Query experience: AS400/SQL or similar
• Strong analytical and problem-solving skills
• Strong written and verbal communication skills
• Excellent organizational skills with ability to manage multiple priorities and meet deadlines
• Very Excel-heavy: VBA macros, formulas, data management, SQL

Responsibilities

• Create and maintain advanced data models using complex formulas and business rules
• Extract data using queries from AS400/SQL systems
• Partner with internal departments to improve operational performance and refine models
• Develop and prepare customized reports for internal and external stakeholders
• Prepare management reports highlighting operational results and trends
• Enhance order review accuracy to improve cash collection rate and reduce write-offs
• Assist in implementing new software application solutions
• Handle multiple priorities with aggressive deadlines and ensure closure
• Support creation of company dashboards
• Complete special projects supporting team and organizational objectives

Skills

Advanced Excel

AS400/SQL

Data analysis

Excel VBA

Microsoft 365 proficiency

Strong communication

Independent work

Education

BS in Business, Finance, Computer Science

Tools

Excel

VBA

Microsoft 365

SQL

AS400

Dashboards

Pivot tables

Job description

DKKD Staffing is hiring a Data Analyst (IT/Business Analyst) to work 100% onsite in Valencia, CA. You will build advanced Excel-based data models, extract data from AS400/SQL, and deliver reports and dashboards focused on healthcare operations.

The role requires 3–5 years of data analysis experience, exceptional Excel/VBA skills, and the ability to work independently in a fast-paced environment while communicating clearly with stakeholders.