Snowflake Administrator / Senior Snowflake Platform Engineer

BCforward; Cincinnati (OH); Vor Ort; USD 158.000 - 161.000; Teilzeit

Zusammenfassung

BCforward is seeking a Senior Snowflake Platform Engineer to join our Cincinnati team. You will own Snowflake administration, optimize queries, configure RBAC, and drive cost optimization across the enterprise data platform.

The role focuses on secure, reliable operations, incident handling, and collaborating with engineering, security, and business teams on platform upgrades and new capabilities.

Qualifikationen

• Extensive hands-on experience administering Snowflake in a production environment.
• Strong knowledge of Snowflake architecture, virtual warehouses, micro-partitions, caching, and resource consumption.
• Advanced SQL skills with experience diagnosing and resolving performance issues.
• Experience implementing Snowflake RBAC, role hierarchies, grants, access policies, and secure access patterns.
• Experience with warehouse sizing, workload management, cost monitoring, and compute optimization.
• Understanding of database administration, data governance, and enterprise security practices.

Aufgaben

• Own day-to-day Snowflake administration, including user and role management, access controls, warehouse configuration, resource monitoring, and operational support.
• Analyze and optimize query performance, warehouse utilization, concurrency, and compute costs using Snowflake monitoring and account usage capabilities.
• Implement and maintain RBAC, least-privilege access, service accounts, authentication integrations, and data protection controls.
• Establish platform standards for warehouse sizing, auto-suspend and auto-resume, resource monitors, workload isolation, and cost management.
• Monitor platform health, investigate incidents, perform root cause analysis, and implement preventative measures to improve reliability.
• Manage database objects and platform hygiene, including schemas, tables, views, retention settings, and obsolete resource cleanup.
• Support data integration and connectivity with AWS services such as S3 and IAM, and relevant ingestion and processing tools.
• Automate administrative tasks and operations using SQL, Python, scripting, and APIs.
• Develop operational dashboards, documentation, and procedures for monitoring, incident response, access reviews, and cost reporting.
• Collaborate with engineering, architecture, security, and business teams on platform architecture, upgrades, new capabilities, and enterprise data initiatives.

Kenntnisse

Snowflake administration

SQL performance tuning

RBAC & security

Cost optimization

Incident resolution

Documentation

Tools

Terraform

Python scripting

AWS S3

Snowflake monitoring

IAM integration

Jobbeschreibung

Job Title: Snowflake Administrator / Senior Snowflake Platform Engineer

Location: Cincinnati OH

Duration: Contract - 2 months

Pay Range: $115/hr to $117/hr (W2)

Job ID: 411273

About BCforward

BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery centers and offices across North America and India, we take pride in building long-term relationships and delivering excellence through innovation, collaboration, and integrity.

Job Description

We are seeking a Senior Snowflake Platform Engineer to join our dynamic team. The ideal candidate will have strong experience in Snowflake administration, SQL performance tuning, RBAC, and cost optimization and a proven ability to ensure a secure, reliable, and efficient enterprise data platform while resolving complex production issues.

Responsibilities

• Own day-to-day Snowflake administration, including user and role management, access controls, warehouse configuration, resource monitoring, and operational support.
• Analyze and optimize query performance, warehouse utilization, concurrency, and compute costs using Snowflake monitoring and account usage capabilities.
• Implement and maintain RBAC, least-privilege access, service accounts, authentication integrations, and data protection controls.
• Establish platform standards for warehouse sizing, auto-suspend and auto-resume, resource monitors, workload isolation, and cost management.
• Monitor platform health, investigate incidents, perform root cause analysis, and implement preventative measures to improve reliability.
• Manage database objects and platform hygiene, including schemas, tables, views, retention settings, and obsolete resource cleanup.
• Support data integration and connectivity with AWS services such as S3 and IAM, and relevant ingestion and processing tools.
• Automate administrative tasks and operations using SQL, Python, scripting, and APIs.
• Develop operational dashboards, documentation, and procedures for monitoring, incident response, access reviews, and cost reporting.
• Collaborate with engineering, architecture, security, and business teams on platform architecture, upgrades, new capabilities, and enterprise data initiatives.

Required Skills & Qualifications

• Extensive hands-on experience administering and supporting Snowflake in a production enterprise environment.
• Strong knowledge of Snowflake architecture, virtual warehouses, micro-partitions, caching, query execution, and resource consumption.
• Advanced SQL skills with demonstrated experience diagnosing and resolving query performance issues.
• Practical experience implementing Snowflake RBAC, role hierarchies, grants, access policies, and secure access patterns.
• Experience with warehouse sizing, workload management, cost monitoring, and compute optimization.
• Experience troubleshooting production incidents and improving platform reliability.Understanding of database administration, data governance, and enterprise security practices.
• Ability to work independently, communicate effectively, and produce clear technical documentation.

Preferred Skills

• Experience integrating Snowflake with AWS S3, IAM, Glue, and enterprise data pipelines.
• Python or shell scripting for automation and administrative tasks.
• Experience with Terraform or other Infrastructure as Code tools.Familiarity with Snowflake resource monitors, ACCOUNT_USAGE and ORGANIZATION_USAGE views, and query history analysis.
• Experience with masking policies, row access policies, network policies, and authentication integrations.
• Knowledge of workload management, multi-cluster warehouses, replication, failover, and business continuity.
• SnowPro Core or Advanced certification.
• Experience in financial services or other regulated enterprise environments.

  Why BCforward?

  • Competitive compensation and benefits.
  • Opportunities for growth with global clients.
  • A supportive, inclusive culture that values innovation and people.
  • Exposure to cutting-edge technologies and projects.

  About Our Commitment

  BCforward is an equal opportunity employer. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or veteran status.