Junior Business Analyst

LIGHTFEATHER IO LLC•Arlington, VA

3d•$50,000 - $60,000•Onsite

About The Position

LightFeather is hiring a Junior Business Analyst to support the company’s internal operations by maintaining accurate data, delivering timely reports, managing operational and compliance records, and supporting recruiting. This role owns recurring reports and trackers in Google Sheets, builds project dashboards, supports internal meetings, follows established procedures, and uses AI tools such as ChatGPT and Claude to analyze data and automate repetitive tasks. It is an internal position, not a role on a government contract. The position is based in Arlington, Virginia, and is fully in-office to start, with the potential for partial telework after a three-month training period. The employee works closely with a small team and reports to operations leadership. Responsibilities are divided approximately among data, reporting, and automation (40%); operations, meetings, and compliance (35%); and recruiting support (25%). The ideal candidate is dependable, organized, data-driven, accurate, deadline-oriented, careful with compliance, and eager to use AI to improve manual processes.

Requirements

Bachelor’s degree in business, economics, information systems, statistics, or a related analytical field; other degrees may be considered with strong data coursework or experience.
Some experience in an analyst, operations, administrative, or reporting role; internships count.
Demonstrated accuracy and thoroughness, including double-checking numbers and catching errors.
Ability to follow established processes, policies, and compliance requirements and complete tasks fully.
Strong organizational skills for managing files, trackers, and task lists.
Hands-on experience with AI tools such as ChatGPT or Claude and a strong interest in using AI for data analysis, formula writing, and automation.
Strong Google Sheets skills, including XLOOKUP or VLOOKUP, SUMIFS, FILTER, QUERY, IMPORTRANGE, pivot tables, data validation dropdowns, conditional formatting, and basic charts.
Working knowledge of Google Workspace, including sharing permissions, protected ranges, and version history.
Clear, precise written communication and documentation skills.
Ability to manage several recurring deadlines without losing detail.

Nice To Haves

Google Apps Script experience, especially automating sheets, emails, and workflows.
Vibe coding experience, ideally with an example of a script, automation, or small tool built with AI.
Experience with Microsoft Excel in addition to Google Sheets.
Familiarity with Jira, Greenhouse, or another tracking or applicant tracking system.
Exposure to government contracting or compliance work.

Responsibilities

Build and maintain Google Sheets trackers and reports for compliance, business development pipeline, and contract data calls.
Create project dashboards showing status, milestones, and key metrics.
Use ChatGPT and Claude to write and debug formulas, clean and analyze data, summarize findings, and draft reports.
Identify repetitive manual tasks and automate them using AI-assisted scripts, spreadsheet automations, and small tools.
Clean, reconcile, and validate data from multiple sources so figures match across reports.
Produce recurring weekly and biweekly reports and meeting decks summarizing metrics and trends.
Identify data gaps, errors, or unusual changes and flag them before reports are distributed.
Verify AI-generated formulas, code, and summaries against source data before sharing.
Document report procedures, data sources, prompts, and automations so processes are repeatable.
Track and reconcile employee timesheets.
Maintain government-furnished equipment inventory and perform end-of-day follow-ups.
Keep state compliance records current and update company websites as needed.
Follow documented procedures, company policies, and contract requirements, and flag compliance issues.
Coordinate internal meetings, calendars, agendas, and minutes as the key Business Analyst for internal meetings.
Follow up with staff on meeting assignments and maintain task trackers and follow-up items.
Maintain the team collaboration tracker and software inventory, and organize shared-drive documents as needed.
Partner with part-time staff on reports, training decks, and surveys.
Review resumes and shortlist qualified candidates for hiring managers.
Conduct initial phone and video prescreens covering qualifications, availability, and salary expectations.
Schedule interviews across multiple stakeholders.
Maintain accurate candidate records and statuses in Greenhouse and communicate promptly with candidates.
Report recruiting pipeline metrics, including time to fill and candidate volume.