Senior Data Engineer (AWS+Snowflake)

Acaisoft is a software house working with one of the biggest consumer insights providers in the U.S.

• 6+ years of experience as a Data Engineer or Data Scientist
• Proficiency in SQL, Python, and AWS (including Lambda, Airflow, Redshift)
• Detailed knowledge of the Snowflake ecosystem: SnowPipes, Streams, Views, performance tuning, data modeling, ELT pipelines, data visualizations, standard DWH concepts, and complex SQL stored procedures

Nice to have:

• Experience with AI concepts including Generative AI chatbots, Cortex Analyst, agent training, various LLMs, and prompt engineering
• Working knowledge of Databricks
• Expertise in building and maintaining APIs; Swagger/OpenAPI spec, Node, and Next.js

• Design and implement data privacy features and services for secure multi-party collaboration, including query constraints, data clean room construction, deployment, and monitoring at scale
• Uphold data governance standards and ensure compliance with data quality standards
• Implement and enforce data security measures to protect sensitive data, including personally identifiable information (PII) and financial data
• Leverage SQL and Python to extract, transform, clean, and interpret large data volumes (200BIL+ records)
• Design highly performant data structures for optimal storage and retrieval
• Utilize advanced database technologies to enhance data storage and processing capabilities

Ability to work partially within the U.S. time zone (onboarding calls up to 9:30 PM CET 3x a week; later up to 6–7:00 PM CET).