Data Engineer with Snowflake

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

• Ability to work in the US zone (working hours aligned with US operations: 2:00 pm - 10:00 pm CEST)
• 6+ years of experience as a Data/Software Engineer
• Proficiency in SQL, Python, Node.js, AWS (Lambda, Airflow, Redshift)
• Hands-on experience with the Snowflake ecosystem, including expert knowledge of SnowPipes, Streams, Views, performance tuning, data modeling, ELT pipelines, data visualizations, and standard DWH concepts
• Experience implementing complex SQL stored procedures
• Knowledge of all aspects of the SDLC, as well as experience with Jenkins and setting up CI/CD processes
• Experience with data security concepts such as CCPA, GDPR, SSO, and JWT
• Familiarity with BI tools such as Thoughtspot, Sigma, Domo, Looker, Quicksights, Tableau
• Detailed knowledge of AI concepts such as Generative AI chatbots, cortex analyst, agent training, various LLMs, and prompt engineering
• Expertise building and maintaining APIs; Swagger/OpenAPI spec, Node, and Next.js is a plus

• 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