Data Warehouse Analyst

About Cook Systems

Since 1990, 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 skilled Data Warehouse Analyst to gather and assess business information needs and prepare system requirements in a dynamic data warehouse environment. The ideal candidate will develop and evaluate data mining, database architecture, and ensure the accuracy of data loading, while providing technical consulting to users.

Responsibilities:

• Gather and assess business information needs to prepare system requirements.
• Perform analyses and evaluate data mining in a data warehouse environment.
• Develop database architecture, metadata, and repository creation.
• Review and validate data loaded into the data warehouse for accuracy.
• Interact with the user community to produce reporting requirements.
• Provide technical consulting to users and advise on data conflicts and inappropriate usage.
• Prototype solutions, prepare test scripts, and conduct tests.
• Manage data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Maintain knowledge of software tools, languages, scripts, and shells for data warehouses.
• Possess working knowledge of RDBMS and data warehouse front-end tools.

Required Skills:

• Bachelor's Degree in Computer Science, Information Systems, or related field, or equivalent work experience.
• Minimum of 3 years of IT work experience in business intelligence tools and systems.
• Extensive knowledge of data warehouse and data mart concepts.
• Experience in data warehouse architectural design, development, and support in multi-platform environments.
• Ability to work on multiple projects and lead projects of moderate complexity.
• Capability to coach junior technical staff.

#Ll-Onsite

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.

#IND1