Smarter HR Solutions LLC - Excel Data Analyst

Data Analyst is needed in Houston, United States.

Client: Smarter HR Solutions LLC

Location: Houston, TX, us

Contract: Contract

Job Description

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

• 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

• 3–5 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.

Additional Information

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 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.