Position: Junior/Intern Data Analyst (SQL, Python)
Company: MarketPsych
Category: Data Science
Experience required: no_exp
English level: upper
Published: 2021-10-01T00:00:00+03:00

These skills will be the most relevant:

- Familiarity with mathematics, statistics, logic
- SQL
- Python for scripting or notebooks (other programming language is fine)
- UNIX/Linux command line (tools like grep, sed, awk, pipelines etc.)

You don't have to know all 4: 3/4 is good, 2/4 is probably fine, but you should be a quick learner.

Also optional but useful:
- Pandas for data analysis
- FastAPI to create APIs and webapps
- ClickHouse experience
- Experience with financial industry

A few random questions to think about:
- if SQL didn't have COUNT(), could you replace it with other aggregate function?
- if SQL didn't have HAVING clause, how would you replace it?
- is this a good formula for relative difference between x and y: 1 - y/x ?
- what's a good statistic to measure lags (e.g. ping): mean, median, other quantiles?