Data Warehouse Admin III-Production Support/ETL

Data Warehouse Admin III-Production Support/ETL

Location: Texas Health Resources System Services
Job ID: 52114
Department: Clinical - Bus Intelligence
Area of Interest: Information Services or Technology
Job Type: Full Time
Shift: Variable
Relocation Provided: No

Travel Required: No
Specialty: NN
Job Function: PRF

Qualifications/Duties
Texas Health Resources is looking for a Data Warehouse Admin III - Production Support/ETL. The ideal candidate will possess the following:

PREFERRED EXPERIENCE WITH THE FOLLOWING IN A DATA WAREHOUSE ENVIRONMENT:
* Oracle
* Quality Stage
* Business Glossary
* Information Analyzer
* Metadata Workbench
* Blueprint Director
* Fast Track
* Optim

Min. Education required: Bachelors degree required

Min. Experience required:

*6+ years experience designing & developing complex solutions utilizing InfoSphere Information Server version 8.5 products including: Datastage, Quality Stage, Business Glossary, Information Analyzer, Metadata Workbench, Information Services Director, Blueprint Director, Fast Track, and Optim in a Data Warehouse environment

*6+ years experience with Relational Databases and SQL Query language DB2; Oracle also preferred.

*6+ years experience translating source and target models into detailed technical specifications and participating in reviewing technical specifications and developed solutions.

Duties:

Support & Maintenance Take responsibility for the Support and maintenance of the development, test and production InfoSphere environment. Work with the DBA, Cognos Architect, Business Analyst, and Data Architect to make changes to existing data marts, warehouse environments, and staging areas. Support and maintain ETL environment while preserving consistency, development standards, documentation, governance, data quality, and timely availability. Responsible for the maintenance and periodic review of process/load documentation and Knowledge Base Documentation, updating as needed while mentoring/assisting others. Consistently complete incidents within service level agreements and assist/mentor others. Provide timely and accurate estimates for all requests while assisting and mentoring others. Complete triage and root cause analysis on incidents identified in the production environment and ensure proper resolution.

New Development Design, build and deploy high quality, performance, integrated, and documented ETL solutions while following established standards and mentoring others. Design and architect ETL load strategies needed to support required staging, warehouse, or data marts while mentoring others. Collaborate with key members of the design team to design, build, test, and deploy an environment that supports a single version of the truth, actionable results, and flexibility for the future, performance, data quality, and data governance. Conceptualize, analyze, develop, and deploy strategies for data acquisition, transformation, and loading on an enterprise level while mentoring others. Responsible for the accurate documentation and gathering of appropriate metadata for all newly developed ETL procedures using available tools. Ensure that Established Standards, Quality Requirements & Best Practices are followed in all development efforts. Plan, develop, execute, and document unit and integrated test plans using Optim and other related tools while mentoring and assisting others. Develop detailed implementation plans estimating duration and identifying dependencies; while mentoring/assisting others. Communicates with customer, project team and vendors in a timely manner and escalates issues & risks appropriately, with little or no supervision. Identify, develop and document detailed ETL data requirements and detailed specifications through the Data Warehouse life cycle integrating with existing data warehouse environment. Perform detailed data analysis including data quality and consistency by monitoring production data. Review ETL code/design/test results to verify they correctly load data; meet our standards and best practices, and meets business requirements. Provide timely and accurate estimates for analysis, design, development, testing, and deployment tasks while assisting and mentoring others. Work with the Data Architect, DBA, Business Analyst, and Cognos architect to develop high performance and highly scalable data marts.

Administration Utilizes scheduling capability to automate & schedule data acquisition/cleaning/load utilities as defined while mentoring others. Responsible for monitoring the InfoSphere environment (and related software) for hardware, software, memory, storage, user, and performance metrics that are critical to normal production operations and make sure the system continues to function in a consistent and expected manner. Coordinate, Plan and install software & hardware upgrades as needed to support currency of the ETL products; while mentoring others

Process Initiate, perform and participate in reviews required during the software development lifecycle to ensure proper design/development/implementation of all ETL objects. Follow agreed service management guidelines and mentor/encourage others
Follow agreed PMO processes mentor/encourage others. Follow established timekeeping requirements mentor/encourage others. Complete required training by deadlines established and complete at least 8 hours of skill education annually while mentoring/encouraging others.

Knowledge Continue development of technical skills through training, mentoring, and collaboration. Mentor others to enhance skills, process, and performance. Support knowledge management by maintaining all required documentation within the development and support environments. Maintain/Update documentation needed throughout the InfoSphere environment to ensure compliance with established standards.

Entity Information
Texas Health Resources is headquartered in the Dallas-Fort Worth area, and is one of the largest faith-based, nonprofit health care delivery systems in the United States. The System serves more than 6.2 million people living in 29 counties in north central Texas. With over $2.0 billion in annual revenue, Texas Health Resources is the largest fully integrated, not-for-profit healthcare organization in Texas, and the ninth largest system in the United States.

Texas Health Resources is an equal opportunity employer that celebrates diversity at all levels of our organization. EOE/AA/M/F/D/V