Snowflake Data Engineer - Hybrid

As a Snowflake Data Engineer, you will design, implement, and optimize enterprise data solutions using a Snowflake-based cloud data platform. You will work closely with cross functional partners to onboard new data sources, build scalable ingestion pipelines, ensure data quality and security, and support analytics and business intelligence initiatives. This role requires strong expertise in cloud data engineering, Snowflake data warehousing, ETL processes, and collaboration with data stewards and technical teams to deliver reliable, high performance data solutions., * Design, develop, and support Snowflake-based data warehouse solutions within a cloud environment.

• Lead and support onboarding of new data sources into the Snowflake data platform.
• Develop system and data requirements for new and existing datasets in collaboration with internal partners.
• Build, automate, and maintain data ingestion pipelines, mappings, transformations, and validations.
• Ensure data quality, integrity, security, and auditability across all data workflows.
• Troubleshoot and resolve data ingestion, transformation, and performance issues.
• Develop and optimize SQL queries, stored procedures, and data models.
• Support quality assurance activities related to data accuracy, consistency, and compliance.
• Collaborate with business intelligence teams to support analytics and reporting solutions.
• Work with data stewards to understand current and future data usage needs and expected outcomes.
• Support API-based data integration and ingestion processes.
• Create and maintain technical documentation for data pipelines, schemas, and processes.

• Minimum 3 years of hands-on experience designing, developing, and supporting Snowflake data warehouses.
• Minimum 5 years of experience working with SQL Server 2012 or later, including complex query development.
• Strong experience developing data solutions in a cloud environment, preferably AWS.
• Demonstrated experience with data modeling, ETL processes, and data warehouse architecture.
• Experience developing ingestion pipelines, data mappings, and transformations.
• Proficiency with SQL optimization, stored procedures, and performance tuning.
• Experience working with data integration tools and RDBMS concepts.
• Experience developing and consuming RESTful APIs.
• Hands-on experience with scripting and automation using Python and PowerShell.
• Strong understanding of data governance, data quality, and security principles.
• Excellent analytical, problem-solving, and troubleshooting skills.
• Strong communication and collaboration skills.
• Bachelor's degree in Computer Science, Public Health, or a related technical field, or equivalent professional experience.

Preferred Skills, Experiences, Education, and Competencies:

• Experience with Snowflake administration and optimization.
• Experience with SQL Server Integration Services and SQL Server Analysis Services.
• Experience with business intelligence development and reporting solutions.
• Experience working with healthcare or public health data.
• Familiarity with database design best practices and enterprise data architecture.

• $110,000-185,000 per year, + La Vergne, TN
• $100,000-110,000 per year