Snowflake Architect / Snowflake Administrator / Data Platform Architect (W2 Contract)Location: Cincinnati, OH 45249 (Hybrid – 3 Days Onsite, 2 Days Remote)Work schedule and time zone: EST 8-5 dailyOvertime Eligible(Y/N): YWork stoppage eligible (Y/N): NOur 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.Required Qualifications: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:KafkaSnowpipeSnowpipe StreamingApache IcebergGovernance CatalogsUnity CatalogPolarisExperience 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 transformationAbout the team:Client is in Cloud Data Platform team provides big data capabilities including large scale data processing, analytics, fraud platforms, machine learning engineering, stream processing and data insights.
Cloud Data Platform team help maintain and advance cloud data platforms and services to build data products powering our business services and customers.What you will be doing:Work in a globally distributed team to provide robust enterprise data platform in SnowflakeDesign, optimize, document, and implement the operational aspects in supporting the snowflake cloud data platform. Including cost monitoring and optimizations, user security auditingImplement/support automation for production deployment in SnowflakeImplement Snowflake standards and methodologies for DB security – both infrastructure and app levelImplement/support automation for administering Snowflake - Accounts/Databases and access rolesImplement data sharing /replication – cross cloud/cross region for internal/external clientsCreate Snowflake utilization and capacity planPropose and implement DB / Snowflake query performance optimizations.Identify system bottlenecks and recommend solutionsImplement Snowflake user /query log analysis and alertsImplement data encryption/decryption/masking policies to protect PII/PCI dataWork as admin on Snowflake on AWS i.e., Configuration, Data migration and securityWhat you bring:Technical expertise in all aspects of SnowflakeExperience in implementing Snowflake external functionsExperience securing sensitive data PII/PCI data in snowflakeHands-on experience in administering Snowflake in AWS.Experience with AWS CLI and NetworkingKnowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)Experience with architecting and maintaining high availability production systemsExperience with developing monitoring architecture and implementing monitoring agents, dashboards, escalations, and alertsKnowledge 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 requiredHands-on experience in administration of relational Databases, Data Warehouse and Data marts.