Data Warehouse Administrator - Center for Health Care Data

Data Warehouse Administrator - Center for Health Care Data

Location: Texas Medical Center-Houston, Texas

Hot

Category: Information Technology

UTHealth Houston School of Public Health

Requisition #: 230003A7

What we do here changes the world. UTHealth Houston is Texas’ resource for healthcare education, innovation, scientific discovery, and excellence in patient care. That’s where you come in.

We are looking for a Full-Time Database Administrator to join the Center for Health Care Data as part of the UTHealth School of Public Health in Houston, TX, 77030. This is a Hybrid position that currently allows for a mostly remote schedule with in-office meetings 2-3 days per month. In this position, you will provide technical leadership and operational expertise at the decision-making level for the implementation, architecture, design, ongoing support, and maintenance of the Texas All Payor Claims Database (TX-APCD) and other organizational data warehouses and related software systems. You will exercise considerable latitude and judgment in determining the methods and objectives of assignments.

Once you join us you won't want to leave. It’s because we reward our team for the excellent service they provide. Our total rewards package includes the benefits you’d expect from a top healthcare organization (benefits, insurance, etc.), plus:

• 100% paid medical premiums for our full-time employees

• Generous time off (holidays, preventative leave day, both vacation and sick time – all of which equates to around 37-38 days per year)

• The longer you stay, the more vacation you’ll accrue!

• Longevity Pay (Monthly payments after two years of service)

• Build your future with our awesome retirement/pension plan!

We take care of our employees! As a world-renowned institution, our employees’ wellbeing is important to us. We offer work/life services such as…

• Free financial and legal counseling

• Free mental health counseling services

• Gym membership discounts and access to wellness programs

• Other employee discounts including entertainment, car rentals, cell phones, etc.

• Resources for child and elder care

• Plus many more!

Position Summary:

Provides technical leadership and operational expertise at the decision-making level for the implementation, architecture, design, ongoing support, and maintenance of organizational data warehouses and related software systems. Acts as the primary technical resource for the institutional data warehouses and related database systems. Exercises considerable latitude and judgment in determining methods and objectives of assignments. Completed work is reviewed from a relatively long-term perspective for desired results.

Position Key Accountabilities:

• Designs and implements data warehouse and related systems with respect to organization, access methods, and documentation. Develops and maintains expertise in the use of automated tools for data warehouse design and implementation.

• Develops and applies policies and procedures relating to data and application security including procedures by which access is authorized, enabled, changed, and withdrawn.

• Develops and applies policies and procedures for periodic data backup. Determines backup method and frequency. Ensures that data can be restored quickly and completely from backup files.

• Monitors access time, performs validation checks and uses other methods to monitor, analyze and tune data warehouse performance. Ensures that data warehouse will support growth, change, and access demands.

• Acts as a technical resource for application and data users, developers, and systems analysts, and other stakeholders.

• Provides technical leadership, support to all stakeholders in the investigation, analysis, and resolution of data warehouse problems.

• Develops, documents, and implements standards, policies, and procedures and ensures audit compliance for all data warehouse platforms and related systems.

• Works closely with cross-functional teams including data scientists, biostatisticians, and other stakeholders to ensure that the data warehouse meets the needs of the organization and supports program goals.

• Coordinate data warehouse activities with UTHealth IT to promote alignment with institutional standards and strategies.

• Maintains current knowledge and keeps management informed of products, developments and trends in data warehouse management and related software. Develops recommendations for management. Coordinates with vendors in testing and installing new releases, installing patches, user training, and documenting updates.

• Works directly with the data warehouse vendor to ensure efficient data transfer and receipt

• Assesses and confirms data completeness and data integrity

• Continuously monitors data storage availability, and data access, encryption and security

• Monitors data usage, data processing time and performance and recommends action when needed.

• Responsible for interaction with audit professionals

Desired Certifications/Skills:

• Certifications in relevant areas such as PostgreSQL or SQL Server are highly desirable.

• Expertise in administering, tuning, and monitoring massively parallel processing (MPP) databases in Linux environments, experience with Greenplum a plus.

• Expert knowledge of Linux system administration activities including scripting, filesystem management, access controls, and monitoring.

• Proficient in the use of a range of data warehousing technologies, including ETL/ELT tools, SQL, Python, and data modeling techniques for large, complex data sets.

Minimum Education:

• Bachelor’s degree in computer science, business, related discipline or related experience in lieu of education.

Minimum Experience:

• Seven years experience working with relational databases, data administration, ERP systems, and other software applications in a large-scale enterprise-wide environment.

Physical Requirements:

Exerts up to 50 pounds of force occasionally and/or up to 20 pounds frequently and/or up to 10 pounds constantly to move objects.

Security Sensitive:

This job class may contain positions that are security sensitive and thereby subject to the provisions of Texas Education Code § 51.215

Residency Requirement:

Employees must permanently reside and work in the State of Texas.

If you are looking for a great healthcare career in Houston, visithttp://go.uth.edu/careers!

University of Texas Health Science Center at Houston (UTHealth)

Established in 1972 by The University of Texas System Board of Regents, The University of Texas Health Science Center at Houston (UTHealth) is Houston’s Health University and Texas’ resource for health care education, innovation, scientific discovery and excellence in patient care. The most comprehensive academic health center in the UT System and the U.S. Gulf Coast region, UTHealth Houston is home to schools of biomedical informatics, biomedical sciences, dentistry, nursing and public health and the John P. and Kathrine G. McGovern Medical School. UTHealth Houston includes The University of Texas Harris County Psychiatric Center, as well as the growing clinical practices UT Physicians, UT Dentists and UT Health Services. The university’s primary teaching hospitals are Memorial Hermann-Texas Medical Center, Children’s Memorial Hermann Hospital and Harris Health Lyndon B. Johnson Hospital.

UTHealth Benefits

UTHealth Houston offers a comprehensive and competitive benefits package. For more information on our benefits programs please refer to the UTHealth Houston Office of Benefits Website.

https://www.uth.edu/benefits/

Equal Employment Opportunity Statement

UTHealth Houston is committed to providing equal opportunity in all employment-related activities without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, genetic information, gender identity or expression, veteran status or any other basis prohibited by law or university policy. Reasonable accommodation, based on disability or religious observances, will be considered in accordance with applicable law and UTHealth Houston policy. The University maintains affirmative action programs with respect to women, minorities, individuals with disabilities, and eligible veterans in accordance with applicable law.

UTHealthHoustonhas adopted a policy consistent with CMS regulations to protect our patients and university community from exposure to COVID-19. This policy affects all employees, residents, fellows, students, contractors, new hires, visiting scholars program participants, adjunct faculty, and volunteers who work, train, or collaborate at the John S. Dunn Behavioral Science Center.

In addition, all UTHealthHouston​​​​​​​employees who are assigned to work at a location that is subject to the affiliated partner’s hospital, clinical offices, or agency are required to abide by UTHealth’sHoustonrules and regulations, as well as the affiliate’s rules and regulations, including COVID-19 vaccination and safety requirements.

Work location is based on the needs of the department and may be adjusted.