Sr. Department Data Analyst, Pediatrics

UT Southwestern Medical Center • Dallas, TX

2d • Hybrid

About The Position

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

This senior-level role will support the Program Manager and a Department Data Analyst in developing, maintaining, and enhancing clinical and productivity reporting for the Department of Pediatrics. The position will leverage tools including Excel, Access, SQL, Python, and Power BI. Given the breadth of reporting needs, some reports will require manual data input, while others will be fully automated or a hybrid of both.
The role requires strong programming skills, including proficiency in VBA and Python, as well as the ability to write complex SQL queries. Extensive use of Excel is expected, along with workflows that incorporate the Microsoft Power Platform (Power Apps, Power Automate, Power BI) and SharePoint.
A major initiative currently underway is the conversion of legacy Excel, Access, and SAS-based processes into Power BI solutions. This role will work collaboratively across the department, internal teams, and external partners to ensure data is appropriately structured, extracted, and automated as needed. Automation of data pipelines and reporting (using VBA, SQL, Python, Power BI, and Power Platform tools) will be a key priority.
Being a Power User in Excel and/or having certifications for PowerBi (PL-300 or PL-900) is preferred.
We are seeking a detail-oriented, self-motivated individual who is eager to learn and thrive in a collaborative environment. This position is fully on-site during the training period and a possibility to be a hybrid schedule thereafter. The ideal candidate resides in the Dallas–Fort Worth metroplex and is willing to commute to the hospital campus near downtown Dallas.

Requirements

• 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.

Nice To Haves

• Master's Degree
• Work in a clinical or healthcare related field
• Familiarity with scientific terms (in biology, biochemistry, chemistry, etc.)
• Being a Power User in Excel and/or having certifications for PowerBi (PL-300 or PL-900)

Responsibilities

• 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.

Benefits

• PPO medical plan, available day one at no cost for full-time employee-only coverage
• 100%25 coverage for preventive healthcare-no copay
• 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
• Learn more about these and other UTSW employee benefits!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level