Snowflake (Data Engineer)

Snowflake (Data Engineer)

Location - Nashville, Tennessee

Duration - 12+ Months

Hybrid

This posting is for TN residents only, with a requirement to attend in-person staff meetings at least once monthly. 710 James Robertson Parkway, Nashville, TN 37243.

Key Responsibilities:

• Support development and administration of TDH Snowflake Platform (SPARK)
• Support development and administration of onboarding activities with the TDH Snowflake Platform (SPARK)
• Assist with development and execution of Quality Assurance protocols, including data integrity and security
• Support business intelligence design and implementation

Minimum Qualifications/Education and Experience:

• Preferred Bachelor s Degree in Public Health and/or Bachelor s Degree in Computer Science or related fields. Consideration for related technical certifications and/or work experience.
• Significant experience in public health or in the analysis of health data.
• Direct experience in warehouse design, development, modeling, support, and operations utilizing Snowflake (3+ years).
• Experience in Structured Query Language (SQL) Server 2012 or later (5+ years).
• Experience and conceptual understanding of data integration tools and technologies such as Microsoft SSIS and RDBMS concepts and methods.
• Strong understanding of data modeling and ETL processes.
• Excellent problem-solving and analytical skills.
• Effective communication and teamwork skills

Skills:

• Development experience working within Cloud Platform (AWS). Development experience working within the Snowflake Platform.
• Stored procedure development and optimization, SQL Server Integration Services (SSIS) development, and complex query development utilizing multiple large data sources using SQL 2012 or later.
• Strong understanding of data modeling and ETL processes.
• Excellent problem-solving and analytical skills.
• Effective communication and teamwork skills.
• Business Intelligence Development, Application Program Interface (API) development.
• Experience manipulating, customizing, and automating using scripting languages Python/PowerShell.

Preferred Qualifications:

• Experience with Snowflake.
• Experience in SQL Management Studio (SSMS), SQL Server Integration Services (SSIS), Application Program Interface (API) development, SQL Server Analysis Services (SSAS), working knowledge of Database design and implementation, and Healthcare Informatics preferred.
• Development experience within Cloud Platforms is preferred.