Senior Data Engineer (Snowflake)

Requirements description

• Ability to work partially within the U.S. time zone (during onboarding: calls up to 10:00 PM CET a few times a week; later: up to 5/6/7 PM CET)
• 6+ years of experience in Data Engineering, with Snowflake as a primary data platform.
• Proven hands-on experience optimising Snowflake warehouses and storage for performance and cost efficiency in production environments.
• Experience building and optimising pipelines processing very large datasets, including full transaction-level histories rather than samples.
• Strong SQL and Python skills, with the ability to own data pipelines end to end.
• Practical experience with data quality engineering, including validation, reconciliation, monitoring, and ongoing data reliability.

Nice to have

• Experience working with financial, market, transaction-level, or time-series data.
• Familiarity with accuracy and tracking metrics such as correlation and mean absolute error (MAE).
• Experience integrating and maintaining third-party data feeds or working with data licensing and data-sharing arrangements.
• Practice with dbt or similar data transformation frameworks on Snowflake.

Your responsibilities

• Build and maintain a Snowflake-based evaluation pipeline to measure the accuracy of new datasets, both independently and combined with existing data.
• Implement evaluation metrics such as correlation and mean absolute error (MAE) to compare estimated company revenue against reported results.
• Optimise Snowflake performance and compute costs through warehouse sizing, clustering, materialisation, query optimisation, and data pruning.
• Develop automated processes for collecting, mapping, validating, and maintaining ground truth company revenue data.
• Implement data quality checks, reconciliation rules, and monitoring to identify inconsistencies before they affect downstream reporting.
• Evaluate new datasets as they become available and investigate data quality issues.
• Own the pipeline end-to-end, making technical decisions and adapting the implementation as project requirements evolve.
• Build on existing prototypes and previous work to deliver a reliable, production-ready solution

Recruitment stages

• HR call (max 15 min.)
• Technical interview with the Acaisoft team (max 45 min.)
• Call with our Client (+/- 60 min.)

Offer description

Hi there! If you’re seeking a high-impact role within an ambitious and fast-growing software house, you might have just found your perfect match!

We are seeking a highly skilled and experienced Senior Data Engineer to join our team. You will be working with one of the biggest consumer insights providers in the U.S.

In this role, you will build and optimise a data evaluation pipeline in Snowflake for a financial data analytics project. The goal is to independently assess the quality and added value of new credit card transaction datasets by comparing company revenue estimates against reported financial results, while ensuring the process is scalable, cost-efficient, and automated.

You will take ownership of the pipeline end to end, from data processing and ground truth collection to quality validation and ongoing dataset evaluations.

Working hours: Availability between 5:00 PM and 10:00 PM CET is essential during onboarding; afterwards, standard hours end around 5/6/7 PM CET (depending on the day).