Description Job Title: Data AnalystLocation: Reston, VAKey Requirements:
Proficiency in Advanced Excel (Must pass Advanced Excel with 90% or higher)
Data audit and advanced Excel expertise
Requirements
Responsibilities:
Building and applying advanced formulas, such as SUMPRODUCT, INDIRECT, INDEX MATCH, and OFFSET
Proficient in creating and utilizing PivotTables
Familiarity with add-ins and ability to install them
Understanding and utilizing the AutoFilter feature for data analysis
Ability to record macros and use them for automation
Editing or modifying simple recorded macros
Preferred Skills (Nice to Have):
Experience recording macros and using them for later tasks
Proficiency in modifying simple recorded macros
Note: The ideal candidate for this position should have a strong foundation in data analysis, with a particular emphasis on Excel proficiency. The ability to perform data audits, create complex formulas, utilize PivotTables, and automate tasks through macros are essential for success in this role.Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.© 2024 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https:///www.roberthalf.com/us/en/terms) .