Address
Form of workJob Posting Title:
Senior Data Quality Engineer
----
Hiring Department:
University Development Office
----
Position Open To:
All Applicants
----
Weekly Scheduled Hours:
40
----
FLSA Status:
Exempt
----
Earliest Start Date:
Oct 25, 2023
----
Position Duration:
Expected to Continue
----
Location:
AUSTIN, TX
----
Job Details:
Purpose
This position reports to the Director of Data Management and resides on the Data Engineering and Integrations team. The Sr. Data Quality/Integrations Engineer will take ownership of end-to-end Data Quality and will work closely with the Applications Development, Records Management, and Reporting and Analytics teams and fellow integrations engineers to ensure that data assets relating to both applications and business intelligence systems are accurate, consistent, and reliable. The Sr. Data Quality/Integrations Engineer will be a key contributor for University Development Office's upcoming new CRM (Customer Resource Management) implementation.
Responsibilities
Required Qualifications
Relevant education and experience may be substituted as appropriate.
Preferred Qualifications
Salary Range
$95,000 + depending on qualifications
Required Materials
Importantfor 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:
----
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.
Senior Data Quality Engineer
----
Hiring Department:
University Development Office
----
Position Open To:
All Applicants
----
Weekly Scheduled Hours:
40
----
FLSA Status:
Exempt
----
Earliest Start Date:
Oct 25, 2023
----
Position Duration:
Expected to Continue
----
Location:
AUSTIN, TX
----
Job Details:
Purpose
This position reports to the Director of Data Management and resides on the Data Engineering and Integrations team. The Sr. Data Quality/Integrations Engineer will take ownership of end-to-end Data Quality and will work closely with the Applications Development, Records Management, and Reporting and Analytics teams and fellow integrations engineers to ensure that data assets relating to both applications and business intelligence systems are accurate, consistent, and reliable. The Sr. Data Quality/Integrations Engineer will be a key contributor for University Development Office's upcoming new CRM (Customer Resource Management) implementation.
Responsibilities
- Ensure high quality of data delivered to internal stakeholders and users within the University Development Office
- Identify, rectify, and continually improve quality of data in current and future CRM
- Identify, architect, and implement process improvements to data systems
- Create diagnostic reports on Data Quality issues
- Clean and append data from 3rd party vendors into application layer databases
- Design, implement, and maintain secure and performant integration/ETL pipelines from source system to DW/BI environment
- Maintain data integrity within warehouse ecosystem.
- Monitor and troubleshoot nightly data loads
- May occasionally require extended work hours or on-call duties
Required Qualifications
- Bachelor's degree.
- 2+ years of experience with database management
- 2+ years of experience with SQL development
- 2+ years of experience with building integrations/ETL pipelines
- Experience working with AWS and other cloud based tools (Delta Lake, DBT, Cloud Formation, Redshift, etc.)
- Experience writing complex SQL queries and working with large amounts of data
- Experience with data appends and data cleansing techniques
- Experience with data analysis
- Experience with shell scripting: Perl, Python, Bash or similar
- Demonstrated understanding of Data Warehousing and Business Intelligence concepts
- Demonstrated understanding of SDLC concepts
- Demonstrated understanding of Data Ops concepts
- Must be authorized to work for the US. We are unable to sponsor H1B visas at this time
- Attention to detail and excellent written and oral communication skills
- Ability to shift priorities quickly, without losing track of projects
- Skilled at data analysis, documentation, and troubleshooting
- Aptitude at acquiring business knowledge and translating business needs
- Ability to work collaboratively across several different teams
Relevant education and experience may be substituted as appropriate.
Preferred Qualifications
- More than three years of applicable experience
- Substantial experience with Oracle
- Experience with integrations and scheduling tools such as AWS Glue, Mulesoft, and Stonebranch
- Experience with AWS tools: Cloud Formation, IAM, VPC, EC2, S3, Redshift, RDS Postgres, etc.
- Experience working with sensitive data (ie. HIPAA, FERPA, PCI)
- Experience with Linux system administration in an enterprise environment
- Familiarity with UT Austin ITS resources
- Familiarity with fundraising and advancement business processes
Salary Range
$95,000 + depending on qualifications
Required Materials
- Resume/CV
- 3 work references with their contact information; at least one reference should be from a supervisor
- Letter of interest
Importantfor 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.
