Data Warehouse Analyst: Architect Data for Insight & Growth

Cook Systems; Orlando (FL); On-site; USD 70,000 - 100,000; Full time

Benefits offered by this job

Health insurance

Dental and vision coverage

Life insurance

401(k) plan with company match

Job summary

Cook Systems is 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.

The role requires collaboration with user communities to define reporting needs, design metadata repositories, and ensure data quality across

Qualifications

• 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.

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.

Skills

Data warehouse concepts

Business intelligence

Project leadership

Mentoring juniors

RDBMS knowledge

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

Data warehouse tools

SQL/RDBMS front-end tools

Job description

Cook Systems is 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.

The role requires collaboration with user communities to define reporting needs, design metadata repositories, and ensure data quality across