Snowflake Data Engineer job in Cincinnati

TriOptus LLC
Cincinnati, United States of America
6 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Cincinnati, United States of America

Tech stack

Query Performance
Agile Methodologies
Amazon Web Services (AWS)
Apache HTTP Server
Databases
Data Governance
Data Infrastructure
Data Mart
Data Transformation
Data Migration
Data Sharing
Data Systems
Data Warehousing
Relational Databases
DevOps
Monitoring of Systems
Python
Kerberos (Protocol)
Key Management
Log Analysis
OAuth
OpenID
Performance Tuning
Cloud Services
Security Assertion Markup Language (SAML)
Software Deployment
Data Streaming
Enterprise Data Management
Scripting (Bash/Python/Go/Ruby)
Cloud Platform System
System Availability
Snowflake
Kafka
Data Lakehouse
Cloud Migration
Data Pipelines

Job description

  • Work in a globally distributed team to provide robust enterprise data platform in Snowflake
  • Design, optimize, document, and implement the operational aspects in supporting the snowflake cloud data platform. Including cost monitoring and optimizations, user security auditing
  • Implement/support automation for production deployment in Snowflake
  • Implement Snowflake standards and methodologies for DB security - both infrastructure and app level
  • Implement/support automation for administering Snowflake - Accounts/Databases and access roles
  • Implement data sharing /replication - cross cloud/cross region for internal/external clients
  • Create Snowflake utilization and capacity plan
  • Propose and implement DB / Snowflake query performance optimizations.
  • Identify system bottlenecks and recommend solutions
  • Implement Snowflake user /query log analysis and alerts
  • Implement data encryption/decryption/masking policies to protect PII/PCI data
  • Work as admin on Snowflake on AWS i.e., Configuration, Data migration and security

Requirements

  • Our financial services client is seeking an experienced Snowflake Architect / Data Platform Architect to support enterprise data platform initiatives. The ideal candidate will bring deep expertise in Snowflake architecture and administration, strong AWS experience, and the ability to evaluate and recommend scalable data solutions. This role requires a solution-oriented professional who can assess broader project objectives, conduct technical research, and provide architectural guidance across multiple data platform initiatives., * 5+ years of hands-on experience with AWS Cloud Services.
  • Strong expertise as a Snowflake Architect, Snowflake Administrator, or Data Platform Architect.
  • Experience designing, implementing, and optimizing enterprise-scale Snowflake environments.
  • Ability to evaluate multiple technical approaches and recommend optimal solutions based on business requirements.
  • Strong understanding of data platform architecture, governance, security, scalability, and performance optimization.
  • Experience participating in technical discovery, architecture reviews, and R&D discussions.
  • Excellent communication and stakeholder management skills.
  • Ability to understand business objectives and align technical solutions with organizational goals.

Preferred Qualifications

  • Snowflake Engineering experience.
  • Experience within Financial Services, Banking, or Capital Markets environments.

Knowledge of:

  • Kafka
  • Snowpipe
  • Snowpipe Streaming
  • Apache Iceberg
  • Governance Catalogs
  • Unity Catalog
  • Polaris
  • Experience with modern data lakehouse and data governance frameworks.
  • Ideal Candidate Profile
  • Snowflake SME with strong architectural and administration expertise.
  • Solution-oriented mindset with the ability to evaluate multiple design options.
  • Comfortable working across architecture, engineering, and business teams.
  • Strong analytical and problem-solving skills with a focus on enterprise-scale data solutions.
  • Experience supporting strategic data modernization and cloud transformation, * Experience in implementing Snowflake external functions
  • Experience securing sensitive data PII/PCI data in snowflake
  • Hands-on experience in administering Snowflake in AWS.
  • Experience with AWS CLI and Networking
  • Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
  • Experience with architecting and maintaining high availability production systems
  • Experience with developing monitoring architecture and implementing monitoring agents, dashboards, escalations, and alerts
  • Knowledge of security controls for the public cloud (encryption of data in motion/rest and key management)
  • Demonstrated proficiency of index design, query plan optimization and analysis required
  • Hands-on experience in administration of relational Databases, Data Warehouse and Data marts.
  • Demonstrated knowledge and hands-on experience with AWS alerting/monitoring tools
  • Experience with Agile and DevOps concepts
  • Strong development skills in Python or other scripting language

Added bonus if you have:

  • AWS certification
  • Snowflake Certifications

Required experience (more details to come on supplier call):

AWS - 5+ years

Snowflake - 5+ years

Management Consultant Spclst or similar role: 5+ years

Apply for this position