Allied Consultants

Snowflake Administrator

Allied Consultants$100K — $130K *
Information Technology
8 - 10 years of experience
Job Overview by Ladders

Qualifications

  • 8+ years of hands-on experience as a Snowflake Administrator or DBA.
  • Strong expertise in implementing RBAC and data access governance.
  • Proficient in integrating Single Sign-On (SSO) solutions like Okta or SailPoint.
  • Experience enabling AI functions using Snowflake Cortex.
  • Solid skills in designing Snowflake roles, privileges, and user provisioning processes.
  • Capability in building data pipelines and transformations with DBT.
  • Knowledge of monitoring and optimizing warehouse performance and costs.

Responsibilities

  • Manage and optimize the Snowflake platform for performance and security.
  • Develop and implement RBAC for data access governance.
  • Integrate SSO solutions to streamline user authentication processes.
  • Enable Snowflake AI features and support related capabilities.
  • Design user roles and maintain provisioning aligned with IAM processes.
  • Build and support data transformation workflows using DBT.
  • Collaborate with data engineering and AI teams to meet analytic use cases.

Benefits

  • Opportunities for professional growth and technical development.
  • Collaborative team environment with high-impact projects.
  • Access to cutting-edge technologies and tools.
  • Potential for flexible work arrangements.
Full Job Description
Overview

We are currently seeking an experience Snowflake Adminsitrator to play a key role within a high-impact technical services team.

Responsibilities

Level Description

8 or more years of experience, relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

Job Description

Understands business objectives and problems, identifies alternative solutions, performs studies and cost/benefit analysis of alternatives. Analyzes user requirements, procedures, and problems to automate processing or to improve existing computer system: Confers with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be; summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews computer system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system.

Additional job details and special considerations

Snowflake Administrator responsible for managing and optimizing the Snowflake platform, including RBAC, SSO integration, and enterprise data governance. Enables AI capabilities using Snowflake Cortex while supporting data pipelines with DBT and Openflow. Ensures secure, scalable, and cost-efficient data platform operations across environments.

Qualifications

Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

Years

Required/Preferred

Experience

8

Required

Strong hands-on experience administering Snowflake platform (DBA/Admin role)

8

Required

Experience implementing RBAC and data access governance

8

Required

Experience with SSO integration (Okta, SailPoint)

8

Required

Enable and support Snowflake AI (Cortex) features, including AI functions, governance, and monitoring

8

Required

Design and manage Snowflake roles, privileges, and user provisioning aligned with enterprise IAM processes

8

Required

Build and support data pipelines and transformations using DBT

8

Required

Integrate Snowflake with Openflow (or similar orchestration tools) for workflow automation

8

Required

Monitor and optimize warehouse performance, cost, and query execution

8

Required

Implement security controls including encryption, masking, and audit monitoring

8

Required

Develop automation scripts for provisioning, monitoring, and maintenance

8

Required

Collaborate with data engineers, analysts, and AI teams to support data and analytics use cases

4

Preferred

Experience with DevOps / CI-CD pipelines for data platforms

3

Preferred

Experience integrating Openflow or workflow orchestration tools

3

Preferred

Familiarity with public sector or healthcare compliance environments

About Allied Consultants

Allied Universal is an American provider of security systems and services; janitorial services; and staffing. The company was formed in 2016 by the merger of Santa Ana, California-based security and janitorial services company Universal Services of America, and Conshohocken, Pennsylvania-based security firm AlliedBarton Security Services. At the time of the merger, the combined company was reportedly the largest provider of security guards in the United States, with 140,000 trained officers between the two companies. In October 2021, Allied Universal completed a $5.1 billion takeover of British security firm G4S, creating a combined company of 800,000 employees, with revenues of more than $18 billion USD. The company maintains two corporate headquarters, one is in Santa Ana, California and the main headquarters is in Conshohocken, Pennsylvania.
Learn more about Allied Consultants

Similar Jobs

More Jobs at Allied Consultants

More Information Technology Jobs

Find similar Snowflake Administrator jobs: