Sr Department Data Analyst

UT Southwestern; Dallas (TX); On-site; USD 85,000 - 115,000; Full time

Job summary

UT Southwestern is seeking a Sr Department Data Analyst to manage and optimize department databases in Azure environments, develop ETL/ELT processes, and deliver data-driven insights for leadership. The role emphasizes data quality, governance, and collaboration with institutional stakeholders.

Responsibilities include SQL development, data mapping, and leading data initiatives across reporting platforms, EDW, and dashboards.

Qualifications

• Minimum education: bachelor-level degree in a related field with relevant data work.
• Experience managing data in clinical or healthcare contexts preferred.
• Strong SQL skills and familiarity with Azure data services.

Responsibilities

• Manage and govern department databases, source systems, and data structures.
• Analyze data and provide interpretations and recommendations to leadership.
• Ensure data accuracy and mitigate audit/data risks with validation processes.
• Lead departmental projects, define plans, schedules, and status reports.
• Mentor junior analysts and coordinate data needs across teams.
• Serve as SME for source data systems and related platforms.
• Coordinate data preparation for external reporting as required.

Skills

Data analysis

Project coordination

Communication

Attention to detail

Education

Bachelor's degree in Science / Information Management / Healthcare Information / Statistics / Business

Tools

Azure SQL Database

Azure Data Lake

Data Factory

SQL / Stored Procedures

Job description

Job Description - Sr Department Data Analyst (982351)

Job Description

Sr Department Data Analyst - ( 982351 )

Description

WHY UT SOUTHWESTERN?

With over 75 years of excellence in Dallas-Fort Worth, Texas, UT Southwestern is committed to excellence, innovation, teamwork, and compassion. As a world-renowned medical and research center, we strive to provide the best possible care, resources, and benefits for our valued employees. Ranked as the No. 1 hospital in Dallas-Fort Worth according to U.S. News & World Report, we invest in you with opportunities for career growth and development to align with your future goals. Our highly competitive benefits package offers healthcare, PTO and paid holidays, on‑site childcare, wage, merit increases and so much more. We invite you to be a part of the UT Southwestern team where you’ll discover a culture of teamwork, professionalism, and a rewarding career!

JOB SUMMARY

Works with relatively low supervision to provide data acquisition, management and report design/generation to users of data.

Administer, maintain, and optimize databases within 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 and manage 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 enhance database performance, availability, and capacity through proactive tuning and optimization.

Implement backup, recovery, and disaster recovery strategies to ensure business continuity.

Other duties as assigned.

BENEFITS

UT Southwestern is proud to offer a competitive and comprehensive benefits package to eligible employees. Our benefits are designed to support your overall wellbeing, and include:

• PPO medical plan, available day one at no cost for full-time employee-only coverage
• Paid Time Off, available 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
• Education
  Bachelor's Degree in Science, Information Management, Healthcare Information, Statistics, Business or closely related field.
  
• Experience
  5 years of Data management/analyst experience
  A combination of equivalent education and experience will be considered.
  

Preferred

• Education
  Master's Degree
  
• Experience
  Work in a clinical or healthcare related field
  Familiarity with scientific terms (in biology, biochemistry, chemistry, etc.)
  

JOB DUTIES

• Primary data steward responsible for all department databases, source systems and data structures.
• Responsible for the abstraction of data, analysis of data, and subsequent interpretation of data/ recommendations for consideration by departmental leadership, technical counterparts, and all relevant institutional business users.
• Ensure accuracy of data and reporting across department functions, mitigating against any audit/data risk by setting processes to validate data an on ongoing basis.
• Manages departmental projects and serves as primary departmental contact for all reporting/data mining tasks. Defines and maintains project plan and schedules. Monitors compliance with definitions of project scope, timelines, and deliverables. Provides regular project status reports to departmental leadership.
• Assists Department Data Analysts of lower status with data needs and project coordination.
• Serves as technical lead and subject matter expert (SME) for all source data systems relevant to department operations. Shares information with department management team on a recurring or as needed basis.
• Serves as lead technical contact for relevant data points and sources systems for institutional projects/platforms (i.e. EDW, Organizational Dashboards, etc.)
• Coordinates the data preparation and submission of documents to federal agencies, state agencies, private research funding agencies and other organizations as required by law and contractual vehicle.
• Responsible for data mapping/data architecture across department data fields and relevant source systems, utilizing process maps and Business Intelligence architecture tools.
• Leads development of education/training tools that educate team members and institutional partners on generation and/or interpretation of data, statistical analysis and application to decision making to improve organization efficiency and outcomes.
• Performs other duties as assigned.

Knowledge, Skills and Abilities

• Work requires knowledge of relational databases, query reporting and report specifications development.
• Work requires knowledge of database and report writing software (ie Access, Business Objects and Crystal).
• Work requires analytical problem solving skills and attention to details.
• Work requires ability to coordinate and work independently on projects.
• Work requires ability to communicate effectively with various levels of internal and external contacts concerning general policies and procedures.
• Work requires ability to work with confidential information on daily basis.
• Ability to plan and organize work in logical and efficient manner.

PHYSICAL REQUIREMENTS/WORKING CONDITIONS

Physical Requirements

• Talking

Working Conditions

• Office Setting

Salary Information

Salary is commensurate with education, skills, and relevant experience.

SECURITY AND EEO STATEMENT

Security

This position is security-sensitive and subject to Texas Education Code 51.215, which authorizes UT Southwestern to obtain criminal history record information.

EEO

UT Southwestern Medical Center is committed to an educational and working environment that provides equal opportunity to all members of the University community. As an equal opportunity employer, UT Southwestern prohibits unlawful discrimination, including discrimination on the basis of race, color, religion, national origin, sex, sexual orientation, gender identity, gender expression, age, disability, genetic information, citizenship status, or veteran status.

UT Southwestern Medical Center is committed to an educational and working environment that provides equal opportunity to all members of the University community. In accordance with federal and state law, the University prohibits unlawful discrimination, including harassment, on the basis of: race; color; religion; national origin; gender, including sexual harassment; age; disability; citizenship; and veteran status. In addition, it is UT Southwestern policy to prohibit discrimination on the basis of sexual orientation, gender identity, or gender expression.

Copyright 2017.The University of Texas Southwestern Medical Center5323 Harry Hines Blvd., Dallas, Texas 75390Phone [phone]