Snowflake (Data Engineer)
Launch Your Career with Cook Systems
Since 1990, Cook Systems—a certified veteran-owned IT consulting firm—has been helping businesses and professionals grow through innovation, integrity, and investment in people. We partner with Fortune 500 enterprises and high-growth companies alike to deliver agile technology solutions, AI-driven talent strategies, and our signature FastTrack program that develops the next generation of tech talent.
At Cook, you’ll find a culture that values excellence, creativity, and accountability. We believe in opportunity backed by trust—and in building careers that last. Check out what our team members have to say on our Glassdoor page, and discover why Cook Systems is where meaningful careers take off!
Summary:
Seeking a skilled Snowflake Data Engineer to join their Office of Informatics and Analytics (OIA). The role involves designing, implementing, and optimizing data solutions using the state's Snowflake data platform (SPARK) to support data repository and business intelligence initiatives. The Engineer will ensure data integrity, security, and performance, while working closely with cross-functional teams to onboard new data sources and develop efficient data pipelines.
Responsibilities:
- Design, implement, and optimize data solutions using the Snowflake platform (SPARK).
- Collaborate with cross-functional teams to ensure data integrity, security, and performance.
- Develop system requirements and assist in onboarding new data sources into the SPARK platform.
- Develop ingestion processes, mapping, validation, and transformation of partner data.
- Ensure data quality and automate data pipelines for seamless system adoption.
- Troubleshoot data ingestion errors and optimize data processes.
- Support the development and execution of quality assurance protocols, including data integrity and security.
- Contribute to business intelligence design and implementation.
Required Qualifications:
- Bachelor's Degree in Public Health, Computer Science, or related fields, or equivalent technical certifications and/or work experience.
- Significant experience in public health or health data analysis.
- 3+ years of direct experience in warehouse design, development, modeling, support, and operations utilizing Snowflake.
- 5+ years of experience in Structured Query Language (SQL) Server 2012 or later.
- Experience with data integration tools and technologies, such as Microsoft SSIS.
- Strong understanding of data modeling and ETL processes.
- Excellent problem-solving and analytical skills.
- Effective communication and teamwork abilities.
- Development experience within a Cloud Platform (AWS).
- Proficiency in scripting languages, including Python and PowerShell.
Preferred Qualifications:
- Experience with Snowflake, SQL Management Studio (SSMS), and SQL Server Integration Services (SSIS).
- API development and SQL Server Analysis Services (SSAS) experience.
- Working knowledge of database design and implementation.
- Experience in Healthcare Informatics.
#Ll-Hybrid
Why Work with Us
At Cook Systems, we don’t just offer jobs—we build futures. Our people are at the heart of everything we do, and we’re committed to supporting you with benefits that deliver real security, flexibility, and growth from day one.
- Your Health, Your Way: Choose from two comprehensive medical plans through Blue Cross Blue Shield, with dental and vision coverage included. With access to one of the nation’s largest provider networks, you’ll have quality care wherever life takes you.
- Peace of Mind: Protect what matters most with life, critical illness, and accident insurance through Unum—because your family’s security matters.
- Flexibility for Life: Plan ahead and save with a Flexible Spending Account and Daycare FSA through Navia, helping you manage healthcare and dependent-care expenses your way.
- Extra Protection When You Need It: Our Health Gap Insurance through Sun Life helps cover unexpected costs, so you’re never caught off guard.
- Your Future Starts Now: Build your future with our 401(k) plan through The Standard. You’re eligible after just six months—because long-term success deserves a strong foundation.
At Cook Systems, you’re not just an employee—you’re part of a team that values ideas, celebrates results, and grows together. Here, your impact is visible, your contributions are valued, and your career has room to thrive. Ready to be part of something bigger? Let’s build the future together at Cook Systems.
#IND1