Data Warehouse Administrator II

Apply for job    
Arlington, TX US
Job ID:
Data Operations
Area of Interest:
Information Services or Technology
Job Type:
Full Time
Texas Health Resources System Services

Monday - Friday, hours may vary.

Minimum Education Required:
Bachelor's Degree in Computer Science, Engineering, Computer Engineering or relevant field OR 4 years of relevant experience in lieu of a degree.

Minimum Experience Required:
2 years of relevant experience with a Bachelor's degree or 6 years relevant experience with no degree.

Preferred Experience:
4+ years experience gathering, understanding, and documenting business reporting requirements for complex data warehouse solutions for deployment using InfoSphere products including: Information Data Architect, Datastage, Quality Stage, Business Glossary, Information Analyzer, Metadata Workbench, Information Services Director, Blueprint Director, Fast Track, and Optim in a Data Warehouse environment.
4+ years quality assurance experience in a data warehouse environment working directly with business users.
4+ years experience gathering and documenting testing requirements working directly with business users .
4+ years experience defining data quality procedures, supporting data governance procedures, defining/following data security policies, and supporting master data management strategies using appropriate tools

Support & Maintenance Incidents, Requests, Timely Escalations,
Estimates (Labor), Root Cause Analysis, Triage, Communication (customer/vendor), Production Support/Monitoring, Documentation (Updates/Review), Customer Satisfaction Surveys.
Work with the business users, DBA, ETL Architect, Data Architect, & Cognos Architect to gather/document testing requirements for changes to reports or existing data marts, warehouse environments, and staging areas as needed; with minimal assistance. Responsible for the maintenance and periodic review of documentation and Knowledge Base Documentation, updating as needed. Complete triage and root cause analysis on incidents identified in the production environment and ensure proper resolution; with minimal supervision. Consistently complete incidents within service level agreements; with minimal supervision. 95% of Customer Survey scores will be a 3 or greater.   90% of Customer Survey scores will be a 4 or greater. 95% of Change Notices will be closed by End Time of Notice, measured quarterly. Incident/Problem Tickets - Acknowledgement & Appropriate Description performed 90% based on severity protocol. Sev1=15 min/4hr, Sev2=60min/8hr, Sev3=24hr/72hr, Sev4=7day/30day)
Request Tickets - Acknowledged, with appropriate work status and description updated within 5 business days 95% of tickets.
New Development Requirements (Doc), Design/Architecture (Doc/Rev), Estimates (Doc/Measurement), Development (Doc/Standards/Code Rev), Testing (Plans/Scripts/Review), Communication/Collaboration, Issue/Risk Escalation
Gather, document, and communicate accurate, detailed, and extensively diagramed testing requirements at an appropriate level of detail suitable for use by data warehouse architects / analysts and application developers; following established standards; with minimal supervision. Identify and obtain business user cooperation needed in order to properly document requirements. Plan, execute, and document user interviews and outcomes while building solid relationships with business users; with minimal supervision
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, flexibility for the future, performance, data quality, and data governance. Fully define, document, and communicate scope, goals, desired functionality and features.
Collaborate in the conceptualization, analysis, development, and deployment strategies for data storage, ETL, and reporting at the enterprise level with minimal supervision. Responsible for the accurate documentation of business terms, reporting needs, calculations, and any appropriate metadata; using available tools
Ensure that established standards, quality requirements & best practices are followed in all development efforts. Participate in the planning, development and execution, and documentation of unit and integrated test plans. Assist in the development and review of detailed testing plans estimating duration and identifying dependencies. Communicate with customer, project team and vendors in a timely manner and escalates issues & risks appropriately
Identify, develop and document detailed business requirements and detailed specifications through the Data Warehouse life cycle integrating with existing data warehouse environment. Perform detailed data analysis & profiling including data quality and consistency by monitoring production data. Review data models, ETL design documents, and BI design documents with appropriate team members to verify they meet business requirements. Provide timely and accurate estimates for documentation, analysis, and testing tasks. Work with the DBA, ETL Architect, Data Architect, and Cognos architect to develop high performance and highly scalable data marts, warehouse environments, and staging areas
Administration Upgrades/Patches (Currency/Plan/Impl), User Adminsitration (SLA/Standards), Security (Policy/Standard), Life Cycle Mgmt (Usage), Monitoring (H/W,OS,CPU,Storage,Users, Perform), Events/Scheduling
Perform assigned testing activities on a timely basis; while assisting others. Perform assigned security audits on a timely basis; while assisting others. Perform assigned documentation in a timely manner; while assisting others
Process SDLC (Reviews), Service Mgmt Guidelines, PMO Process
TimeKeeping/Status  (Wed), Peak Process, Training (8 Hours annually). Participate in reviews required during the software development lifecycle to ensure proper design/development/implementation of all data architecture objects. Follow agreed service management guidelines; while assisting others. Follow agreed PMO processes; while assisting others. Follow established timekeeping requirements; while assisting others. Complete required training by deadlines established and complete at least 8 hours of skill education annually while assisting others. Document and follow quality assurance guidelines and processes. 8 hours minimum time to be spent in educational opportunities. 95% of weekly time entry to be entered by Wednesday of following week. 100% PEAK Reviews completed within appropriate effective pay period. 70% of PMO Project Milestone Dates will be met.
Knowledge Skills, Growth, Mentoring, Training, Knowledge Mgmt
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 data architecture environment to ensure compliance with established standards.

Entity Information:
Texas Health Resources is one of the largest faith-based, nonprofit health care delivery systems in the United States and the largest in North Texas in terms of patients served.
Texas Health has 25 acute-care and short-stay hospitals that are owned, operated, joint-ventured or affiliated with the system. It has more than 3,800 licensed beds, more than 21,100 employees of fully-owned/operated facilities plus 1,400 employees of consolidated joint ventures, and counts more than 5,500 physicians with active staff privileges at its hospitals.
At Texas Health, we strive to create an atmosphere of respect, integrity, compassion and excellence for all who come in contact with us, be they patients or our employees. We are committed to diversity in our workforce, and our mission to serve spreads across ethnic, cultural, economic and generational boundaries.  We invite you to join us in furthering your career through our accomplishments and philosophy of excellence.
Apply for job    

-Employment opportunities are only reflective of wholly owned Texas Health Resources entities.

We are an Equal Opportunity Employer and do not discriminate against any employees or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class. LEARN MORE

Powered by SmashFly