Data Warehouse Analyst II
Job Details
Corporate Office - Chattanooga, TN
Full Time
Information Technology


This position is responsible for both daily maintenance and supervised, longer-term development of PlayCores data warehouse environment. In support of PlayCores commitment to data-driven decisions, impeccable attention to detail, along with the motivation to continually expand our business intelligence base, is a hallmark trait of the successful Data Warehouse Analyst.

Essential Duties and Responsibilities

  1. Promotes the Companys mission and values-based culture through dedicated service and support of all aspects of our data warehousing efforts to gather and report consistent, accurate common data elements from across the business units within a central database.
  2. Creates and manages the extraction, transformation, and validation processes of data from source systems using ELT/ETL tool(s)
  3. Assists with report/dashboard design and development
  4. Delivers training and support to other PlayCore users of the data warehouse
  5. Coordinates trouble tickets with warehousing service providers
  6. Works with the Infrastructure Team to establish and maintain connections to data sources
  7. Responds to and documents reported incidents, along with the resolution, in the departments incident tracking system
  8. Provides general guidance and preparation of reference material for end users
  9. Coaches the end users on efficient use of the solution and provides tips and tricks
  10. Accountable for enforcement of IT department standards, including but not limited to, proper documentation and approval processes
  11. Other duties as assigned by Manager or Supervisor

Education and/or Experience

  • BA/BS required in an IT or related field, or equivalent experience
  • 1-2 years of experience working in a business intelligence role
  • 1+ year of experience working with relational databases
  • Use of ELT/ETL tools, such as Matillion, and hands-on transformation of extracted data into business-usable data a plus
  • Deployment of warehoused data into a BI visualization tool such as Microsoft Power BI, or equivalent, including report/dashboard design a plus
  • 1+ year of experience using an ERP system a plus
PlayCore Video
Day of Caring