Data Analyst

DKKD Staffing; 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

Sick and Vacation Days

Flexible Spending Account

Life & Disability Insurance

Education Assistance

Employee Referral Program

Job summary

DKKD Staffing is seeking a Data Analyst (IT/ Business Analyst) for a 100% onsite role in Valencia, CA. The position focuses on developing data-driven models, extracting data, and delivering dashboards to improve cash collection and Accounts Receivable performance.

The ideal candidate has strong Excel expertise (VBA, complex formulas), experience with large datasets, and the ability to communicate findings to business stakeholders. Local residency is required.

Qualifications

• BS in Business, Finance, CS or equivalent
• 3-5 years of data analysis and reporting experience
• Strong Excel proficiency, including advanced formulas and VBA
• Experience with SQL/AS400 or similar data queries
• Excellent written and verbal communication, detail-oriented

Responsibilities

• Create and maintain advanced data models and dashboards
• Extract data using queries from AS/400 or SQL systems
• Collaborate with internal teams to improve operational performance
• Prepare customized reports for internal/external stakeholders
• Highlight trends and operational results in management reports
• Support implementation of new software solutions and dashboards
• Manage multiple priorities with tight deadlines
• Assist in creating company dashboards and ad-hoc analyses
• Participate in special projects aligned with business objectives

Skills

Advanced Excel

SQL/AS400

Data analysis

MS 365

Education

BS in Business/Finance/CS

Job description

• US Citizen or Permanent /Legal Resident Green Card.
• MUST currently live within 45 minutes from work location 91355.
• This job requires 100% onsite daily – no exceptions

JOB TITLE: Data Analyst (IT/ Business Analyst)

NO REMOTE – 100% ONSITE – NO exceptions

CLIENT WON’T ACCEPT RELOCATION

NOTE: Must already live locally or have family or friends who live within 30 minutes of Valencia, Ca

REPORTS TO: Business Analyst Manager

SALARY RANGE: $70,000.00 To $90,000.00 Annually

INDUSTRY: Healthcare

Company locations in California, Colorado, Illinois, Ohio, Texas and Washington.

WHAT WE ARE LOOKING FOR

Our client is looking for a Data Analyst for their corporate office in Valencia, Ca. 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.

The role sits on their business analysis team but is essentially an IT/business analyst hybrid new role.

NOTE: Very excel heavy; almost expert level using VBA macros, formulas, data management, and SQL.

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

Our client 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.