Data Management Technician, CPAN/PeriPAN, Psychiatry and Behavioral Sciences, Dell Medical School

Job Posting Title:

Data Management Technician, CPAN/PeriPAN, 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:

Nov 25, 2024

----

Position Duration:

Expected to Continue Until Aug 31, 2025

----

Location:

AUSTIN, TX

----

Job Details:

General Notes

The Department of Psychiatry and Behavioral Sciences at the Dell Medical School is seeking a Data Management Technician, CPAN/PeriPAN. This position will work as a part of an interdisciplinary, team-based program that cares for patients enrolled in The Child Psychiatry Access Network (CPAN) and the Perinatal Psychiatry Access Network (PeriPAN) programs. These interdisciplinary clinical services programs intended to offer primary care clinic providers and OBGYNs prompt access to on-call psychiatrists to provide expertise in assessment, treatment, and referrals for pediatric and/or perinatal patients identified as having a mental health challenge.

This is a state funded position sponsored by the Texas Child Mental Health Care Consortium (TCMHCC). TCMHCC was created by the 86th Texas Legislature to leverage the expertise and capacity of the health-related institutions of higher education to address urgent mental health challenges and improve the mental health care system in this state in relation to children, adolescents, and perinatal women.

This position has an end date of 8/31/2025, but may be renewable based upon availability of funding, work performance, and progress toward goals.

Purpose

The Data Management Technician, CPAN/PeriPAN will implement data management strategies to support successful implementation, evaluation, and scale of high-stakes behavioral health programs serving students, families, schools, and medical providers across Central Texas.

Responsibilities

• Lead discussions concerning data updates and data management processes with various audiences. Regularly collaborate with team members to identify and fulfill data needs. Recommend data-driven solutions to problem solve, and present to leadership and other stakeholders in a variety of settings, including weekly meetings, and quarterly reports.

• Develop procedures and workflows regarding data. Collect program data generated through a variety of sources, and ensure accuracy, consistency, and completeness in all internal records. Work with Electronic Health Record and related data systems, including Trayt, Athena, 8x8, Welnity, and Salesforce. Compile, clean, and manage data across multiple platforms, using tools including Google Sheets, MS Excel, and Smartsheet. Adhere to and apply appropriate data privacy and security measures, including user privileges, supply data on a regular basis to maintain an updated data dashboard, and manage data access permissions for the data dashboard, using MS PowerBI. Create tables, graphs, charts, and other visualizations to display data, and manage MS PowerBI dashboards on a regular basis. Identify the dashboard’s audience, metrics and analyses of interest. Translate data and findings to a non-technical audience.

• Support the creation and timely submission of data reports, visualizations, and related documents, including data reports, by ensuring quality control of report metrics and underlying data sets.

  Prepare and manipulate data to perform analyses, create visualizations, and present findings on monthly, quarterly, and annual bases to a variety of audiences and stakeholders.

• Develop, troubleshoot, and streamline data operations, data entry workflows, and spreadsheet processes. Conduct data validation, as needed. Fulfill internal and external data requests. Fulfill recurrent and ad hoc data requests, as needed.

• Perform other related duties as assigned.

Required Qualifications

Bachelor’s degree and at least two (2) years professional experience in data management and of experience working with large datasets. Advanced proficiency in at least one data management platform, e.g., MS Excel. Experience with Google Sheet and Excel functions and formulas, e.g. XLOOKUP, INDEX-MATCH, IF functions. Experience creating and maintaining Pivot Tables.  Working knowledge of the Microsoft Suite (e.g. MS Word, MS Excel, MS Outlook, and all related web-based programs). Experience with adherence to and implementation of data management and security policies and procedures. Experience with quantitative data analysis and data visualizations. Experience with creating presentations and presenting to a variety of audiences and stakeholders. Ability to communicate with others in a clear, understandable, and professional manner on the phone and in person, as well as demonstrated use of superior written and verbal communication skills. Ability to interact with peers and program partners in a manner that represents the Dell Medical School positively. Sound judgment in decision-making. Ability to maintain regular, reliable and punctual attendance. Demonstrated ability to be flexible and adaptable to change. Working knowledge of Microsoft Word, Microsoft Excel, and Microsoft Outlook, and web-based programs. 
 

Relevant education and experience may be substituted as appropriate.

Preferred Qualifications

Experience in Data Science, Mathematics, Information Sciences, Public Health, or related research- or data-centered field. Experience with Apps Script/JavaScript. Experience with formal data reporting, e.g. presenting scientific findings to a non-technical audience. Proficiency in data dashboard tools, e.g. MS PowerBI.

Salary Range

$45,000+ depending on qualifications

Working Conditions

• Repetitive use of a keyboard at a workstation

• Occasional weekend, overtime and evening work to meet deadlines

• Occasional interstate, intrastate and international travel

Required Materials

• Resume/CV

• 3 work references with their contact information; at least one reference should be from a supervisor

• Letter of interest

Important for 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 that ALL Required 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 questions presented 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 equal opportunity/affirmative action employer, 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 documents 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:

• E-Verify Poster (English) [PDF]
• E-Verify Poster (Spanish) [PDF]
• Right To Work Poster (English) [PDF]
• Right To Work Poster (Spanish) [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 HOP-3031.

The Clery Act requires all prospective employees be notified of the availability of the Annual Security and Fire Safety report. You may access the most recent report here or obtain a copy at University Compliance Services, 1616 Guadalupe Street, UTA 2.206, Austin, Texas 78701.