Remote Snowflake DBA — Enterprise Data Warehouse Specialist

TEKsystems; Lansing (MI); Remote; USD 96,000 - 121,000; Full time

Benefits offered by this job

Medical, dental & vision

401(k) Retirement Plan

Paid time off

Job summary

TEKsystems is seeking a skilled Snowflake Administrator/DBA to support the HAP/IDAP Enterprise Data Warehouse on the Azure cloud stack. You will optimize Snowflake environments, collaborate with ETL, architecture, and security teams, and ensure secure, auditable, high-performing workloads used by Power BI dashboards and analytics.

The role emphasizes SQL tuning, access control, data quality, and regulatory compliance, with a fully remote contract basis out of Lansing, MI.

Qualifications

• 5+ years of database admin/EDW operations or related role.
• 3+ years Snowflake admin/engineering experience: objects, warehouses, roles, grants, tuning.
• Azure/AWS cloud data platforms experience with emphasis on Azure services.
• Strong SQL skills: performance tuning, DDL/DML, stored procedures.
• RBAC, SSO, encryption, auditing, data masking, least-privilege.

Responsibilities

• Administer Snowflake databases, warehouses, stages, formats, streams, tasks, and access controls.
• Support secure ingestion/processing of Medicaid/HHS data via Azure: ADLS, ADF, Databricks, Snowflake.
• Create/maintain structures for staging, integration, curated data, reporting, QA, and dashboards.
• Tune Snowflake SQL, stored procedures, transformations for Power BI and HAP Portal dashboards.
• Assist with security, compliance, audit evidence, and DR planning.

Skills

Snowflake

SQL

Azure

Power BI

Databricks

Purview

ETL

Git

Databricks

Tools

Azure Data Factory

Snowflake

Job description

TEKsystems is seeking a skilled Snowflake Administrator/DBA to support the HAP/IDAP Enterprise Data Warehouse on the Azure cloud stack. You will optimize Snowflake environments, collaborate with ETL, architecture, and security teams, and ensure secure, auditable, high-performing workloads used by Power BI dashboards and analytics.

The role emphasizes SQL tuning, access control, data quality, and regulatory compliance, with a fully remote contract basis out of Lansing, MI.