Lead Data Analyst

We prepare audits, reviews and compilations for nonprofits, construction companies and HOAs. Employee benefit plan audits and single audits are a specialty. Busy season means 55-hour weeks from February through April 15, and summers are lighter.

Job summary:

Roberts CPAs is hiring for the Lead Data Analyst role to answer business questions with data and turn the answers into reports people actually use. The Revenue Operations team needs someone who can write SQL, build dashboards and explain what changed and why. Employment is through our payroll partner in India. Salary is paid monthly in Indian rupees. Core hours overlap with US Central time, 9:00 AM to 1:00 PM CT. You will need a reliable internet connection and a quiet place to work.

Main duties:

• Track sales, inventory or service levels against targets and flag misses early.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Present results to managers and answer follow-up questions.
• Define metric logic with stakeholders and document it.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.
• Create forecasts and simple models in Excel or Google Sheets.

Skills and experience:

• 7+ years of experience in a data or reporting analyst role.
• Clear written and verbal communication with non-technical stakeholders.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Basic statistics: averages vs. medians, distributions, significance.
• Bachelor's degree in statistics, economics, business, math or a related field.

What we offer:

• Wellness allowance.
• Annual team retreat.
• Company laptop.
• Co-working space stipend.
• Paid parental leave.
• Annual learning budget.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Roberts CPAs, Inc..