Sr Department Data Analyst

%3Cp%3E%3Cstrong%3EWHY UT SOUTHWESTERN?%3C/strong%3E%3Cbr%3EWith 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 %3Ci%3EU.S. News %26amp; World Report%3C/i%3E, 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!%26nbsp;%3Cbr%3E%3Cbr%3E%3Cstrong%3EJOB SUMMARY%3C/strong%3E%3Cbr%3EWorks with relatively low supervision to provide data acquisition, management and report design/generation to users of data.%26nbsp;%3C/p%3E%3Cul%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height%5C:normal;margin-bottom%5C:0in;%22%3EAdminister, maintain, and optimize databases within Microsoft Azure environments, including Azure SQL Database, Azure SQL Managed Instance, and Azure Data Lake Storage.%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height%5C:normal;margin-bottom%5C:0in;%22%3EDesign, develop, and support ETL/ELT processes using Microsoft Fabric, including Data Factory pipelines, Dataflows, and Lakehouse solutions.%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height%5C:normal;margin-bottom%5C:0in;%22%3EImplement and manage data ingestion, transformation, orchestration, and integration processes from multiple source systems.%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height%5C:normal;margin-bottom%5C:0in;%22%3EDevelop, test, and maintain SQL queries, stored procedures, views, and related database objects.%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height%5C:normal;margin-bottom%5C:0in;%22%3EMonitor and enhance database performance, availability, and capacity through proactive tuning and optimization.%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height%5C:normal;margin-bottom%5C:0in;%22%3EImplement backup, recovery, and disaster recovery strategies to ensure business continuity.%3C/p%3E%3C/li%3E%3Cli%3E%3Cp class=%22MsoNormal%22 style=%22line-height%5C:normal;margin-bottom%5C:0in;%22%3EOther duties as assigned.%3Cbr%3E%26nbsp;%3C/p%3E%3C/li%3E%3C/ul%3E%3Cp%3E%3Cstrong%3EBENEFITS%3C/strong%3E%3Cbr%3EUT 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%5C:%3C/p%3E%3Cul%3E%3Cli%3EPPO medical plan, available day one at no cost for full-time employee-only coverage%3C/li%3E%3Cli%3E100% coverage for preventive healthcare-no copay%3C/li%3E%3Cli%3EPaid Time Off, available day one%3C/li%3E%3Cli%3ERetirement Programs through the Teacher Retirement System of Texas (TRS)%3C/li%3E%3Cli%3EPaid Parental Leave Benefit%3C/li%3E%3Cli%3EWellness programs%3C/li%3E%3Cli%3ETuition Reimbursement%3C/li%3E%3Cli%3EPublic Service Loan Forgiveness (PSLF) Qualified Employer%3C/li%3E%3Cli%3E%3Ca href=%22http%5C://jobs.utsouthwestern.edu/

benefits

/#top%22 target=%22_blank%22%3ELearn more about these and other UTSW employee

benefits

