Sr. Department Data Analyst, Pediatrics

Why UT Southwestern Medical Center?

With over 75 years of excellence in Dallas-Fort Worth, Texas, UT Southwestern is committed to excellence, innovation, teamwork, and compassion. At UT Southwestern, we invest in you with opportunities for career growth and development that align with your future goals and help to provide security for you and your family. Our highly competitive benefits package offers healthcare, PTO and paid holidays, on-site childcare, wage, merit increases and so much more that are all available on the day you start work. UT Southwestern is honored to be a Veteran Friendly work environment that is home to approximately 800 veterans. We value your integrity, dedication, and the commitment you've made to our country. We're proud to support your next mission. Ranked by Forbes as one of the Top 10 National Employers, we invite you to be a part of the UT Southwestern team where you'll discover teamwork, professionalism, and consistent opportunities for growth.

Department of Pediatrics

To fulfill our mission of safeguarding the health of children of all ages - the UT Southwestern Department of Pediatrics holds ourselves to the highest standards. This begins with advancing scientific discoveries and delivering exceptional clinical services to serve patients and their families from Dallas, many other parts of the country and beyond. With more than 300 physicians, UT Southwestern has one of the largest pediatric groups Texas. Our clinical expertise includes rare and complex conditions, along with well-care for children. We see a diverse patient population from at facilities throughout our community.

Each of our 19 divisions is relentlessly pursuing scientific discoveries, from basic science to clinical investigation. This includes tackling some of the greatest challenges in pediatric care, from cancer to neurodevelopmental disorders. Ultimately, this research is having better health for children in our community and throughout the world. As part of one of the nation's leading medical schools, we offer wide-ranging educational opportunities that go beyond sharing medical knowledge. This includes opportunities designed for medical students, residents, post-doctoral fellows, and practicing health care professionals.

Our team is nationally recognized for evaluating and treating patients, from newborns to adolescents, as well as fetal care. This includes services provided through our longstanding partnership with Children's Medical Center Dallas, ranked by from U.S. News & World Report as the top pediatric hospital in North Texas and number 16 in the nation for 2023-24. For the sixth consecutive year, all ten specialties ranked among the best in the United States.

Job Summary

The Pediatrics department is hiring for a Sr. Department Data Analyst. This role will help develop and update clinical stats and productivity reporting for the Department of Pediatrics utilizing Excel, Access, and Power BI. With the wide variety of reports, some reports will include manual data input while others are automated reports, or a mixture of the two. This role would be helpful to know how VBA works and how to edit VBA in both Excel and Access documents. This role will also deal processes that use Power Automate and SharePoint. One large project that is in process is to convert some reports to Power BI. This role works collaboratively across teams, departments, and outside entities to get data set up and extracted as needed. Automation will be a priority with data and reports via VBA, SQL, Python, Power BI, etc. This person needs be a critical thinker and inquisitive. This position is hybrid, the ideal candidate will live in the Dallas metroplex and be willing to relocate.

Preferred experience

The ideal candidate will have critical thinking skills, as well as be inquisitive and able to find trends "outside the box". This individual needs to have a statistical/analytical background. Additionally, this candidate will have:

• Experience with Power BI or Tableau
• Working knowledge of a statistical package such as SAS, Python, or R
• Experience with DAX and/or M
• Ability to use Power Query
• Experience working in a health care environment
• Skill with Access and Excel - VBA experience would be preferred
• Working knowledge of SQL

Experience and Education

Bachelor's degree in Science, Information Management, Healthcare Information, Statistics, Business or closely related field and five (5) years data management/analyst experience.

• Work in a clinical or healthcare related field preferred.
• Masters degree preferred.
• Familiarity with scientific terms (in biology, biochemistry, chemistry, etc.) preferred.

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.

To learn more about the benefits UT Southwestern offers, visit https://www.utsouthwestern.edu/employees/hr-resources/

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.