Job ID: JOB_ID_7107
Job Summary:
The client is seeking a qualified candidate to support the ongoing development and maintenance of TDH’s cloud-based Snowflake (SPARK) Data Repository and associated business intelligence as a part of the Office of Informatics and Analytics (OIA). The Snowflake Data Engineer will be responsible for designing, implementing, and optimizing data solutions using the state’s Snowflake data platform (SPARK). This role requires a deep understanding of data warehousing, ETL processes, the Snowflake platform, and SQL. The position will work closely with cross-functional teams to ensure data integrity, security, and performance.
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.
- Develop system requirements and assist with the ascertainment of newly identified data sources for onboarding into the SPARK platform.
- Work closely with data stewards and internal partners to understand their current and future needs, expected outcomes, and uses of their data within the Snowflake data platform (SPARK).
- Develop ingestion processes, mapping, validation, and transformation of partner data.
- Ensure data quality, automate data pipelines, accurately map data fields from disparate sources, and troubleshoot ingestion errors for seamless system adoption.
Minimum Qualifications/Education and Experience:
- Preferred Bachelors Degree in Public Health and/or Bachelors 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 (5+ years).
- Strong understanding of data modeling and ETL processes (5+ years).
- Excellent problem-solving and analytical skills (5+ years).
- Effective communication and teamwork skills (5+ years).
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 (5+ years).
- 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 (5+ years).
- Development experience within Cloud Platforms is preferred (5+ years).
Special Requirements
Hybrid. Locals ONLY. Estimated Duration: 05/01/2026 – 06/30/2027. Background Verification required. Experience with Snowflake, SQL Server, SSIS, API development, SSAS, Healthcare Informatics preferred. Development experience within Cloud Platforms preferred.
Compensation & Location
Salary: $110,000 – $150,000 per year (Estimated)
Location: Nashville, TN
Recruiter / Company – Contact Information
Email: lthar@techwave.com
Recruiter Notice:
To remove this job posting, please send an email from
lthar@techwave.com with the subject:
DELETE_JOB_ID_7107