Snowflake Database Administrator

Beacon Systems - Austin, TX

Full-time - Mid Level

Hybrid - Austin, TX

Professional, Scientific, and Technical Services

About the position

The Snowflake Database Administrator at Beacon Systems, Inc. is responsible for the implementation, configuration, and operational support of a data integration hub for the HHS. This role involves working within an agile development team to design, develop, and implement solutions that enhance data integration processes. The position requires a strong understanding of Snowflake architecture and hands-on experience with various Snowflake components, ensuring efficient query execution and secure access management.

Responsibilities

• Implementation and configuration of the infrastructure for the data integration hub.
• Design, development, and implementation of the data integration hub using agile methodology.
• Validation of performance metric requirements.
• Creation of Epics/User Stories/Tasks.
• Automation of data acquisition from various 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.
• Monitoring and troubleshooting Snowflake environments.

Requirements

• 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).
• 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.

Nice-to-haves

• Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin).
• Experience on an agile sprint team.
• Experience with JIRA software.
• Understanding of security principles and how they apply to healthcare data.
• 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.

Benefits

• Hybrid work environment (4 days remote, 1 day onsite).
• Opportunity to work on significant projects for federal and state agencies.