Data Analyst (IT/ Business Analyst) DKKD Staffing•5.0 Valencia, CA Job Details Full-time $70,000•$90,000 a year 14 hours ago Benefits Disability insurance Health insurance Dental insurance Flexible spending account Vision insurance 401(k) matching Referral program Qualifications Spreadsheets Writing skills Microsoft Teams SharePoint Query management Data analysis software Full Job Description Overview

REQUIRES

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 LOCATION

Valencia (Santa Clarita), CA, 91355

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 Please complete both the Application & Job Specific questions below.

PART 1 APPLICATION QUESTIONS

(Please answer all questions for fastest process)

Legal Name & Preferred Name or Nickname:

Best Contact Info (Cell & email):

Your Linked In:

Why looking for a new job: Availability for interviews and a new job: Where do you live (City, State, Zip): Desired geographical work location: Are you open to 100% onsite, hybrid and/or remote: Are you open to relocation if required: Are you open to travel if needed and have an active passport if needed: Are you authorized to work in US (Please indicate US, Permanent/ Legal Resident Green Card or Other):

Hourly/Salary Expectations:

(We need a range) $ Sizes of staff managed and their titles (include # of direct reports):

Budgetary Responsibility:

$ Education/Certs/Degrees (also indicate which certs are active):

Who Referred You/ How Did You Hear About Job/ DKKD Staffing:

PART 2 Job Specific Q&A Please supply answers next to each question in the comments section. Please provide total years of experience, last used and any specific elaboration that might help you get an interview (How many years of experience and how recent is your experience) Advanced proficiency in

Excel :

Using VBA macros: Pivot tables: Multi-layer IF statements: Lookup formulas: Data management:

SQL:

Please elaborate per job responsibilities and qualifications in the job description: 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): Experience writing queries in AS400/SQL or similar: Join us on

Linked In:

www.

LinkedIn.com/in/DianeKrehbiel

ALL JOBS

www.

DKKDstaffing.com 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. 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. IND123 #IND123 Tagged as: Analyst, Information Systems/ Technology About DKKD Staffing Building Teams from

CIO/ CTO/CISO

to Helpdesk, and HR for over 25 years across US