BI Internship for students: building ETL processes, working with DBT, Dagster, Postgres, Clickhouse, and Apache Superset. Part-time for 3 months.
Tasks:
- Building ETL processes: developing and configuring data collection and transformation pipelines from various sources
- Working with a modern transformation stack: learning and applying DBT to transform "raw" data into clean analytical layers
- Data orchestration: configuring and maintaining workflows (pipelines) in Dagster
- Storage management: working with Postgres and the column-oriented database Clickhouse
- Visualization: developing interactive BI reports in Apache Superset
- Query optimization: analyzing and accelerating heavy queries
Requirements:
- SQL: strong command of the language (complex queries, aggregate functions, understanding query optimization principles)
- Databases: understanding the structure of relational databases (specifically PostgreSQL) and general principles of building analytical data warehouses
- Python: basic knowledge of the language, ability to write scripts for data processing and automating simple tasks
- Analytical mindset: ability to work with large datasets, identify patterns, and structure information
Conditions:
- Part-time (fixed-term employment contract for 3 months, 5/2, up to 30 hours per week)
- Work format: remote, office, or hybrid
- We consider students from any universities and forms of study, including part-time and master's programs
Skills:
- SQL
- PostgreSQL
- Python
- DBT
- Dagster
- Clickhouse
- Apache Superset
