| Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. | |||
| Actual Years Experience |
Years Experience Needed |
Required/ Preferred |
Skills/Experience |
| 8 | Required | Experience with data modeling, data integration, data warehousing, data governance, and data security | |
| 8 | Required | Experience with Oracle and/or PostgreSQL in HA deployments and Expertise in data storage | |
| 8 | Required | Proficiency in Snowflake architecture and its components. | |
| 8 | Required | Hands-on experience with Snowflake objects such as Databases, Procedures, Tasks, and Streams. | |
| 8 | Required | Expertise in using Snowflake’s cloning capabilities for databases and schemas. | |
| 8 | Required | Proven experience in managing Snowflake Warehouses and optimizing performance for efficient query execution. | |
| 8 | Required | Proficiency in Snowflake RBAC (Role-Based Access Control), including implementation of roles and privileges. | |
| 8 | Required | Experience with integrating Snowflake SSO (Single Sign-On) and SCIM (System for Cross-domain Identity Management) for secure access and identity management. | |
| 8 | Required | Experience working with data integration tools like Informatica and ADF for seamless ETL/ELT processes. | |
| 8 | Required | Ability to automate administrative tasks using Snowflake SQL and scripting languages like Python or Shell scripting. | |
| 8 | Required | Expertise in monitoring and troubleshooting Snowflake environments, including usage tracking and query profiling. | |
| 8 | Required | Strong understanding of Snowflake’s security features such as data masking, encryption, and network policies. | |
| 8 | Required | Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project. | |
| 8 | Required | Experience on an agile sprint team | |
| 8 | Required | Experience with JIRA software | |
| 8 | Required | Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality | |
| 8 | Required | Knowledge of Informatica 10.5 | |
| 8 | Required | Developing reports in Cognos Analytics 11.1 | |
| 5 | Preferred | Familiarity with CI/CD pipelines and version control for managing Snowflake code deployments. | |
| 5 | Preferred | Prior experience in the Healthcare Industry | |
| 5 | Preferred | Prior experience with an HHS agency | |
| 5 | Preferred | Prior experience working with PII or PHI data | |
| 5 | Preferred | Prior experience working with HL7 data | |
| 5 | Preferred | Prior experience with Azure | |
| 4 | Preferred | Bachelor's degree in computer science, Information Systems, or Business or equivalent experience. | |