Senior Healthcare Data Architect & Analytics Lead

University of Texas Southwestern Medical Center; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

UT Southwestern Medical Center in Dallas is seeking a data analyst to provide data acquisition, management, and report design services for users of data. The role requires administering and optimizing databases in Azure environments, including Azure SQL Database, Azure SQL Managed Instance, and Azure Data Lake Storage.

You will design and support ETL/ELT processes using Microsoft Fabric, Data Factory pipelines, and Lakehouse solutions; develop SQL queries and procedures; ensure data quality and

Qualifications

• Bachelor's Degree in Science, Information Management, Healthcare Information, Statistics, Business or closely related field.
• 5 years of Data management/analyst experience; a combination of equivalent education and experience will be considered.

Responsibilities

• Administer, maintain, and optimize databases within Microsoft Azure environments.
• Design, develop, and support ETL/ELT processes using Microsoft Fabric, including Data Factory pipelines, Dataflows, and Lakehouse solutions.
• Develop, test, and maintain SQL queries, stored procedures, views, and related database objects.
• Monitor and enhance database performance, availability, and capacity through proactive tuning and optimization.
• Implement backup, recovery, and disaster recovery strategies to ensure business continuity.
• Lead data governance and coordinate data-related projects across departments.

Skills

Azure SQL

ETL/ELT

SQL queries

Data governance

Data analysis

Project coordination

Education

Bachelor's Degree

Tools

Access

Business Objects

Crystal Reports

Job description

UT Southwestern Medical Center in Dallas is seeking a data analyst to provide data acquisition, management, and report design services for users of data. The role requires administering and optimizing databases in Azure environments, including Azure SQL Database, Azure SQL Managed Instance, and Azure Data Lake Storage.

You will design and support ETL/ELT processes using Microsoft Fabric, Data Factory pipelines, and Lakehouse solutions; develop SQL queries and procedures; ensure data quality and