Data Warehouse Analyst

Education:

Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience

Experience:

A minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.

Primary Job Duties/ Tasks:

1. Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs

2. Analyzes transactional data stores and develops data warehouse models to optimize the warehouse data stores for reporting and analytics

3. Creates designs, diagrams, and documents to support data integration and data warehouse solutions

4. Ensures data warehouse metadata is collected and maintained

5. Coaches and mentors peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse.

6. Assists with the development and maintenance of methods and practices documentation.