Overseas Contractor

LTM; Cincinnati (OH); In loco; USD 120.000 - 170.000; Tempo pieno

Descrizione del lavoro

LTM in Cincinnati, OH is seeking a seasoned Snowflake Administration Technical Lead to own the Snowflake platform across development, test, and production accounts. You will drive security controls, cost governance, performance tuning, and ensure high availability while coordinating with onshore/offshore teams and data engineering to deliver secure, scalable data services.

Effective leadership, incident management, and hands-on experience with Snowflake upgrades and FinOps are essential to

Competenze

• Experience 8-12 years in Snowflake administration across development, test and production.
• Strong ownership of RBAC, security controls, and account governance for Snowflake environments.
• Proven incident management and production support experience.

Mansioni

• Own day-to-day Snowflake platform administration including availability, security, performance, cost governance.
• Lead incident resolution, root cause analysis, change implementation, upgrades and disaster recovery exercises.
• Partner with data engineering, cybersecurity, cloud/network and vendor teams to deliver stable and secure platform services.
• Drive automation of access requests, monitoring, operational checks and recurring support processes.

Conoscenze

Snowflake Admin

Performance tuning

Cost optimization

Security controls

Upgrades & migrations

Strumenti

Informatica PowerCenter

Informatica IDM/ICS

Descrizione del lavoro

Role Description

Snowflake Administration Technical Lead

Job Description

Experience 8 - 12 Years

Location Cincinnati Ohio, US

Technical Skills Primary Snowflake Administration

• Strong handson experience administering enterprise Snowflake environments across development test and production accounts
• Expertise in Snowflake account setup and administration including roles and RBAC users warehouses databases schemas objects network policies resource monitors and account parameters
• Strong knowledge of Snowflake security controls including SSOSAML OAuth SCIM provisioning MFA keypair authentication masking policies row access policies secure views and leastprivilege access
• Experience with performance tuning and workload optimization using query profiles query history warehouse sizing and scaling multicluster warehouses clustering search optimization caching and effective SQL tuning
• Proven experience in Snowflake FinOps and cost optimization including creditconsumption analysis warehouse governance autosuspendautoresume resource monitoring storage optimization chargebackshowback and cost anomaly handling
• Handson experience with operational monitoring incident management rootcause analysis capacity planning platform health checks and SLAdriven production support
• Experience managing Snowflake data loading and integration capabilities including stages file formats COPY commands Snowpipe streams tasks dynamic tables and secure data sharing
• Strong understanding of backup and recovery capabilities including Time Travel Failsafe zerocopy cloning replication failover groups and business continuitydisaster recovery planning
• Experience in Snowflake upgrades and feature enablement releaseimpact assessment platform hardening vulnerability remediation and auditcompliance support
• Experience with cloud platforms preferably Microsoft Azure or AWS and integration with cloud storage identity networking secrets management and monitoring services
• Ability to lead the Snowflake administration function coordinate onshoreoffshore support review technical changes enforce standards and act as the primary point of contact for businesscritical issues

Technical Skills Secondary Informatica Administration

• Handson experience administering Informatica PowerCenter andor Informatica Intelligent Data Management Cloud IDMCIICS environments
• Experience with Informatica domain repository integration services nodes grids Secure Agents runtime environments connections schedules users roles and licenses
• Experience monitoring workflows jobs services and Secure Agents troubleshooting failures connectivity issues resource bottlenecks and platform availability incidents
• Experience working with application ETL database infrastructure network and vendor teams to resolve crossplatform production issues

Technical Skills Additional Nice To Have

• Experience with ServiceNow ITILbased incidentchangeproblem management Git CICD pipelines and infrastructure or configuration automation
• Exposure to Snowflake Cortex Snowpark Native Apps Marketplace Horizon Catalog and modern data governanceobservability capabilities
• Knowledge of Tableau Cognos Power BI Oracle or other enterprise data and reporting platforms
• Experience in the Insurance or Financial Services domain and in regulated enterprise environments

Key Responsibilities

• Own daytoday Snowflake platform administration availability security performance cost governance compliance and productionsupport activities
• Lead incident resolution rootcause analysis problem management change implementation upgrades patching and disasterrecovery exercises
• Partner with data engineering application cybersecurity cloud network and vendor teams to deliver stable and secure platform services
• Drive automation of access requests monitoring operational checks housekeeping deployment and recurring support processes
• Provide technical leadership to the offshore administration team review work quality maintain runbooks and ensure adherence to SLAs and enterprise standards

Qualifying Questions

• Does the candidate have at least 10 years of overall experience with strong handson experience in Snowflake Administration and production support
• Does the candidate have at least 6 years of handson experience in Snowflake Administration and production support
• Does the candidate have experience handling critical production issues troubleshooting platform problems and coordinating with multiple technical teams
• Does the candidate have experience leading technical teams interacting with client stakeholders and managing onshoreoffshore delivery