About Cook Systems
For over 30 years, Cook Systems has partnered with organizations across the country to solve technology challenges and build strong technology teams. As a veteran-owned IT consulting company, we combine decades of industry experience with a continued focus on how technology, AI, and the way people work are evolving.
Our work spans technology consulting, talent development, and AI-enabled solutions. We value people who take ownership, adapt quickly, communicate well, and care about the quality of their work. Whether you’re early in your career or bringing years of experience, you’ll have the opportunity to keep building your skills, contribute to meaningful client work, and grow with a company that continues to evolve with the industry.
Summary: We are seeking a Senior Snowflake Data Engineer for a six-week contract to spearhead a targeted data-sharing pilot between P&C FLOD and P&C Risk SLOD. This role is pivotal in making first-line operational data accessible, validated, and usable for proactive second-line risk monitoring within a governed enterprise environment.
Responsibilities:
- Work with FLOD owners to identify and define relevant data sources and usage.
- Develop curated datasets by building Snowflake views integrating tables across databases.
- Implement approved data-sharing arrangements, prepare data contracts, and coordinate approvals.
- Establish group-based access by creating AD security groups and mapping Snowflake roles.
- Validate pilot by reconciling datasets, testing data quality, and verifying access controls.
- Deliver repeatable risk-monitoring queries and a comprehensive support runbook.
- Act as a mentor to less experienced colleagues, offering expertise in statistical computation and visualization tools.
Required Skills:
- Extensive experience with Big Data Technologies such as Apache Hadoop, Map Reduce, Hive, and more.
- Proficiency in statistical computation and numerical tools including R, Spark, and Python.
- Strong understanding of statistics and machine learning algorithms like Decision Trees, Neural Networks, and Random Forest.
- Significant experience in data visualization tools such as KNIME, Spotfire, and Tableau.
- Excellent skills in developing complex models and improving their accuracy.
- Experience in documenting implementation details, models, and business definitions.
- Background in insurance or financial-services operational data preferred.
Benefits at Cook Systems
We want our employees to have benefits that support their health, financial well-being, and life outside of work. Eligible Cook Systems employees have access to a comprehensive benefits package beginning the first of the month following their hire date, including:
- Medical coverage through Blue Cross Blue Shield, with two plan options
- Dental and vision coverage
- Life, critical illness, and accident insurance through Unum
- Flexible Spending Account and Dependent Care FSA options through Navia
- Health Gap Insurance through Sun Life
- 401(k) retirement plan through The Standard, with eligibility after six months
Beyond benefits, Cook Systems is a place where we expect people to take ownership of their work, communicate openly, continue learning, and contribute to the teams and clients they support.
We have been building technology careers and client partnerships for more than three decades, and we continue to evolve with the industry. If you’re looking for an opportunity to do meaningful work, develop your capabilities, and be part of what comes next in technology, we’d like to hear from you.