Data Manager, Department of Psychiatry and Behavioral Sciences, Dell Medical Sch Full-time Job

Job Posting Title:Data Manager, Department of Psychiatry and Behavioral Sciences, Dell Medical School----Hiring Department:Department of Psychiatry----Position Open To:All Applicants----Weekly Scheduled Hours:40----FLSA Status:Exempt----Earliest Start Date:Immediately----Position Duration:Expected to Continue Until Aug 31, 2023----Location:UT MAIN CAMPUS----Job Details:General NotesThis position has an end date of August 31, 2023 and is renewable annually based upon availability of funding, work performance, and progress toward goals. PurposeThis position will support the Assistant Directors of Research Operations and Child Mental Health Programs by managing data needs for the Dell Medical School - Department of Psychiatry and Behavioral Health's multi-site Texas Childhood Trauma Research Network (TX-CTRN), Texas Child Health Access Through Telemedicine (TCHATT), and Child Psychiatry Access Network (CPAN) programs.ResponsibilitiesPerform data management functions, data manipulation, and dataset preparation for client analyses involving multiple stakeholders.Receive, manage and deliver requested data tasks; work with data requestors to translate data requests into logical queries using standard language and tools.Follow a documented, transparent process for each request with an overarching service orientation and customer satisfaction approach.Serve as an internal resource to investigators and research personnel to answer questions related to data access, data aggregation, and data management.Troubleshoot with data requesters, data analysts, and research staff at different sites to resolve data quality issues and data discrepancies.Work closely with investigators, research staff, biostatistics, data analytics, and informatics sta across all network partner institutions as part of the TX-CTRN Data Core.Extract, clean, and manage data collected via REDCap application or from SQL data warehouse by following approved processes/protocols for ad hoc data requests to support publications approved by the CTRN publication committee.Extract data from the TX-CTRN data warehouse for ad hoc operational needs (e.g., monitoring enrollment and retention of participants by sites).Work with Texas Advanced Computing Center (TACC) data systems engineer personnel to refine data warehouse views, reports, and dashboards based on needs identified by research requests and operational requests.Work with TACC data systems engineer personnel in design and development of automated ETL processes.Develop understanding of the data collected in REDCap with an understanding of the workflow of data capture and attributes of fields. This includes an understanding of what is being measured through the instrument scales and data quality and curation workflows.Develop working knowledge of the extract, transform, and load (ETL) processes of the data from REDCap to the TX-CTRN Data Warehouse.Monitor for compliance with regulatory, internal and partner requirements (such as IRB approval, Dell Medical School and TX-CTRN policies) needed to access or share health data.Other duties as assigned.Required QualificationsBachelor's degree and five (5) years experience in a data-related eld such as data analytics or database management in a healthcare or research environment. Proficiency in writing SQL queries. Working knowledge of data analysis and manipulation software such as R or Python. Basic statistical knowledge for descriptive statistics and data cleaning/validation. Working knowledge of database management principles and various data architectures. Highly proficient in Microsoft Word, Excel, and PowerPoint, with the proven ability to produce professional documents in MS Power Point and develop complex Excel models. Ability to work with and capitalize on a diverse group of professional skills and personalities in a collaborative team environment. Demonstrated excellent analytical skills, problem solving ability and strong critical thinking skills. High degree of self-motivation and ability to work efficiently and flexibly in a fast-paced environment with minimal guidance. Excellent verbal and written communication skills with proven ability to effectively communicate with all levels of management and staff tactfully, clearly, and concisely. Outstanding organizational and time-management skills. Professional demeanor with tact and respect at all times. Ability to address individuals and information with a high degree of sensitivity and confidentiality in various delicate, formal or urgent situations. Ability to succeed in a fast-paced and fluid work environment. The Dell Medical School is especially interested in qualified candidates who can contribute to diversity and excellence within the learning health system. At the Dell Medical School we strive to create a vital, inclusive health ecosystem. To ensure alignment, we follow these fundamental values: . Relevant education and experience may be substituted as appropriate.Preferred QualificationsMaster's degree in Medical Informatics or a related field. More than five (5) years experience in a data-related position in health care delivery. Application of data privacy practices and laws to ensure privacy, condentiality and security, including HIPAA. Familiarity with Electronic Medical Records and/or psychological assessment scales and measures. Management and analysis of large, complex clinical/non-clinical data. Translation of research questions into appropriate statistical methods. Working knowledge of REDCap application for research data survey collection. Working knowledge of database system administration such as PostgreSQL or MySQL. Working knowledge of common statistical packages such as SAS, Stata, R, or SPSS. Working knowledge of dashboarding applications such as Tableau or Power BI. Working knowledge of application programming interface (API) management and development and automated ETL processes.Salary Range$85,000 + depending on qualificationsWorking ConditionsMay work around standard office conditionsRepetitive use of a keyboard at a workstationOccasional weekend, overtime and evening work to meet deadlinesThis position will be assigned on-campus with an expectation to work on-site for most of the scheduled work week. The supervisor will work with the employee to identify the needs of the school, in order to allow for 2 Flex Days per week where you are approved to work remotely should you so desire. Remote work will require reliable internet access and a suitable workspace free from distractions. When working on-campus, employees will be expected to comply with the COVID-19 social distancing and safety guidelines that are in place. Required MaterialsResume/CV3 work references with their contact information; at least one reference should be from a supervisorLetter of interestImportantfor applicants who are NOT current university employees or contingent workers:You will be prompted to submit your resume the first time you apply, then you will be provided an option to upload a new Resume for subsequent applications. Any additional Required Materials (letter of interest, references, etc.) will be uploaded in the Application Questions section; you will be able to multi-select additional files. Before submitting your online job application, ensure thatALLRequired Materials have been uploaded. Once your job application has been submitted, you cannot make changes.Important for Current university employees and contingent workers:As a current university employee or contingent worker, you MUST apply within Workday by searching for Find UT Jobs. If you are a current University employee, log-in to Workday, navigate to your Worker Profile, click the Career link in the left hand navigation menu and then update the sections in your Professional Profile before you apply. This information will be pulled in to your application. The application is one page and you will be prompted to upload your resume. In addition, you must respond to the application questionspresented to upload any additional Required Materials (letter of interest, references, etc.) that were noted above.----Employment Eligibility:Regular staff who have been employed in their current position for the last six continuous months are eligible for openings being recruited for through University-Wide or Open Recruiting, to include both promotional opportunities and lateral transfers. Staff who are promotion/transfer eligible may apply for positions without supervisor approval.----Retirement Plan Eligibility:The retirement plan for this position is Teacher Retirement System of Texas (TRS), subject to the position being at least 20 hours per week and at least 135 days in length.----Background Checks:A criminal history background check will be required for finalist(s) under consideration for this position.----Equal Opportunity Employer:The University of Texas at Austin, as an ,complies with all applicable federal and state laws regarding nondiscrimination and affirmative action. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, national origin, age, marital status, sex, sexual orientation, gender identity, gender expression, disability, religion, or veteran status in employment, educational programs and activities, and admissions.----Pay Transparency:The University of Texas at Austin will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.----Employment Eligibility Verification:If hired, you will be required to complete the federal Employment Eligibility Verification I-9 form. You will be required to present acceptable and original to prove your identity and authorization to work in the United States. Documents need to be presented no later than the third day of employment. Failure to do so will result in loss of employment at the university.----E-Verify:The University of Texas at Austin use E-Verify to check the work authorization of all new hires effective May 2015. The university's company ID number for purposes of E-Verify is 854197. For more information about E-Verify, please see the following: [PDF] [PDF] [PDF] [PDF]----Compliance:Employees may be required to report violations of law under Title IX and the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act (Clery Act). If this position is identified a Campus Security Authority (Clery Act), you will be notified and provided resources for reporting. Responsible employees under Title IX are defined and outlined in .The Clery Act requires all prospective employees be notified of the availability of the Annual Security and Fire Safety report. You may or obtain a copy at University Compliance Services, 1616 Guadalupe Street, UTA 2.206, Austin, Texas 78701.