Data Analyst

Institutional clients include pension funds, endowments and insurance companies. Most staff have been with the firm for more than eight years.

Our team is growing and we are hiring a Data Analyst. You'll own a set of dashboards and the data behind them, and be the go-to person when someone asks why a number looks off. Employment is through our payroll partner in India. Salary is paid monthly in Indian rupees. Expect to work a schedule that overlaps with US Eastern business hours until about noon ET. A quiet workspace and good internet are required.

What you'll do:

• Define metric logic with stakeholders and document it.
• Analyse trends, cohorts and funnel drop-off and summarise findings in plain language.
• Create forecasts and simple models in Excel or Google Sheets.
• Build and maintain dashboards in Tableau, Power BI or Looker.
• Present results to managers and answer follow-up questions.
• Prepare weekly and monthly KPI reports for department leads.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.

You'll need:

• 2-4 years of experience in a data or reporting analyst role.
• Advanced Excel: pivot tables, XLOOKUP, Power Query.
• Strong SQL (joins, CTEs, aggregations, window functions)

Pluses:

• Python (pandas) or R for analysis.
• Google Analytics 4 or Adobe Analytics.
• Salesforce or NetSuite reporting.

What we offer:

• Health insurance through our employer-of-record partner.
• Performance bonus.
• Home office setup budget.
• 20 days paid time off.
• Co-working space stipend.
• Monthly internet allowance.

We review applications as they come in.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Hill Country Advisors.