Snowflake Expert

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

• Ability to work partially within the U.S. time zone
• 6+ years of experience as a Data Engineer, Data Scientist, AI Engineer, etc.
• Proficiency in SQL, Python, AWS (Lambda, Airflow, Redshift)
• Detailed, solid knowledge of the Snowflake ecosystem including SnowPipes, Streams, Views, performance tuning, data modeling, ELT pipelines, data visualizations, standard DWH concepts, and experience implementing complex SQL stored procedures
• Experience with Snowflake Native Apps
• Working experience of AI concepts such as Generative AI chatbots, Cortex Analyst, agent training, various LLMs, and prompt engineering

Nice to have:

• Expertise in building and maintaining APIs; Swagger/OpenAPI spec, Node, and Next.js

• Design and implement data privacy features and services to enable secure multi-party collaboration, including query constraints, data clean room construction, deployment, and monitoring at scale
• Uphold data governance standards and practices, ensuring 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 programming proficiency to extract, transform, clean, and interpret large data volumes (200BIL+ records)
• Design highly performant data structures to ensure optimal storage and retrieval of data
• Utilize advanced database technologies to enhance data storage and processing capabilities

Availability between 15:00–19:00 (CET) is essential, with the remaining hours being flexible. Occasionally, there may be pre-scheduled calls with the US-based team after 20:00 CEST.