Lead Snowflake DBA: Optimize Performance & Security

Macmillan; New York (NY); Hybrid; USD 114,000 - 162,000; Full time

Job summary

Macmillan Publishers seeks an experienced Lead Snowflake DBA to join the Data Engineering team. You'll optimize the Snowflake data warehouse, implement security policies, and mentor junior DBAs.

Ideal candidates have 5+ years as a DBA, Snowflake expertise, strong SQL, data modeling, and cloud platform experience with AWS, Azure, or GCP. This role supports a next‑gen data environment and cost‑aware performance tuning.

Qualifications

• Bachelor’s degree in CS/IT or related field.
• 5+ years DBA experience, with at least 2 years Snowflake.
• Experience leading a team or mentoring.
• Strong SQL, data modeling, and ETL skills.
• Cloud knowledge (AWS/Azure/GCP) with Snowflake integrations.

Responsibilities

• Oversee Snowflake data warehouse administration, performance, security, and reliability.
• Design and monitor data security and access policies.
• Collaborate with analysts and engineers to meet data needs.
• Regularly analyze Snowflake usage and tuning for cost efficiency.
• Lead migrations, schema design, and ETL projects.
• Mentor junior DBAs and document architectures and processes.

Skills

Snowflake

SQL

Data modeling

ETL skills

Cloud platforms

Git

Python

SSO configuration

Role hierarchies

Team mentorship

Education

Bachelor's degree in Computer Science / IT

Tools

Snowflake

ETL tools

Job description

Macmillan Publishers seeks an experienced Lead Snowflake DBA to join the Data Engineering team. You'll optimize the Snowflake data warehouse, implement security policies, and mentor junior DBAs.

Ideal candidates have 5+ years as a DBA, Snowflake expertise, strong SQL, data modeling, and cloud platform experience with AWS, Azure, or GCP. This role supports a next‑gen data environment and cost‑aware performance tuning.