Data Warehouse Technical Analyst
This position is responsible for gathering and assessing business information needs and preparing system requirements. Performs analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation. Uses data mining and data analysis tools. Reviews and validates data loaded into the data warehouse for accuracy. Interacts with user community to produce reporting requirements. Provides technical consulting to users of the various data warehouses and advises users on conflicts and inappropriate data usage. Responsible for prototyping solutions, preparing test scripts, and conducting tests and for data replication, extraction, loading, cleansing, and data modeling for data warehouses.
MUST HAVE:
· 5+ years IT work experience in Business Intelligence tools and systems
· Advanced SQL Skills
· Experience investigating data and working with business to understand what is needed
· Data analysis
o Ideally someone who has come from a Data Warehouse environment– some light data movement is required
· Uses best practices and knowledge of internal or external business issues to improve products or services
· Be able to elicit requirements
· Independently solves complex problems; takes a new perspective using existing solutions
· Works independently, receives minimal guidance
· Acts as a resource for colleagues with less experience; may direct the work of other staff members
NICE TO HAVE:
· Heath care background
· Teradata skills