!%3C/a%3E%3C/li%3E%3C/ul%3E%3Cp%3E%3Cbr%3E%3Cbr%3E%3Cstrong%3EEXPERIENCE AND EDUCATION%3C/strong%3E%3Cbr%3E%3Cbr%3E%3Cstrong%3ERequired%3C/strong%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cstrong%3EEducation%3C/strong%3E%3Cbr%3EBachelor%27s Degree in Science, Information Management, Healthcare Information, Statistics, Business or closely related field.%26nbsp;%3Cbr%3E%26nbsp;%3C/li%3E%3C/ul%3E%3Cul%3E%3Cli%3E%3Cstrong%3EExperience%3C/strong%3E%3Cbr%3E5 years of Data management/analyst experience%26nbsp;%3Cbr%3EA combination of equivalent education and experience will be considered.%26nbsp;%3Cbr%3E%26nbsp;%3C/li%3E%3C/ul%3E%3Cp%3E%3Cstrong%3EPreferred%3C/strong%3E%3C/p%3E%3Cul%3E%3Cli%3E%3Cstrong%3EEducation%3C/strong%3E%3Cbr%3EMaster%27s Degree%26nbsp;%3Cbr%3E%26nbsp;%3C/li%3E%3C/ul%3E%3Cul%3E%3Cli%3E%3Cstrong%3EExperience%3C/strong%3E%3Cbr%3EWork in a clinical or healthcare related field%26nbsp;%3Cbr%3EFamiliarity with scientific terms (in biology, biochemistry, chemistry, etc.)%26nbsp;%3Cbr%3E%26nbsp;%3C/li%3E%3C/ul%3E%3Cp%3E%3Cbr%3E%3Cstrong%3EJOB DUTIES%3C/strong%3E%3C/p%3E%3Cul%3E%3Cli%3EPrimary data steward responsible for all department databases, source systems and data structures.%3C/li%3E%3Cli%3EResponsible 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.%3C/li%3E%3Cli%3EEnsure accuracy of data and reporting across department functions, mitigating against any audit/data risk by setting processes to validate data an on ongoing basis.%3C/li%3E%3Cli%3EManages 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.%3C/li%3E%3Cli%3EAssists Department Data Analysts of lower status with data needs and project coordination.%3C/li%3E%3Cli%3EServes 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.%3C/li%3E%3Cli%3EServes as lead technical contact for relevant data points and sources systems for institutional projects/platforms (i.e. EDW, Organizational Dashboards, etc.)%3C/li%3E%3Cli%3ECoordinates 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.%3C/li%3E%3Cli%3EResponsible for data mapping/data architecture across department data fields and relevant source systems, utilizing process maps and Business Intelligence architecture tools.%3C/li%3E%3Cli%3ELeads 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.%3C/li%3E%3Cli%3EPerforms other duties as assigned.%3C/li%3E%3C/ul%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%26nbsp;%3C/span%3E%3C/p%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%3Cstrong%3EKnowledge, Skills and Abilities%3C/strong%3E%3C/span%3E%3C/p%3E%3Cul%3E%3Cli%3EWork requires knowledge of relational databases, query reporting and report specifications development.%3C/li%3E%3Cli%3EWork requires knowledge of database and report writing software (ie Access, Business Objects and Crystal).%3C/li%3E%3Cli%3EWork requires analytical problem solving skills and attention to details.%3C/li%3E%3Cli%3EWork requires ability to coordinate and work independently on projects.%3C/li%3E%3Cli%3EWork requires ability to communicate effectively with various levels of internal and external contacts concerning general policies and procedures.%3C/li%3E%3Cli%3EWork requires ability to work with confidential information on daily basis.%3C/li%3E%3Cli%3EAbility to plan and organize work in logical and efficient manner.%3C/li%3E%3C/ul%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%26nbsp;%3C/span%3E%3C/p%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%3Cstrong%3EPHYSICAL REQUIREMENTS/WORKING CONDITIONS%3C/strong%3E%3C/span%3E%3C/p%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%26nbsp;%3C/span%3E%3C/p%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%3Cstrong%3EPhysical Requirements%3C/strong%3E%3C/span%3E%3C/p%3E%3Cul%3E%3Cli%3ETalking%3C/li%3E%3C/ul%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%26nbsp;%3C/span%3E%3C/p%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%3Cstrong%3EWorking Conditions%3C/strong%3E%3C/span%3E%3C/p%3E%3Cul%3E%3Cli%3EOffice Setting%3C/li%3E%3C/ul%3E%3Cp style=%22font-size%5C:9pt;margin-bottom%5C:0pt;margin-top%5C:0pt;%22%3E%3Cspan style=%22font-family%5C:Verdana;%22%3E%26nbsp;%3C/span%3E%3C/p%3E%3Cp%3E%3Cstrong%3ESalary Information%3C/strong%3E%3Cbr%3ESalary is commensurate with education, skills, and relevant experience.%3Cbr%3E%3Cbr%3E%3Cstrong%3ESECURITY AND EEO STATEMENT%3C/strong%3E%3Cbr%3E%3Cbr%3E%3Cstrong%3ESecurity%3C/strong%3E%3Cbr%3EThis position is security-sensitive and subject to Texas Education Code 51.215, which authorizes UT Southwestern to obtain criminal history record information.%3Cbr%3E%3Cbr%3E%3Cstrong%3EEEO%3C/strong%3E%3Cbr%3EUT 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.%3Cbr%3E%26nbsp;%3C/p%3E