Senior Data Warehouse / OLAP Engineer

Tasks

• Analyze query execution plans
• Build aggregation layers
• Design data distribution and sharding strategies
• Design fact tables and dimension tables
• Design partitioning and indexing strategies
• Design scalable OLAP solutions
• Design scalable data warehouse solutions
• Develop ELT pipelines
• Develop ETL pipelines
• Develop analytical data models
• Document data models and transformation logic
• Ensure data quality and consistency
• Improve schema design and storage efficiency
• Monitor pipeline performance and resource utilization
• Optimize data models for analytics
• Optimize database performance
• Perform root cause analysis
• Troubleshoot production data issues
• Write and optimize complex SQL queries

Perks/Benefits

• N/A

Skills/Tech-stack

Agile | Cloud Computing | Data Aggregation | Data Distribution | Data Modeling | Data Warehousing | Database performance | Database performance tuning | Dimensional Modeling | ELT | ETL | Execution Plans | Incremental processing | Indexing | Linux | OLAP | Partitioning | Performance Tuning | Pre-aggregation | Query Execution | Query Optimization | Query execution plans | SQL | Scrum | Sharding | Snowflake Schema | Sorting | Star Schema