Overview
On Site
$50 - $60
Contract - W2
Contract - 06 Month(s)
No Travel Required
Skills
Accounting
Computer Science
Finance
Financial Reporting
Microsoft
Microsoft Excel
Open Data Protocol
Procurement
SAP BASIS
Technical Support
VLOOKUP
Visual Basic
Workflow
FX
Job Details
Job Title: Data Analyst Job ID: 25-05910 Location: Skillman, NJ
Candidate Listed Requirements/Skill Priorities (in descending priority)
Requirements:
Candidate Listed Requirements/Skill Priorities (in descending priority)
Requirements:
- Strong Microsoft Excel skills
- Knowledge, understanding, and practical experience employing key excel formulas
- Ex: SUMIF, SUMIFS, XLOOKUP, VLOOKUP, INDEX, IF, IFERROR, VALUETOTEXT, and CONCAT
- Practical experience using complex formulas
- Ex: SUMIF inside an IF statement utilizing VALUETOTEXT
- Practical experience in cleaning excel file data
- Ex: Handling errors, blank cells, consolidating columns.
- Practical experience visualizing data within excel
- Experience with Power Query M coding language
- This language is heavily used in our Excel reporting
- Light Experience with additional Microsoft programming languages
- We use Power Fx, ODATA, and Workflow Definition Language (WDL) frequently in automation engineering.
- A large volume of experience with these tools is not necessary, the ideal candidate would have some practical experience or general knowledge of the language and a strong ability to self-teach these solutions on a per use basis.
- Experience developing financial reports or accounting knowledge
- The ideal candidate would be knowledgeable on baseline requirements for tracking a budget
- Experience working with end users/customers
- The ideal candidate would have experience acting as an internal company solution contact or performing communications on behalf of a company
- Ex: IT Help Desk Experience, Vendor outreach, Client Advocate
Nice to Have:
- Business/Accounting related background blended with IT or Computer Science Studies
- Background or skills related to financial reporting for a global company
- Background or skills in procurement work
- Strong Practical Experience developing solutions using Power Fx
- IT Experience
- Experience with Visual Basic Coding Language
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.