Sr Department Data Analyst

UT Southwestern Medical Center•Dallas, TX

About The Position

Works with relatively low supervision to provide data acquisition, management, and report design and generation for users of data. Administers, maintains, and optimizes databases in Microsoft Azure environments, including Azure SQL Database, Azure SQL Managed Instance, and Azure Data Lake Storage. Designs, develops, and supports ETL/ELT processes using Microsoft Fabric, including Data Factory pipelines, Dataflows, and Lakehouse solutions. Implements data ingestion, transformation, orchestration, and integration processes from multiple source systems. Develops, tests, and maintains SQL queries, stored procedures, views, and related database objects. Monitors and enhances database performance, availability, and capacity through proactive tuning and optimization, and implements backup, recovery, and disaster recovery strategies to ensure business continuity. The role is the primary data steward for department databases, source systems, and data structures. It abstracts, analyzes, and interprets data and makes recommendations for departmental leadership, technical counterparts, and institutional business users. The analyst ensures accuracy of data and reporting, establishes ongoing validation processes to mitigate audit and data risks, and manages departmental projects and reporting or data-mining tasks. The position serves as a technical lead and subject matter expert for departmental source data systems, supports lower-status Department Data Analysts, coordinates data submissions to external agencies and organizations, and leads data mapping, data architecture, and training activities. Other duties may be assigned.

Requirements

Bachelor's degree in Science, Information Management, Healthcare Information, Statistics, Business, or a closely related field; an equivalent combination of education and experience will be considered.
Five years of data management or analyst experience; an equivalent combination of education and experience will be considered.
Knowledge of relational databases, query reporting, and report-specification development.
Knowledge of database and report-writing software, such as Access, Business Objects, and Crystal.
Analytical problem-solving skills and attention to detail.
Ability to coordinate and work independently on projects.
Ability to communicate effectively with different levels of internal and external contacts about general policies and procedures.
Ability to work with confidential information on a daily basis.
Ability to plan and organize work in a logical and efficient manner.

Nice To Haves

Master's degree.
Experience working in a clinical or healthcare-related field.
Familiarity with scientific terminology in biology, biochemistry, chemistry, or related fields.

Responsibilities

Serve as the primary data steward for department databases, source systems, and data structures.
Abstract, analyze, and interpret data and provide recommendations to departmental leadership, technical counterparts, and relevant institutional business users.
Ensure the accuracy of data and reporting across department functions and establish ongoing data validation processes to mitigate audit and data risks.
Manage departmental projects and act as the primary departmental contact for reporting and data-mining tasks; define and maintain project plans and schedules, monitor scope, timelines, and deliverables, and provide regular status reports to departmental leadership.
Assist Department Data Analysts of lower status with data needs and project coordination.
Serve as technical lead and subject matter expert for source data systems relevant to department operations and share information with the department management team as needed or on a recurring basis.
Serve as lead technical contact for relevant data points and source systems for institutional projects and platforms, such as EDW and Organizational Dashboards.
Coordinate preparation and submission of data to federal and state agencies, private research funding agencies, and other organizations as required by law or contract.
Manage data mapping and data architecture across departmental data fields and relevant source systems using process maps and Business Intelligence architecture tools.
Lead development of education and training tools about data generation and interpretation, statistical analysis, and applying data to decision-making.
Administer, maintain, and optimize databases in Microsoft Azure environments, including Azure SQL Database, Azure SQL Managed Instance, and Azure Data Lake Storage.
Design, develop, and support ETL/ELT processes using Microsoft Fabric, including Data Factory pipelines, Dataflows, and Lakehouse solutions.
Implement data ingestion, transformation, orchestration, and integration processes from multiple source systems.
Develop, test, and maintain SQL queries, stored procedures, views, and related database objects.
Monitor and improve database performance, availability, and capacity through tuning and optimization.
Implement backup, recovery, and disaster recovery strategies to support business continuity.
Perform other duties as assigned.

Benefits

PPO medical plan, available on day one at no cost for full-time employee-only coverage.
100% coverage for preventive healthcare with no copay.
Paid Time Off, available on day one.
Retirement programs through the Teacher Retirement System of Texas (TRS).
Paid Parental Leave Benefit.
Wellness programs.
Tuition Reimbursement.
Public Service Loan Forgiveness (PSLF) Qualified Employer.
On-site childcare.
Paid holidays.
Merit increases.