Job Role : Snowflake Architect
Location : Austin, Texas (Hybrid)
Duration : 9+ Month
Type : Contract
- Note : Position will be 4 days remote with 1 day (Tuesdays) required to be onsite at the location701 W 51st St Austin, Texas 78751
- Job Description : 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
- This development effort will utilize an agile methodology based upon the approach currently in use at HHSC for the Texas Integrated Eligibility Redesign System (TIERS).
As a member of the agile development team, the worker responsibilities may include :
- 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.
- Required Skills : 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.
- 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.
- Experience on an agile sprint team
- Experience with JIRA software
- Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality
- Preferred Skills : Proven ability to write well designed, testable, efficient code by using best software development practices
- Understanding of security principles and how they apply to healthcare data
- Experience with state of the art software components for a performance metrics data visualization or business intelligence environment
- Excellent oral and written communication skills.
- Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
- Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience.
- 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
1 day ago