We are seeking a skilled and motivated Snowflake Administrator / DBA to support the Health Analytics Program and Integrated Data Analytics Platform (HAP/IDAP) Enterprise Data Warehouse effort. This role will help administer and optimize the Snowflake data warehouse environment that supports Medicaid, Medicare, EUTF, provider, recipient, claims, encounter, eligibility, operational KPI, data quality, portal, and reporting workloads. The administrator will work closely with delivery, architecture, ETL, DevOps, security, QA, business analysis, and State stakeholders to maintain a secure, scalable, auditable, and high-performing analytics platform built on Snowflake, Azure, Azure Data Factory, Azure Databricks, Power BI, Microsoft Purview, and related cloud services.
Primary Responsibilities:
Administer Snowflake databases, schemas, warehouses, stages, file formats, streams, tasks, procedures, access roles, grants, masking policies, and operational objects supporting the EDW/HAP platform.
Support secure ingestion and processing of Medicaid and HHS data from external providers and source systems through Azure Data Lake Storage, Azure Data Factory, Azure Databricks, and Snowflake.
Create and maintain database structures for staging, integration, curated, consumption, reporting, data quality, MDM, Golden Record, and dashboard-facing schemas.
Configure and manage Snowflake warehouses for workload isolation, concurrency, auto-suspend, auto-resume, multi-cluster scaling, and cost-effective performance.
Monitor credit consumption, query execution, warehouse utilization, queueing, failed jobs, abnormal activity, and operational performance trends; recommend tuning or capacity changes through change control.
Partner with ETL developers, data architects, report developers, QA, and business analysts to tune Snowflake SQL, stored procedures, transformations, and reporting queries used by Power BI and HAP Portal dashboards.
Support role-based access control, least-privilege security, SSO integration, user provisioning, account lifecycle management, privileged access controls, and periodic access reviews.
Implement and validate controls for PHI, PII, HIPAA, Medicaid data security, encryption, logging, auditing, masking, and regulatory compliance requirements.
Coordinate with security, compliance, and audit teams to provide evidence, resolve findings, support penetration test remediation, and maintain auditability of administrative actions and data access.
Support Snowflake Time Travel, Fail-safe recovery coordination, replication validation where enabled, disaster recovery planning, tabletop testing, and recovery documentation for HI HAP/IDAP.
Assist with data quality framework operations, including configuration tables, rule execution support, results validation, troubleshooting, and integration with ADF master pipelines.
Participate in requirements, JAD, release planning, troubleshooting, incident response, and implementation readiness sessions to ensure Snowflake platform needs, dependencies, risks, and constraints are clearly understood.
Document operational procedures, runbooks, configuration decisions, capacity assumptions, deployment steps, monitoring processes, and administrative standards.

To be considered for this position, applicants need to meet the qualifications listed in this posting.
Required Qualifications:
5+ years of experience in database administration, data warehouse operations, cloud data platform support, or a closely related technical role.
3+ years of hands-on Snowflake administration or engineering experience, including database objects, warehouses, roles, grants, performance tuning, monitoring, and operational support.
Experience supporting cloud-based data platforms on Azure or AWS, with preference for Azure Commercial Cloud, Azure Data Factory, Azure Data Lake Storage, Azure Databricks, and related networking/security concepts.
Strong SQL skills, including performance analysis, query optimization, DDL, DML, stored procedures, views, and troubleshooting complex data warehouse workloads.
Working knowledge of role-based security, SSO, account management, encryption, auditing, logging, data masking, PHI/PII protection, and least-privilege access control.
Understanding of enterprise data warehouse concepts, including staging, integration, curated data layers, dimensional modeling, data marts, metadata, lineage, data quality, and reporting consumption patterns.
Experience troubleshooting database connectivity issues using Snowflake connectors, ODBC/JDBC drivers, BI tools, ETL tools, Python, SQL clients, or cloud-based services.
Experience supporting production operations, incident response, change control, release validation, backup/recovery testing, disaster recovery planning, and operational documentation.
Ability to work effectively with architects, ETL engineers, QA leads, business analysts, DevOps engineers, security teams, project managers, client stakeholders, and vendors.
Excellent written and verbal communication skills, with strong attention to detail and the ability to translate technical risks, dependencies, and operational needs into clear delivery guidance.

Preferred Qualifications:

Experience with Power BI, Microsoft Purview, Azure DevOps, CI/CD, Terraform, Git, Python, shell scripting, Snowpark, Snowpipe, streams, tasks, and Snowflake cost/performance governance.
Experience with Informatica, Azure Data Factory, Databricks, or healthcare ETL frameworks supporting high-volume data ingestion, transformation, reconciliation, restartability, and audit controls.
Knowledge of Medicaid reporting, CMS data needs, T-MSIS, MARS-E, HIPAA, NIST 800-53, HITRUST, FedRAMP/StateRAMP concepts, Section 508/ADA accessibility considerations, and public-sector audit evidence expectations.
Experience supporting data quality frameworks, master data management, provider Golden Record, reference data, metadata management, lineage, cataloging, and data governance processes.
Snowflake certification, Azure certification, or equivalent demonstrated experience in cloud data platform administration.

This is a remote position.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.

(if you already have a resume on Indeed)

Or apply here.

* required fields

First Name*

Last Name*

Email*

Phone*

Text me updates about my application

Yes No

Message and data rates may apply. Message frequency varies. Reply STOP to opt out. Reply HELP for help. See our User Terms of Service and Privacy Policy for details.

Location

Address

City

States

ZIP Code

Resume/CV (optional)

Type/Paste Text

Cover Letter

Type/Paste Text

Recent Job Title

Recent Employer

U.S. Equal Opportunity Employment Information (Completion is voluntary)

You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Gender

Race/Ethnicity

Disability Status

Form CC-305
OMB Control Number 1250-0005
Expires 4/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

Alcohol or other substance use disorder (not currently using drugs illegally)
Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
Blind or low vision
Cancer (past or present)
Cardiovascular or heart disease
Celiac disease
Cerebral palsy
Deaf or serious difficulty hearing
Diabetes
Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
Epilepsy or other seizure disorder
Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
Intellectual or developmental disability
Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
Missing limbs or partially missing limbs
Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
Partial or complete paralysis (any cause)
Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
Short stature (dwarfism)
Traumatic brain injury

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Veteran Status

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Referral code from a current employeeIf no code provided, add their name instead.

Snowflake DBA

Or apply here.