Principal Data Engineer, Department of Psychiatry and Behavioral Sciences, Dell Medical School

Job Posting Title:

Principal Data Engineer, 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, 2024

----

Location:

AUSTIN, TX

----

Job Details:

General Notes

This is a grant funded position with an end date of 8/31/24, renewable based upon availability of funding, work performance, and progress toward research goals. Funding is expected to continue.

Purpose

The Departments of Psychiatry and Behavioral Sciences and Neurology seek a Principal Data Engineer to develop, implement, and maintain software for the collection, analysis, reporting, and presentation of data. This position will support projects across multiple grants. This person will collaborate closely with health care providers, researchers, faculty, data analysts, IT staff, and team members to build robust custom application projects. The ideal candidate is hands-on and highly capable of taking initiative for designing, prototyping, implementing, and providing long term support by effectively incorporating user and stakeholder input, and handling projects from database to application layer to effective UI.

Responsibilities

• Work with multiple stakeholders to develop detailed designs to meet goals for research data needs, utilizing a unique blend of clinical insight and technical prowess. Collaborate with department teams to create secure, reliable, scalable solutions using a lean and agile approach. Work with others on the team for managing integration with servers and environments including account creation, security, application deployment, and script creation.

• Develop/support pipelines for the secure automated extract, transform, and load of data from sources to data warehouses. Develop views, computation algorithms, and integration code to support dynamic data visualizations, dashboards, and data products.

• Develop tools for ongoing data capture, curation, and validation to ensure data accuracy and consistency. Manage data versioning, maintaining snapshots and documentation for backups and data reproducibility.

• Work with researchers and interdisciplinary team to develop data analysis and visualization products that empower end users to extract valuable insights while ensuring the security of both identified and deidentified data.

• Develop robust documentation for data processes, data dictionaries, management, etc.

• Other related duties as assigned.

Required Qualifications

Bachelor's degree with at least 5 years of relevant experience in software development, data engineering, system administration, production experience, or related field. Knowledgeable in software development on complex systems and at least 2 computer programming languages. Demonstrated ability to design, debug, and test complex code in at least one data-focused scripting language (Python plus one other such as R). Possess a broad and deep knowledge of data software development and infrastructure (microservices, operating system configuration and scripting) in both on-prem and cloud environments. Experience writing and optimizing complex SQL queries for data extraction utilizing both database clients and command line scripting. An understanding of database architecture, data normalization, data security, and scaling/performance principles. Experience in handling sensitive data, such as Protected Health Information (PHI), while adhering to HIPAA, FERPA, Common Rule, and other regulations within higher education and/or healthcare. Relevant education and experience may be substituted as appropriate.

Preferred Qualifications

Bachelor's degree with more than 5 years of relevant experience in software development, system administration, production experience, or related field. Experience and/or desire to work with medical data with an understanding of regulatory requirements and security measures for handling sensitive data, such as Protected Health Information (PHI), while adhering to HIPAA, FERPA, Common Rule, and other regulations within higher education and/or healthcare. (The candidate will need to pass CITI certification tests on this topic for access to the data we handle). Experience with REDCap, clinical or other data systems in a clinical setting is preferred. PostgreSQL and experience with 2 or more database architectures is preferred. Experience with other data query languages in addition to SQL such as GraphQL. Experience with AWS (Amazon Web Service) data platform. Collaborative software development experience using python and python libraries in a distributed cloud-based or enterprise environment. Experience with software versioning systems, integration and ETL pipelines, and APIs. Commitment to collaborative documentation and sharing of code. UI design and development experience: interactive data-driven webpages, web applications, dashboards utilizing tools such as html, css, JavaScript, Django, React, Node.js, AngularJS, and D3.js. Experience working with end-users to design, prototype, and maintain interactive websites. Skills implementing and supporting data science and data visualization: Matlab, R, pandas, Jupyter notebooks, tableau, other analysis and visualization tools/libraries. Demonstrated levels of creativity and ingenuity in prior projects.

Salary Range

$90,000+ depending on qualifications

Working Conditions

• Repetitive use of a keyboard at a workstation.

• Occasional weekend, overtime and evening work to meet deadlines.

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.