ONLY W2, NO C2C
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: IT Development Manager
INDUSTRY: Healthcare
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.
Never miss an opportunity! Create an alert based on the job you applied for.
