Our client is seeking a Systems Analyst 3 to provide the services below. The position will be 4 days remote with 1 day (Tuesdays) required to be onsite at their location in Austin, Texas. Must reside within the state of Texas.
• Implementation and configuration of the infrastructure for the data integration hub
• Design, development, and implementation (DD&I) of the data integration hub using an agile methodology for all standard SDLC phases that includes, but is not limited to:
• Validation of performance metric requirements
• Creation of Epics/User Stories/Tasks
• Automation of data acquisition from a variety of data sources
• Development of complex SQL scripts
• Testing – integration, load and stress
• Deployment / publication internally and externally
• Operations support and enhancement of the data integration hub
• Strong overall understanding of 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 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.
• Familiarity with CI/CD pipelines and version control for managing Snowflake code deployments.
• Experience working with data integration tools like Informatica and ADF for seamless ETL/ELT processes.
• Ability to automate administrative tasks using Snowflake SQL and scripting languages like 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.
• All other duties as assigned.
| Minimum Requirements: | ||
| Years | Required/Preferred | Experience |
| 8 | Required | Strong overall understanding of 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 | Familiarity with CI/CD pipelines and version control for managing Snowflake code deployments. |
| 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 diagraming 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 |
| 6 | Preferred | Proven ability to write well designed, testable, efficient code by using best software development practices |
| 4 | Preferred | Understanding of security principles and how they apply to healthcare data |
| 4 | Preferred | Experience with state of the art software components for a performance metrics data visualization or business intelligence environment |
| 4 | Preferred | Excellent oral and written communication skills. |
| 4 | Preferred | Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required. |
| 4 | Preferred | Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience. |
| 3 | Preferred | Prior experience in the Healthcare Industry |
| 2 | Preferred | Prior experience with an HHS agency |
| 2 | Preferred | Prior experience working with PII or PHI data |
| 2 | Preferred | Prior experience working with HL7 data |
| 2 | Preferred | Prior experience with Azure |