Junior Business Analyst

LIGHTFEATHER IO LLC•Arlington, VA
•$50,000 - $60,000•Onsite

About The Position

LightFeather is hiring a Junior Business Analyst to support the accuracy of internal data, timely reporting, and smooth daily operations. This internal role supports LightFeather’s own operations and is not assigned to a government contract. The analyst owns recurring reports and trackers in Google Sheets, builds project dashboards, serves as the key Business Analyst for internal meetings, follows established processes, uses AI tools such as ChatGPT and Claude to automate repetitive work, maintains compliance and operational records, and supports recruiting. The role is suited to a dependable, highly organized, data-driven, and exceptionally accurate person who follows established processes, takes compliance seriously, meets deadlines reliably, and sees tasks through to completion. The analyst works closely with a small team and reports to operations leadership. The position is based in Arlington, Virginia, and is fully in-office at first. A partial telework schedule may be possible after a three-month training period. It is full-time, with an annual salary of $50,000–$60,000 based on experience level.

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.
  • A record of accurate, thorough work, including double-checking numbers and catching errors.
  • Ability to follow established processes, policies, and compliance requirements step by step and complete tasks.
  • Strong organizational skills, including keeping files, trackers, and task lists orderly and knowing the status of work.
  • Hands-on experience with AI tools such as ChatGPT or Claude and strong interest in using AI for data analysis, formulas, 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 in shared files.
  • Clear, precise written communication and documentation skills.
  • Ability to manage several recurring deadlines without losing details.
  • Ability to handle confidential information, including timesheets and candidate details, with discretion, including when using AI tools.

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, the 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 scripts, sheet automations, and small AI-assisted 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 steps, data sources, prompts, and automations so processes are repeatable.
  • Track and reconcile employee timesheets.
  • Maintain government-furnished equipment inventory and complete 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 calendars and meetings, prepare and distribute agendas, and take minutes as the key Business Analyst for internal meetings.
  • Follow up with staff on meeting assignments and keep task trackers and follow-up items current.
  • 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 with candidates promptly.
  • Report recruiting pipeline metrics, including time to fill and candidate volume.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service