Solution Consultant

Ampstek

helsinki, uusimaa, Finland
Full-time
Posted June 08, 2026

Job Description

Key Responsibilities

  • Design, develop, and optimize ETL/data pipelines
  • Write complex SQL queries (joins, subqueries, CTEs, window functions)
  • Perform data transformation, validation, and data quality checks
  • Work with large-scale distributed datasets
  • Build and manage data ingestion pipelines (APIs, SFTP, Kafka)
  • Design and implement graph data models (nodes, edges, relationships)
  • Work with RDF data structures and semantic data
  • Write and optimize SPARQL queries for graph data retrieval
  • Build and maintain knowledge graphs / ontology-based systems
  • Automate workflows using Python scripting
  • Monitor, troubleshoot, and optimize pipeline performance

Key Skills Required

  • Strong Python (Pandas, NumPy, scripting)
  • Advanced SQL (joins, subqueries, CTEs, window functions, optimization)
  • Strong understanding of ETL processes and data p...