Senior Data Warehouse Engineer

Jobgether SRL; Town of Italy (NY); On-site; EUR 134,000 - 181,000; Full time

Benefits offered by this job

Fully remote work

Global collaboration

Hands-on with ClickHouse, Redshift, db

Job summary

Jobgether SRL is seeking a Senior Data Warehouse Engineer based in Italy. You will architect and maintain scalable data warehouse solutions that power analytics and ML initiatives, and develop reliable ELT pipelines with strong data quality.

You will optimize performance, collaborate with data scientists, and promote best data practices across cloud platforms including ClickHouse, BigQuery, Snowflake, and Redshift.

Qualifications

• Experience designing and optimizing data warehouses in cloud environments (AWS or GCP).
• Strong SQL skills and dbt experience.
• Experience with columnar/cloud data warehouses (ClickHouse, BigQuery, Snowflake, Redshift).
• Data pipelines using orchestration tools (Airflow or Prefect).
• Knowledge of data quality, warehouse architecture, and ETL/ELT best practices.
• Version control, testing, automation, and code reviews in data projects.

Responsibilities

• Architect and maintain scalable data warehouse solutions for analytics and operations.
• Develop reliable data pipelines and ELT processes with strong data quality standards.
• Optimize warehouse performance via partitioning, indexing, and tuning techniques.
• Collaborate with data analysts/scientists to enable analytics and ML initiatives.
• Monitor and improve data warehouse reliability, performance, and cost efficiency.
• Promote best practices for clean, structured, reliable data across systems.
• Work with ClickHouse and other cloud services; integrate data platforms.

Skills

SQL

Data modeling

dbt

Cloud data warehousing

Airflow/Prefect

Python

Terraform

Kafka

DevOps mindset

ClickHouse

Tools

ClickHouse

Databricks

BigQuery

Snowflake

Redshift

Apache Superset

Sigma

Job description

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Data Warehouse Engineer based in Italy.

• Architect, build, and maintain scalable, high-performance data warehouse solutions that support analytics and operational needs.
• Develop reliable, well-documented data pipelines and ELT processes while maintaining strong standards for data quality and consistency.
• Optimize data warehouse performance through query optimization, partitioning, indexing, and other performance-tuning techniques.
• Partner with data analysts and data scientists to transform raw data into actionable analytics and support machine learning initiatives.
• Monitor, troubleshoot, and continuously improve data warehouse infrastructure while balancing performance, reliability, and cost efficiency.
• Establish and promote best practices for clean, well-structured, reliable, and accessible data.
• Work with modern cloud-based data warehouses such as ClickHouse and integrate data platforms with other cloud services.
• Contribute to developer-facing data tools and solutions that empower engineering and other technical teams.
• Support data transformation and modeling initiatives using tools such as dbt and SQL.
• Contribute to automation, testing, version control, code reviews, and other software engineering practices across data systems.
• Help improve the scalability, maintainability, and operational efficiency of the overall data platform.

Requirements

• Extensive professional experience designing, implementing, and optimizing data warehouses in cloud environments such as AWS or GCP.
• Strong hands-on expertise with data modeling and transformation tools, particularly dbt.
• Excellent SQL skills and experience with modern columnar or cloud data warehouse technologies such as ClickHouse, Databricks, BigQuery, Snowflake, or Redshift.
• Experience developing and managing data pipelines using orchestration tools such as Prefect or Airflow.
• Solid understanding of data engineering principles, warehouse architecture, transformation, and data quality.
• Strong software engineering fundamentals, including version control, code reviews, testing, automation, and maintainable development practices.
• Experience working collaboratively with data scientists, analysts, engineers, and other cross-functional stakeholders.
• Strong English communication skills for effective collaboration within a globally distributed remote team.
• High degree of ownership, autonomy, and accountability, with the ability to work effectively in ambiguous environments.
• Strong analytical and problem-solving skills, with a practical approach to troubleshooting and performance optimization.
• Familiarity with business intelligence and visualization tools such as Apache Superset, Sigma, Tableau, or Looker is a plus.
• Experience with infrastructure-as-code tools such as Terraform and a DevOps-oriented mindset is desirable.
• Scripting or automation experience with Bash, Python, or Go is an advantage.
• Experience with technologies such as Kafka, AWS, Terraform, and modern data visualization platforms is beneficial.

Benefits

• Fully remote work arrangement within eligible hiring locations.
• Opportunity to work on large-scale data infrastructure supporting a technology platform focused on online security and fraud detection.
• Exposure to a modern technology stack including ClickHouse, Redshift, Confluent Kafka, dbt, Prefect, AWS, Terraform, Apache Superset, and Sigma.
• Opportunity to collaborate with data scientists, analysts, engineers, and globally distributed technical teams.
• High level of ownership and autonomy in a data engineering environment.
• Opportunity to contribute to developer-facing tools and scalable data platform initiatives.
• US-based compensation range of $152,000–$205,000; compensation may vary by hiring location and is not directly applicable to all locations.
• Fully remote international environment with team members distributed across multiple countries and time zones.
• Visa sponsorship is not provided; candidates must be authorized to work from their home location.
• Specific India-based salary, healthcare, retirement, paid time off, and other benefits were not specified in the source description.