Data Engineer with Snowflake

O projekcie: 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 be responsible for designing, implementing, and maintaining robust data structures and controls for privacy features and services, enabling secure multi-party collaboration. You will ensure compliance with data governance standards, implement strong data security measures, and leverage your expertise in SQL and Python to manage large data volumes. This position requires a deep understanding of various data technologies, cloud environments, data clean rooms, and AI concepts. Working hours: aligned with US operations ( 2:00 pm - 10:00 pm CEST ). Wymagania: - Ability to work in the US zone - 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, and 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 a plu Codzienne zadania: - 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