Texas Health - Data Warehouse Administrator II (IS) Job
(12054521)Location: Arlington, Texas - United States
Posted: 5/14/2012
Job Description:
Data Warehouse Administrator II (IS)
Location
Texas Health Resources System Services
Job ID: 28686
Department:
Enterprise Data Management
Area of Interest:
Information Services or Technology
Job Type:
Full Time
Shift:
1st
Relocation Provided:
No
Travel Required:
No
Specialty
NN
Job Function
PRF
Qualifications:/Duties
( ** Data Warehouse Administrator II ** )
MINIMUM QUALIFICATIONS
Schedule will be 8:00am-5:00pm, Monday-Friday.
Minimum of 2 years college coursework is required. (*Bachelor's Degree is preferred).
5+ years direct Data Warehouse experience to include working with Crystal Reports, Epic Clarity Data Marts, Data Analysis, Extraction, Presentation, Standardization, and Transformation.
DUTIES / RESPONSIBILITIES
New Development
Analyze, design, develop and maintain Crystal solutions using Business Objects reporting environment.
Design, document and deploy the Crystal Reports.
Design Epic Clarity Reporting solution integrating multiple source systems.
Develop stored procedures, database triggers, complex SQL queries and PL/SQL programming.
Demonstrate a thorough understanding of Crystal and be able to translate user requirements into complex reports and dashboards.
Work with different functional groups to analyze requirements and manage expectations.
Work with team members or independently to design, develop, and test complex reports based on business objectives.
Identifying and documenting data quality issues and data patterns.
Coordinate with project team members, ITS and vendors to ensure timely, accurate and complete delivery of committed tasks.
Discover business transformation rules and complete design documentation.
Create Meta data documentation (business glossary and data definitions) for Clinical Data Management.
Define the usage of queries and reporting tools to support clinical areas when combining and analyzing large volumes of information contained within the Corporate Data Warehouse.
Develop and deliver Crystal presentations and trainings.
Support end users on using Crystal.
Create conceptual/business, logical and physical model.
Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the Data Warehouse.
Design and specify source data detection and extraction processes.
Working with the Data Warehouse DBA to help the team in developing logical and physical Data Models, ER Diagrams and state transformation models.
Design and specify source data detection and extraction processes.
Define and capture Clarity metadata rules associated with ETL processes.
Design and implement automation of data loading and cleansing processes.
Support and Maintenance
Demonstrates thorough understanding of Star Schemas, Snowflake Schemas, and highly normalized data models.
Ensures the infrastructure components are used consistently to facilitate effective development of Data Warehouse processes and intuitive user deliverables considering end user reporting.
Performs routine support of assigned system with little or no supervision.
Solves system problems and issues in a timely and accurate manner.
Is responsive to customer issues.
Communicates with customer, project team and vendors. Updating appropriate ticket system by either using the Problem Severity Matrix Standards or Request Service Level Agreement (SLA).
Support and maintain the development, test and production of ETL Data Ware house environment.
Coordinates program and/or data moves from development to test/education and production.
Review Knowledge Base Documentation periodically, updating as needed.
Designs and maintains Epic Clarity data stores used to support business reporting and analysis needs while preserving consistency, intuitive usage, quality data, and timely availability.
Demonstrates leadership by assisting both technological and business communities with data store utilization.
Identify, develop and document detailed data requirements and detailed specifications through the Data Warehouse life cycling integrating with existing data warehouse environment.
Experience analyzing source systems and perform data mapping between disparate databases/data sources and do gap analysis working with production data to validate business requirements.
Perform detailed data analysis including data quality and consistency by monitoring production data.
Analyze and develop strategies for data acquisitions, archives, recovery, and implementation of a database on an enterprise level.
Experience analyzing source systems and perform data mapping between disparate databases/ data sources and do gap analysis working with production data to validate business requirements.
Perform detailed data analysis including data quality and consistency by monitoring production data.
Create Meta data documentation for enterprise Master Data Management.
Review Crystal design document to verify they correctly load data; meet our standards and best practices, and meets business requirements.
Analyze and develop strategies for data acquisitions, archives, recovery, and implementation of a database on an enterprise level.
Keep track of production loads, identify SLA issues and inefficient jobs, help production support team tune inefficient SQL code.
Determine the optimal approach for obtaining data from diverse source system platforms and moving it to the data warehouse.
Develops detailed, accurate, complete, cost-effective, and resource-conservative design solutions that cleanly integrate with existing products and provide an easy path for future enhancements, by examining all possible courses of action and displaying sound logic and reasoning to arrive at an optimum solution.
Data Acquisition
Evaluate potential data sources to the data warehouse environment through data and technological reviews.
Interview end-users to determine requirements for data, reports, analysis, metadata, training, service levels, data quality, and performance.
Develop processes for capturing and maintaining metadata from all DW components.
Works with users to identify appropriate algorithms in order to ensure business-rule based data validation and correction to anomalies.
Cognos Process
Adapt Cognos processes to accommodate changes in source systems and new business user requirements.
Coordinate with program-level Architect to ensure compliance with standards and consistency with long-term infrastructure plans.
Develop monitoring plan to ensure data has been refreshed/updated as expected.
Search all causes for incompatibility between the warehousing environment and other systems.
Install new software patches and upgrades.
Data Quality Auditing
Design, build, and maintain data management processes that promote data quality through exception reporting, data standardization and calculation, and business rule validation. Reports findings back through both IS management and customer data stewards.
Work with production data to monitor and report on data conditions and quality.
Texas Health Resources is an equal opportunity employer that celebrates diversity at all levels of our organization. EOE/AA/M/F/D/V
| Job Capacity: | Employee (full-time) |
| Minimum Education Level: | See Job Description |
| Visa Sponsorship: | No |
| Related Industries: | Health Information Management |
* If you would like to find out more about this position or this particular hospital, please click on the 'Information' button. We realize that you may need further information even if you are not ready to apply for a job at this time.