Snowflake Data Engineer (Only W2)

<>Job Summary

We are seeking an experienced Senior Snowflake Data Engineer / SQL Database Administrator with strong expertise in Snowflake architecture, administration, data engineering, and SQL Server database management. The ideal candidate will have extensive experience designing, implementing, optimizing, and supporting enterprise data platforms while also managing SQL Server environments in a DBA capacity.

<>Required Skills & Experience

Snowflake Data Engineering & Administration (Must Have)

• 5+ years of hands-on experience with Snowflake across implementation, administration, development, optimization, and ongoing platform management.
• Strong expertise in Snowflake architecture, virtual warehouses, storage management, security, and access controls.
• Experience designing and building scalable data pipelines and ETL/ELT processes within Snowflake.
• Expertise in performance tuning, query optimization, workload management, and cost optimization.
• Experience implementing Snowflake best practices for data governance, security, and monitoring.
• Hands-on experience with Snowflake features including:
  • Streams & Tasks
  • Snowpipe
  • Data Sharing
  • Time Travel
  • Zero-Copy Cloning
  • Secure Views
  • Role-Based Access Control (RBAC)

Data Engineering & Data Management

• 10+ years of overall experience in Data Engineering, Data Warehousing, and Data Management.
• Strong background in designing and supporting enterprise data platforms.
• Experience with data modeling, data integration, ETL/ELT frameworks, and data quality processes.
• Expertise in SQL development and complex query design.
• Experience working with structured and semi-structured data formats (JSON, XML, Parquet).

SQL Server Administration

• Strong SQL Server Database Administration experience.
• Experience managing SQL Server environments including:
  • Database installation and configuration
  • Backup and recovery strategies
  • Disaster recovery planning
  • Performance monitoring and tuning
  • Database security and user management
  • Capacity planning and troubleshooting
• Experience supporting production SQL Server environments and ensuring high availability.

Preferred Qualifications

• Experience with cloud platforms such as Azure, AWS, or Google Cloud Platform.
• Experience with data integration tools and orchestration frameworks.
• Knowledge of CI/CD, DevOps, and Infrastructure-as-Code practices.
• Familiarity with database migration projects from legacy platforms to Snowflake.
• Snowflake certifications are highly preferred.

<>Responsibilities

• Design, build, and maintain Snowflake-based enterprise data solutions.
• Administer and optimize Snowflake environments for performance, scalability, and cost efficiency.
• Manage SQL Server databases and ensure availability, security, and reliability.
• Develop and support enterprise data pipelines and data integration processes.
• Monitor database health, troubleshoot issues, and implement corrective actions.
• Collaborate with architects, developers, analysts, and business stakeholders to deliver data solutions.
• Establish and enforce data governance, security, and operational best practices.
• Support data migration and modernization initiatives.

<>Nice to Have

• Experience with Azure Data Factory, Informatica, Matillion, dbt, or similar tools.
• Experience with Power BI, Tableau, or other reporting platforms.
• Knowledge of Data Lake and Lakehouse architectures.