Data Analyst & Administrative Specialist
Role Overview
National Tax Group seeks a Data Analyst & Administrative Specialist with intermediate-to-expert Microsoft Excel proficiency.
The role focuses on organizing, reviewing, analyzing, and maintaining data, alongside office administration and operational support.
The selected candidate works under the Senior Data Analyst and supports daily data management, reporting, and administrative activities.
Key Skills for This Role
Full Job Posting
Role overview
National Tax Group seeks a Data Analyst & Administrative Specialist with intermediate-to-expert Microsoft Excel proficiency.
The role focuses on organizing, reviewing, analyzing, and maintaining data, alongside office administration and operational support.
The selected candidate works under the Senior Data Analyst and supports daily data management, reporting, and administrative activities.
Compensation
- Compensation is listed as $22–$25 per hour.
Data analysis and Excel
- Organize, manage, and analyze large datasets; create and maintain spreadsheets, reports, and tracking systems.
- Use Excel formulas and functions, including VLOOKUP, XLOOKUP, IF statements, and SUMIFS; develop PivotTables, charts, and data summaries.
- Review, clean, format, consolidate, and validate information from multiple sources; reconcile figures and identify discrepancies.
- Assist with analytical reports, improve spreadsheets, recommend efficient data-management methods, and complete assigned projects accurately and on time.
Administration and operational support
- Prepare documents, maintain electronic files and records, and update company databases and tracking systems.
- Organize project documentation, prepare correspondence and internal reports, monitor deadlines, and follow up on missing information.
- Coordinate with internal team members and assist with other administrative and operational assignments.
Required qualifications
- Intermediate-to-advanced Microsoft Excel proficiency is required; expert-level skills are highly desirable.
- Experience with spreadsheets, data analysis, and data management, plus knowledge of Excel formulas, functions, PivotTables, and data organization.
- The role requires accuracy, attention to detail, analytical, problem-solving, and organizational skills, and the ability to manage assignments and deadlines.
- Microsoft Office proficiency, including Word and Outlook, and strong written and verbal communication are required.
- Candidates must work independently while following direction and handle confidential company and client information professionally.
Preferred qualifications
- Experience in data analysis, reporting, Excel specialization, or administrative support is preferred.
- Power Query, Power Pivot, Excel automation, report/dashboard development, and familiarity with accounting, financial, or business data are preferred.
- A relevant associate's or bachelor's degree is preferred; equivalent practical experience is also considered.
Selection process
- Candidates may be asked to complete a practical Excel skills assessment during the interview process.
About National Tax Group
National Tax Group provides tax incentive programs to businesses and describes its approach as specialized and client-focused.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career