Excel Data Analyst

Smarter HR Solutions LLC

Job Location:

Houston, TX - USA

Hourly Salary: $ 34 - 34

Experience Required: 1-3years

Posted on: 10 hours ago

Vacancies: 1 Vacancy

Job Summary

***Please note: This position is onsite and not remote. Candidates must be based in the Houston area as relocation assistance is not provided. Only individuals authorized to work in the U.S. without sponsorship will be considered.***

Job Title: Excel Data Analyst

Job Type: Contract (4 week assignment)

Job Salary: $34/hour

Job Schedule: M-F 40 hrs/week

Job Location: Houston TX 77002

Pre-Employment Requirements: Successful completion of a background check drug screening and any applicable assessments

About the Role

We are seeking an Excel Data Analyst to support a short-term project focused on consolidating validating and analyzing data from multiple sources. The ideal candidate will have strong Excel skills experience working with large datasets and the ability to quickly deliver accurate results.

Key Responsibilities

Combine and reconcile data from multiple sources into a single dataset.
Clean validate sort and filter large datasets.
Utilize advanced Excel functions including:
- XLOOKUP
- INDEX/MATCH
- SUMIFS
- IF Statements
- Pivot Tables
Use Power Query to transform and prepare data.
Perform data quality checks and resolve discrepancies.
Create reports and tracking spreadsheets.
Maintain data accuracy and confidentiality.

Requirements

Required Qualifications

Candidates will be required to take an Excel assessment.

Minimum 2 years of professional experience using advanced Microsoft Excel in a data analysis reporting finance accounting or related role.
Experience working with large datasets and data reconciliation.
Hands-on experience with Power Query.
Strong proficiency in:
- XLOOKUP
- INDEX/MATCH
- SUMIFS
- IF Statements
- Pivot Tables
- Data Filtering & Sorting
Excellent attention to detail and organizational skills.
Ability to work independently and meet deadlines.

Preferred Qualifications

35 years of relevant experience.
Experience with data cleanup migration or reporting projects.
Knowledge of Power BI VBA or Excel automation.
Government or public-sector experience.

Required Skills:

Required Qualifications Candidates will be required to take an Excel assessment. Minimum 2 years of professional experience using advanced Microsoft Excel in a data analysis reporting finance accounting or related role. Experience working with large datasets and data reconciliation. Hands-on experience with Power Query. Strong proficiency in: XLOOKUP INDEX/MATCH SUMIFS IF Statements Pivot Tables Data Filtering & Sorting Excellent attention to detail and organizational skills. Ability to work independently and meet deadlines. Preferred Qualifications 35 years of relevant experience. Experience with data cleanup migration or reporting projects. Knowledge of Power BI VBA or Excel automation. Government or public-sector experience.