Key skills
AirflowApacheETLMS SQL ServerPythonRDBMSSQLAIELTData WarehousingAnalyticsBIPower BISnowflakeSQL ServerPerformance OptimizationCommunication
About this role
Role Overview
- Design, develop, and maintain databases for analytical and reporting needs
- Create and optimize Data Warehouse structures
- Design and implement Data Marts for various business domains
- Ensure data quality, consistency, and performance
- Collaborate with BI Engineers to support reporting and self-service analytics
- Develop and maintain permission and access control models
- Support and improve existing database solutions
- Build and maintain ELT pipelines
- Participate in performance tuning and optimization of analytical workloads
Requirements
- Knowledge of database fundamentals: indexing, normalization, transactions, query optimization
- Hands-on experience in database development and data modeling
- Understanding of data warehousing concepts (star/snowflake schemas, fact & dimension tables)
- Experience with analytical workloads and reporting systems
- Knowledge of ETL/ELT concepts and data pipelines
- Experience with structured and semi-structured data
- Understanding of data access control and permission models
- Good communication skills and ability to work with cross-functional teams
- BS in Computer Science or related field (or equivalent practical experience)
- Strong SQL skills
- Strong experience with RDBMS (MS SQL Server or similar)
- Solid data modeling skills (DWH, Data Marts)
- Good Python knowledge
- Basic AI prompting skills
- Nice to Have: Dagster, Airflow or other orchestration tools, Experience with BI tools (Apache Superset, Power BI, etc.), Experience with performance optimization and analytical databases usage (Clickhouse)
Tech Stack
- Airflow
- Apache
- ETL
- MS SQL Server
- Python
- RDBMS
- SQL
Benefits
- Health insurance
- Flexible work arrangements
- Professional development opportunities