Title:  Data Warehouse Analyst

Division:  Institute for Clinical and Translational
Schedule:  Monday - Friday, 8 a.m - 5 p.m
Work Location:  Baylor Main Campus, Houston, TX
Salary Range:  Up to $100,065
FLSA Status:  Exempt
Requisition ID:  1430
Summary

Under the direction of the Institute for Clinical and Translational Research (ICTR) Director, the Data Warehouse analyst will work with ICTR to provision data for medical researchers. Designs, develops, and deploys data warehousing, OLAP, and data mining solutions.

Job Purpose

Data Warehouse Analyst designs, develops, deploys data warehousing, OLAP, and data mining solutions.

Job Responsibilities
  • Gathers business requirements for assessing information needs to utilize any products out of a datawarehouse/datamart.
  • Responsible for the development, maintenance, and support of an enterprise data warehouse system and corresponding data marts.
  • Provides application support for data capture and analysis applications.
  • Conducts research into new data warehouse applications and determines viability for adoption. Assists in development of standards.
  • Troubleshoots and tunes existing data warehouse applications.
  • Evaluates existing subject areas stored in the data warehouse.
  • Incorporates existing subject areas into an enterprise model.
  • Creates new or enhanced components of the data warehouse.
  • On call duties as required.
Minimum Qualifications
Education:
  • Required: Bachelor's degree in Computer Science, Management Information Systems, Information Technology, or a related field. Four years of related experience may substitute for degree requirement.
Experience:
  • Required: Two years of relevant experience.
Certification/Licenses/
Registration:
  • None required.
Preferred Qualifications
  • Previous experience in a healthcare setting.
  • Exposure to healthcare research and needs in this space.
  • Application installation and support experience.
Other
  • Problem solving and analysis.
  • Data extraction, transformation, and loading (ETL) processing using tool like SQL SSIS, SAP Business Objects, etc.
  • Ability to use tools to build and modify Online Analytic Processing (OLAP) structures, e.g. Hyperion Essbase.
  • Knowledge of ad hoc query/reporting/analysis tools that access relational and OLAP databases, e.g. Business Objects and Hyperion Analyzer.
  • Knowledge of relational databases and SQL.

Position may be eligible to telecommute one day per week after an initial orientation/training period.

 

 

 

 

Baylor College of Medicine is an Equal Opportunity/Affirmative Action/Equal Access Employer.

 1430