Data Engineer (Corporate DWH)
- Full-time
Company Description
We are looking for a Middle/Senior Data Engineer to join our internal data-driven initiative aimed at enhancing corporate analytics capabilities.
Why join us? You will work on a long-term project with technical growth opportunities, have a direct impact on analytics across the company, and collaborate with experienced professionals in the data and analytics domain.
The project is an internal Sigma Software initiative that combines two strategic goals: automating corporate reporting and providing a self-service data analytics platform for internal stakeholders.
As a Data Engineer, you will be responsible for designing and modeling data into Data Warehouses and Data Marts, building ELT pipelines, and collaborating with BI Engineers to create reports in Apache Superset, as well as supporting other roles that consume such data.
Job Description
- 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
Qualifications
- 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
- Intermediate level of English
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)