Description

You will design and implement data structures and storage blueprints within the Snowflake platform to meet business requirements.

Responsibilities

• Design overall data structures utilizing Snowflake features like data sharing, scalability, and secure data exchange.
• Optimize data pipelines, workflows, and queries for performance, scalability, and cost-efficiency.
• Develop ETL/ELT processes and integrate Snowflake with cloud services, third-party tools, and on-premises systems.
• Implement security strategies including encryption, role-based access control (RBAC), and data masking to protect sensitive data.
• Automate administrative tasks using Snowflake SQL and scripting languages such as Python or Shell.

Required Skills

• 8+ years of experience in data modeling, integration, warehousing, governance, and security.
• Expertise in Snowflake architecture, including Databases, Procedures, Tasks, Streams, and cloning capabilities.
• Proficiency in managing Snowflake warehouses, optimizing query execution, and usage tracking.
• Hands-on experience with Snowflake RBAC, SSO integration, and SCIM implementation.
• Experience with Oracle and/or PostgreSQL in HA deployments.
• Proficiency with data integration tools including Informatica 10.5 and Azure Data Factory (ADF).
• Experience developing reports in Cognos Analytics 11.1.
• Technical writing and diagramming skills using Visio, Erwin, and Microsoft Office Suite.
• Experience working in Agile sprint teams using JIRA.

Preferred Skills

• Familiarity with CI/CD pipelines, version control, Azure, and HL7 data.
• Prior experience in the Healthcare industry, HHS agencies, or handling PII/PHI data.

Key Skills

Education

Bachelor’s degree in computer science, Information Systems