Junior Business Analyst

About the Role

LightFeather is hiring a Junior Business Analyst to ensure internal data accuracy, timely reporting, and smooth daily operations. This is an internal position supporting LightFeather’s operations, reporting to operations leadership.

• Location: Arlington, VA, Fully in-office to start. Potential partial telework schedule after a three-month training period.
• Job Type: Full-time
• Salary: $50,000–$60,000 annually, based on experience level.

Key Responsibilities

Data, Reporting, and Automation (approx. 40%)

• Build and maintain Google Sheets trackers and reports for compliance, business development (BD) pipeline, and contract data calls.
• Create project dashboards to visualize status, milestones, and key metrics.
• Utilize ChatGPT and Claude daily for formula writing/debugging, data cleaning/analysis, summary drafting, and report creation.
• Identify and automate manual, repetitive tasks using scripts, sheet automations, and AI tools.
• Clean, reconcile, and validate data from multiple sources.
• Produce recurring weekly and biweekly reports and meeting decks.
• Identify and flag data gaps, errors, or unusual changes.
• Validate AI-generated outputs against source data.
• Document report steps, data sources, prompts, and automations.

Operations, Meetings, and Compliance (approx. 35%)

• Track and reconcile employee timesheets.
• Maintain government-furnished equipment (GFE) inventory and end-of-day follow-ups.
• Keep state compliance records current and update company websites.
• Follow documented procedures, company policies, and contract requirements precisely.
• Serve as the key Business Analyst for internal meetings: coordinate calendars, schedule, prepare agendas, and take minutes.
• Follow up on meeting-assigned tasks and maintain task trackers.
• Maintain team collaboration tracker, software inventory, and organize documents.
• Partner with part-time staff on reports, training decks, and surveys.

Recruiting Support (approx. 25%)

• Review resumes and shortlist qualified candidates.
• 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.
• Report on recruiting pipeline metrics.

Requirements & Tech Stack

• Hands-on experience using AI tools such as ChatGPT or Claude.
• Strong Google Sheets skills:
• Formulas like XLOOKUP, VLOOKUP, SUMIFS, FILTER, QUERY, and IMPORTRANGE.
• Pivot tables.
• Data validation dropdowns and conditional formatting.
• Basic charts.
• Working knowledge of Google Workspace, including sharing permissions, protected ranges, and version history.
• Experience with AI to analyze data, write formulas, and automate work.

Qualifications

• Bachelor’s degree in business, economics, information systems, statistics, or a related analytical field. Other degrees with strong coursework or experience in data are accepted.
• Some experience in an analyst, operations, administrative, or reporting role (internships count).
• Demonstrated track record of accurate and thorough work.
• Strong task execution skills; ability to follow established processes step-by-step.
• Highly organized; ability to keep files, trackers, and task lists in order.
• Clear, precise written communication and documentation skills.
• Proven ability to manage several recurring deadlines without compromising details.

Preferred Qualifications

• Google Apps Script experience.
• Vibe coding experience.
• Experience with Microsoft Excel.
• Familiarity with Jira, Greenhouse, or other tracking/applicant tracking systems.
• Exposure to government contracting or compliance work.