About this role
DescriptionSnowflake Administrator / DBA Enterprise Data Warehouse Job DescriptionWe 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 client 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 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 supporting State Medicaid, Health and Human Services, MMIS, eligibility, claims, encounter, provider, managed care, EUTF, Medicare, or public-sector healthcare data environments. • Experience with the state HAP/IDAP platform, state EDW operations, or similar Medicaid enterprise analytics programs. • 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. Additional Skills & QualificationsMust have GREAT communication - able to communicate with technical and nontechnical stakeholders Job Type & LocationThis is a Contract position based out of Lansing, MI. Pay and BenefitsThe pay range for this position is $70.00 - $88.00/hr. Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave) Workplace TypeThis is a fully remote position. Application DeadlineThis position is anticipated to close on Oct 22, 2026.
About TEKsystems
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
About TEKsystems and TEKsystems Global Services
Were a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. Were a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. Were strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. Were building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.
Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.