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
Top Skills
What We Do
We have nearly 30 years of experience, and our bent toward contrarian thought brings a refreshing perspective. The combination of these unique qualities empowers us to offer an approach to developing and delivering talent that is truly transformational. We don’t resist change; we embrace it as a continual way of life. Informed by a reverence for the history of the technology industry and an in-depth knowledge of its progression, we are able to capitalize on both timeless principles and new ideas. Rather than settling into the grooves on the path most traveled, we plot our own course. Cook’s approach is transformational, not transactional. We are passionate about investing in people, training up and tracking down the best of the best — not just on paper, but in real life, making the solutions we provide sustainable. Through our FastTrack’d program, team-delivered solutions and culture of internal growth, we have established a unique way of doing business — one that values people over placement, creating genuine partnership with our clients and candidates. The philosophy of the transformational approach: - We try new ideas. - We ask questions — even the tough ones. They create a path to understanding. - We believe who you are is ultimately more valuable than what you do. The transformational approach at work: - We equip talent though FastTrack’d with more than just technical skills, investing in personal character and integrity as central elements of being an excellent, sustainable candidate. - We welcome change, even within our own organization. We’ve transitioned our own internal tools onto an AWS platform with automated testing capability, utilizing dev/ops construct and agile development methodologies. - We reimagined the educational framework of FastTrack’d by shaping it into modules, allowing for client involvement in the final product while preserving the integrity of the proven training model.
