Job Description :
Launch Your Career with Cook Systems
Ready to elevate your career? Cook Systems, a certified veteran owned IT consulting firm, has been transforming businesses and careers since 1990. Whether you're aiming to work with a Fortune 500 company or a small business, we've got you covered.
Our core values: integrity, investment, and innovation drive everything we do, ensuring you grow and succeed in a dynamic, supportive environment. We understand the importance of work life balance and personal growth. Our cutting edge IT consulting partners and FastTrack talent program are designed to help you excel.
Join our forward thinking team where excellence and creativity are valued every day. Check out what our associates have to say on Glassdoor. Ready to take your career to new heights? Cook Systems is where your journey to success begins!
Market hourly rate based on experience. W2
Title: Integrated Data System Position ? Snowflake (Data Engineer)
NOTE: 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.
Position Description: The Tennessee Department of Health (TDH) is currently recruiting 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 states Snowflake data platform (SPARK).
The position will work closely with cross-functional teams to ensure data integrity, security, and performance. This role requires a deep understanding of data warehousing, ETL processes, the Snowflake platform, and SQL.
The Snowflake Data Engineer will be responsible for developing system requirements, assisting with the ascertainment of newly identified data sources with the primary directive of onboarding those data sources into the SPARK platform. This will require the position to work closely with data stewards and internal partners to better understand their current and future needs, expected outcomes and uses of their data within the Snowflake data platform (SPARK).
As part of the onboarding activities this position will be responsible for development of ingestion processes, mapping, validation, and transformation of partner data, in conjunction with ensuring data quality, automating data pipelines, accurately mapping data fields from disparate sources, and troubleshooting ingestion errors for seamless system adoption
A qualified candidate must have experience working within an AWS environment utilizing the Snowflake platform for developing high-quality database solutions and possess in depth knowledge of database design and optimization. A candidate must have experience developing and maintaining scripting languages such as Python and PowerShell.
This position requires a solid understanding of computer science fundamentals and experience with the utilization and development of RESTful APIs, both custom and existing.
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.
Why Work with Us
Benefits
At Cook Systems, we don't just offer jobs we build futures. Our team is the heart of everything we do, and we're committed to supporting you with benefits that go beyond the basics. We want you to feel secure, valued, and empowered from the very beginning of your journey with us. When you join Cook Systems, here's what you can look forward to:
Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, complete with dental and vision coverage. With access to one of the nation's largest networks, you'll get the care you need for yourself and your family wherever life takes you.
Peace of Mind, Every Step of the Way: Protect what matters most with life, critical illness, and accident insurance through Unum. Because your loved ones deserve security no matter what the future holds.
Flexibility for Life's Needs: Save money and plan ahead with a Flexible Spending Account and Daycare FSA through Navia, helping you manage healthcare and dependent care expenses on your terms.
Bridging the Gaps: Unexpected costs? No problem. Our Health Gap Insurance through Sunlife helps ensure you're covered when it counts.
Your Future Starts Now: Dream big with our 401(k) retirement plan through The Standard. After just six months, you will be eligible to participate, because your future deserves a strong foundation.
At Cook Systems, you're not just another employee you're family. Here, your ideas matter, your contributions shine, and your career will thrive. Together, we innovate, grow, and celebrate success every step of the way. Are you ready to be part of something bigger? Let's build the future together at Cook Systems.