JOB SUMMARYWorks 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.
BENEFITSUT 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
- 100% 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!
EXPERIENCE AND EDUCATIONRequired- 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- 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 CONDITIONSPhysical RequirementsWorking ConditionsSalary InformationSalary is commensurate with education, skills, and relevant experience.
