Data Engineer (Corporate DWH)
Job Summary
- 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)
Remote Work :
Yes
Employment Type :
Full-time
Key Skills
About Company
At Sigma Software, we are involved with the clients team to contribute to the design and development of a technical solution for their tokenized domain reservation platform. We started by assigning a software architect to design the smart contracts and integrate blockchain into the s ... View more