Sigma Software Group

Data Engineer, Corporate DWH

Sigma Software Group

full-time

Posted on:

Location Type: Remote

Location: Ukraine

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AirflowApacheETLMS SQL ServerPythonRDBMSSQL

About the role

  • 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)
Benefits
  • Health insurance
  • Flexible work arrangements
  • Professional development opportunities
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
database developmentdata modelingdata warehousingSQLRDBMSdata qualityperformance tuningETLELTdata access control
Soft Skills
communicationcollaborationcross-functional teamwork
Certifications
BS in Computer Science