Contractor Snowflake Developer

Responsibilities :

• Design the overall data structure, ensuring that Snowflake s features (e.g., data sharing, scalability, secure data exchange) are fully leveraged to meet business requirements.
• Create a blueprint for how data will be stored, processed, and accessed within the Snowflake platform.
• Optimize data pipelines and workflows for performance, scalability, and cost-efficiency.
• Design ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes, and optimize queries and data storage strategies.
• Integrate with other cloud services (e.g., AWS, Azure, Google Cloud Platform), third-party tools, and on-premises data systems.
• Design and implement strategies to control access to sensitive data, applying encryption, role-based access control, and data masking as needed.
• Collaborate with data engineers, data scientists, business analysts, and other stakeholders to understand requirements and ensure the Snowflake environment meets those needs.
• Monitor the performance of the Snowflake environment, identify bottlenecks, and ensure optimal query performance.
• Automate administrative tasks using Snowflake SQL and scripting languages such as Python or Shell scripting.
• Perform data loading methods, including bulk loading using COPY INTO, real-time ingestion with Snowpipe, and managing external tables.
• Utilize Snowflake s cloning capabilities for databases and schemas.
• Configure and manage Snowflake Virtual Warehouses, including scaling, resizing, and setting auto-suspend/resume.
• Implement roles and privileges for managing secure access using Snowflake s RBAC (Role-Based Access Control).
• Integrate Snowflake SSO (Single Sign-On) and SCIM (System for Cross-domain Identity Management) for secure access and identity management.
• Configure alerts and monitor data pipeline failures, resource spikes, and cost thresholds.

Experience Requirements: 8 years

• Experience with data modeling, data integration, data warehousing, data governance, and data security.
• Experience with Oracle and/or PostgreSQL in High Availability (HA) deployments and expertise in data storage.
• Proficiency in Snowflake architecture and its components.
• Hands-on experience with Snowflake objects such as Databases, Procedures, Tasks, and Streams.
• Expertise in using Snowflake s cloning capabilities for databases and schemas.
• Proven experience in managing Snowflake Warehouses and optimizing performance for efficient query execution.
• Proficiency in Snowflake RBAC (Role-Based Access Control), including the implementation of roles and privileges.
• Experience with integrating Snowflake SSO (Single Sign-On) and SCIM (System for Cross-domain Identity Management) for secure access and identity management.
• Experience working with data integration tools like Informatica and Azure Data Factory (ADF) for seamless ETL/ELT processes.
• Ability to automate administrative tasks using Snowflake SQL and scripting languages such as Python or Shell scripting.
• Expertise in monitoring and troubleshooting Snowflake environments, including usage tracking and query profiling.
• Strong understanding of Snowflake s security features such as data masking, encryption, and network policies.
• Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin) and the Microsoft Office Suite (Word, Excel, PowerPoint) and MS Project.
• Experience on an agile sprint team.
• Experience with JIRA software.
• Experience working with multiple teams concurrently, with the ability to prioritize and complete work on time with high quality.
• Knowledge of Informatica 10.5.
• Experience developing reports in Cognos Analytics 11.1.

Preferred Experience: 5 years

• Familiarity with CI/CD pipelines and version control for managing Snowflake code deployments.
• Prior experience in the Healthcare Industry.
• Prior experience with an HHS agency.
• Prior experience working with PII or PHI data.
• Prior experience working with HL7 data.
• Prior experience with Azure.

Bachelor s degree in Computer Science, Information Systems, Business, or equivalent experience.