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.
Required Experience:
- 8+ years of professional experience in data engineering, data warehousing, data integration, software engineering, or a closely related discipline.
- Significant hands-on experience designing, developing, and supporting production solutions using Snowflake.
- Advanced SQL skills and demonstrated experience developing complex, production-quality data transformations.
- Experience designing and developing ETL/ELT data pipelines and integrating data from multiple enterprise source systems.
- Experience with dimensional, relational, and/or analytical data modeling.
- Experience troubleshooting and optimizing data-platform performance and production workloads.
- Experience working through the full development lifecycle, including requirements, solution design, development, testing, deployment, monitoring, and production support.
- Experience working collaboratively with technical teams and business stakeholders to translate business requirements into data solutions.
Knowledge, Skills & Abilities:
Required:
- Strong knowledge of Snowflake architecture and core platform capabilities.
- Strong understanding of cloud data warehousing and modern data engineering principles.
- Advanced SQL development and performance-tuning skills.
- Strong understanding of data modeling, data integration, data quality, and data lifecycle concepts.
- Ability to diagnose complex data and performance issues and identify sustainable solutions rather than short-term fixes.
- Understanding of security and access-control concepts applicable to enterprise data platforms.
- Experience with source control and modern software/data engineering development practices.
- Ability to communicate technical concepts effectively to both technical and non-technical audiences.
- Demonstrated ability to independently lead technical work while collaborating effectively within a broader engineering team.
- Ability to mentor other engineers and contribute to engineering standards and best practices.
Preferred:
- Experience with dbt or a comparable data transformation framework.
- Experience with a major cloud platform such as AWS, Azure, or Google Cloud Platform.
- Experience with orchestration and data integration technologies such as Airflow, Matillion, Informatica, Fivetran, Azure Data Factory, or comparable tools.
- Experience using Python for data engineering, automation, or platform tooling.
- Experience implementing CI/CD and automated deployment practices for data solutions.
- Experience with Snowflake governance, security, observability, and cost-management capabilities.
- Experience integrating Snowflake with enterprise applications such as SAP and other ERP, CRM, PLM, retail, supply-chain, or e-commerce platforms.
- Snowflake certification is a plus but is not required.
Bachelor's degree in Computer Science, Information Systems, Engineering, Data/Analytics, or a related discipline, or equivalent relevant professional experience.
Please ensure all information submitted in your application is complete and accurate. Verification of candidate information may be conducted during the hiring process. Candidates who provide false, misleading, or materially inaccurate information, including residence or location information, may be disqualified from consideration.