Snowflake Developer (local to Pittsburgh, PA)

Role: Snowflake Developer Location: Pittsburgh, PA (Only Locals) Job Type: Contract to hire Job Description: Relevant Experience: 9+ Years Roles & Responsibilities: • Design and implement scalable, secure, and high-performance data pipelines using Snowflake. • Architect and manage data warehousing solutions and ETL/ELT processes using tools like DBT, Matillion, Talend, or Informatica. • Work closely with business stakeholders, data analysts, and BI developers to understand data requirements and translate them into robust data models. • Optimize Snowflake performance through query tuning, clustering, caching, and resource monitoring. • Implement and maintain data governance, data security policies, and access controls within Snowflake. • Collaborate with DevOps/Cloud teams to provision, monitor, and maintain Snowflake environments. • Perform data migration from legacy systems or other cloud data platforms (e.g., Redshift, BigQuery) to Snowflake. • Provide leadership and mentorship to junior data engineers and act as a technical SME for Snowflake. • Stay updated with the latest Snowflake features and best practices and evaluate their applicability. • Expertise in data modeling (dimensional, normalized/denormalized), data warehousing concepts, and star/snowflake schemas. • Excellent problem-solving skills, communication skills, and ability to work independently in a fast-paced environment. • Understanding of data governance, privacy (GDPR/CCPA), and security best practices. • Knowledge of CI/CD pipelines, Git, and DevOps practices for data environments. Required Skills: Data, SnowFlake, BI Tool, Banking Domain Thanks Rakesh Pathak | Senior Technical Recruiter Phone: 609-360-2642 Rakesh.pathak@ampstek.com