Senior Department Data Analyst

About the role

UT Southwestern Medical Center in Dallas is hiring a Senior Department Data Analyst. The role works with relatively low supervision to provide data acquisition, management and report design and generation for users of data. It is a security-sensitive position.

Key responsibilities

• 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 in Microsoft Fabric, including Data Factory pipelines, Dataflows and Lakehouse solutions.
• Manage data ingestion, transformation, orchestration and integration from multiple source systems.
• Develop, test and maintain SQL queries, stored procedures, views and related database objects; monitor and tune database performance, availability and capacity.
• Implement backup, recovery and disaster recovery strategies.
• Act as primary data steward for department databases, source systems and data structures, ensuring data accuracy and mitigating audit and data risk.
• Lead departmental projects, define plans and schedules, and act as technical lead and SME for source data systems and institutional platforms such as EDW and organizational dashboards.
• Coordinate data preparation and submission of documents to federal, state and research funding agencies, and lead training on data interpretation and statistical analysis.

Required profile

• Bachelor's degree in science, information management, healthcare information, statistics, business or a closely related field.
• 5 years of data management/analyst experience; equivalent education and experience may be considered.
• Preferred: Master's degree, and experience in a clinical or healthcare field with familiarity with scientific terminology.

Required skills

• Relational databases, query reporting and report specification development.
• Database and report writing software such as Access, Business Objects and Crystal.
• Analytical problem solving, attention to detail, independent project work and effective communication.

What we offer

• PPO medical plan available day one at no cost for full-time employee-only coverage, with 100% coverage for preventive care.
• Paid time off and paid parental leave benefit.
• Retirement program through the Teacher Retirement System of Texas, wellness programs and tuition reimbursement.
• Public Service Loan Forgiveness (PSLF) qualified employer.