Because this position requires regular on-site work at our Creative Studios in Westlake, Ohio, we will focus on candidates who currently reside in Northeast Ohio.
Remote work and relocation assistance are NOT available for this role.
The Senior Snowflake Engineer designs, develops, and supports scalable cloud data solutions that enable analytics, reporting, data integration, and business capabilities across the enterprise. This role serves as a senior technical contributor within our data engineering environment, with primary responsibility for building and optimizing solutions on the Snowflake Data Cloud.
The Senior Snowflake Engineer partners with business, analytics, architecture, application, and data teams to translate business needs into reliable, secure, and high-performing data solutions. This individual will design data models and data pipelines, develop data transformation and integration solutions, optimize Snowflake performance and cost, and help establish engineering standards and best practices.
The successful candidate will combine deep hands-on Snowflake expertise with strong data engineering fundamentals and the ability to understand how data moves through complex business processes. This person will also mentor other engineers and help evolve the organization's cloud data engineering capabilities.
ESSENTIAL DUTIES & RESPONSIBILITIES
• Design, develop, test, deploy, and support scalable data solutions using Snowflake.
• Build and maintain data pipelines that ingest, transform, integrate, and deliver data from enterprise applications, third-party platforms, files, APIs, and other data sources.
• Develop efficient and maintainable SQL and data transformation logic supporting analytics, reporting, operational, and data integration use cases.
• Design and implement logical and physical data models appropriate for analytical and enterprise data workloads.
• Optimize Snowflake workloads for performance, scalability, reliability, and cost, including warehouse sizing and configuration, query performance, storage considerations, and workload management.
• Apply Snowflake capabilities and design patterns appropriately, including areas such as virtual warehouses, stages, streams and tasks, Snowpipe, secure data sharing, cloning, and time travel.
• Partner with data architects, analysts, application teams, and business stakeholders to understand data requirements and translate them into effective technical solutions.
• Understand source-system data and end-to-end business processes to ensure solutions accurately represent business meaning and meet data quality expectations.
• Design solutions that align with enterprise data architecture, integration strategy, security standards, and data governance practices.
• Implement appropriate data security and access-control practices within Snowflake, including role-based access controls and protection of sensitive data.
• Develop and maintain automated testing, monitoring, troubleshooting, and operational support practices for data pipelines and Snowflake solutions.
• Diagnose and resolve production issues involving data quality, pipeline execution, performance, and availability.
• Participate in code reviews and contribute to development, deployment, documentation, and engineering standards.
• Identify opportunities to improve the reliability, maintainability, automation, performance, and cost efficiency of existing data solutions.
• Collaborate with third-party technology providers and implementation partners as needed.
• Provide technical leadership on projects and initiatives involving multiple systems, data domains, and stakeholders.
• Mentor engineers and other technical team members on Snowflake, SQL, data engineering practices, solution design, and troubleshooting.
• Evaluate new Snowflake capabilities and related data technologies and recommend adoption where they provide meaningful business or technical value.
• Produce high-quality technical documentation, including solution designs, data models, data mappings, operational documentation, and engineering standards.
• Work effectively across multiple concurrent projects and production-support priorities.