Senior Data Engineer - Snowflake

Capgemini • Atlanta, GA

3d

About The Position

We are seeking for a senior Snowflake Data engineer to join our team. The candidate will be responsible for designing, building, and maintaining scalable and efficient data solutions on the Snowflake Data Cloud. This role is key in transforming raw data into actionable insights, enabling data-driven decision-making across the organization

Requirements

• 5 years of experience in data engineering, data warehousing experience in Snowflake.
• Proven experience in designing, implementing, and supporting data warehousing and business intelligence solutions on Snowflake.
• Strong hands-on experience with Snowflake, including its architecture, features (e.g., Snowpipe, stored procedures, streams, tasks), and SnowSQL proficiency.
• Expertise in SQL for writing and optimizing complex queries, and experience with relational and non-relational databases.
• Strong understanding of ETL/ELT processes and data modeling concepts (star/snowflake schemas, normalization).
• Experience with cloud platforms like AWS, Azure, or Google Cloud and their integration with Snowflake is a plus.
• Proficiency in programming languages like Python or Bash for automation and data manipulation tasks.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent written and verbal communication skills to effectively convey technical concepts and collaborate with stakeholders.
• Ability to work effectively in a fast-paced, dynamic environment and adapt to changing priorities.

Nice To Haves

• Experience with cloud platforms like AWS, Azure, or Google Cloud and their integration with Snowflake is a plus.

Responsibilities

• Design, develop, and maintain robust data pipelines and data stores within the Snowflake platform.
• Build and manage ETL/ELT workflows and data integration processes, leveraging both Snowflake's native capabilities and relevant ETL tools (e.g., Informatica IICS, Apache Airflow).
• Optimize Snowflake performance through query tuning, warehousing sizing, data re-clustering, and other best practices to ensure scalability and reliability.
• Collaborate with data analysts, data scientists, and other stakeholders to understand data requirements and translate them into efficient data solutions.
• Implement and enforce data governance policies, security measures (e.g., data masking, row-level security), and quality checks to ensure data integrity and compliance.
• Handle various data formats, including structured and semi-structured data (e.g., JSON, XML), and integrate Snowflake with diverse data sources and third-party tools.
• Document technical specifications, data mappings, and process flows to support data governance and compliance efforts.
• Stay current with Snowflake updates, industry best practices, and new data technologies to continuously improve data solutions.
• Troubleshoot data-related issues, identify bottlenecks, and resolve performance problems within Snowflake data pipelines and warehouses.
• Participate in Agile ceremonies (daily stand-ups, sprint planning, sprint reviews, and retrospectives) to ensure efficient delivery and iteration of solutions.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees