Publicis Sapient - Data Engineer - Snowflake

Job Description :

As a Software Engineer - Snowflake you will be responsible for maintaining the operational health of the Snowflake data platform, including monitoring performance, resolving incidents, managing user access, and supporting data pipeline reliability. The ideal candidate should possess a solid understanding of Snowflake architecture, basic scripting skills for automation, and a proactive approach to system support and documentation.

Job Requirements :

Education and Certifications :

- Bachelor's degree in Computer Science, Information Systems, or a related technical field

- Certifications in Snowflake, SQL, or cloud platforms (AWS, Azure, GCP) are a plus.

Required Experience :

- 1- 4 years of hands-on experience in data platform support or operations roles

- Working knowledge of Snowflake architecture, query optimization, security model, and platform features.

Essential Skills :

- Proficiency in SQL with the ability to troubleshoot query issues and monitor query performance in Snowflake

- Understanding of Snowflake components such as virtual warehouses, roles, stages, and tasks

- Experience in supporting Snowflake user management, permissions, and role-based access control

- Familiarity with scheduling and orchestration tools (e.g., Airflow, dbt, or native Snowflake tasks)

- Ability to work with data engineers and analysts to resolve data refresh and access-related issues

- Strong verbal and written communication skills for documenting issues and coordinating with global stakeholders

Desired Skills :

- Exposure to cloud platforms such as AWS or Azure, especially in relation to data storage and cost optimization

- Experience with scripting languages like Python or Bash for automating routine tasks

- Knowledge of observability and logging tools (e.g., Datadog, CloudWatch, or Grafana) for monitoring Snowflake usage and performance

- Understanding of data governance practices, including PII handling, audit logs, and data masking

- Awareness of ITIL-based processes (Incident, Change, and Problem Management)

- Foundational understanding of AI-driven automation in IT operations

- Familiar with integrating machine learning models into operational workflows

- Experience in consuming and integrating RESTful APIs for system interactions.

Role & Responsibilities :

Delivery and Execution :

- Monitor Snowflake platform health, including query performance, storage usage, and virtual warehouse efficiency

- Respond to incidents and service requests related to Snowflake access, slow queries, pipeline failures, and data visibility issues

- Perform routine support tasks such as access provisioning, job reruns, and environment syncs in coordination with engineering teams

- Assist in query tuning and collaborate with users to resolve performance bottlenecks or data availability issues

- Track issues through ticketing systems, ensuring accurate status updates, timely closure, and root cause documentation

Support and Enablement :

- Act as the first point of contact for Snowflake-related issues and coordinate with DevOps and platform leads for advanced troubleshooting

- Participate in platform updates, patch rollouts, and maintenance windows as required

- Maintain detailed logs of incidents, configurations, and troubleshooting steps for knowledge reuse

- Engage in support calls, sprint reviews, and operations stand-ups to stay aligned with evolving priorities