Data Analytics Engineer

Job Posting Title:

Data Analytics Engineer

—-

Hiring Department:

Financial and Administrative Services

—-

Position Open To:

All Applicants

—-

Weekly Scheduled Hours:

40

—-

FLSA Status:

To Be Determined at Offer

—-

Earliest Start Date:

Ongoing

—-

Position Duration:

Limited Duration Based on Business Need

—-

Location:

AUSTIN, TX

—-

Job Details:

General Notes

This requisition will be used to fill one fixed term position expected to end October 31, 2026.

Reporting to the Data Business Partner (DBP) for the VP/CFO and VP for People and Talent business teams, provide business leaders with direction as a data analytics engineer subject matter expert. Your primary object is to deliver sustainable, accurate, and automated analytics including data modeling, data analytics, and business reporting visualizations.

You’ll collaborate with UT’s Data to Insights (D2I) team, IT functional teams, primary business stakeholders, and downstream data consumers to remove barriers, solve complex data challenges, and ultimately deliver on your primary objective. You will assist and advice your engineering counterparts to build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using industry leading ‘big data’ technologies. You’ll build automated foundational data processes, integrating data quality monitoring and alert systems while integrating large, complex data sets that meet business requirements.  

The University of Texas at Austin provides an outstanding benefits package to staff, including: 

• Competitive health benefits (Employee premiums covered at 100%; family premiums at 50%)
• Vision, dental, life, and disability insurance options
• Paid vacation, sick leave, and holidays
• Teachers Retirement System of Texas (a defined benefit retirement plan)
• Additional voluntary retirement programs: tax sheltered annuity 403(b) and a deferred compensation program 457(b)
• Flexible spending account options for medical and childcare expenses
• Training and conference opportunities
• Tuition assistance
• Athletic ticket discounts
• Access to UT Austin’s libraries and museums
• Free rides on all UT Shuttle and Capital Metro buses with staff ID card

For more details, please see: https://hr.utexas.edu/prospective/benefits and https://hr.utexas.edu/current/services/my-total-rewards  

This position requires you to maintain internet service and a mobile phone with voice and data plans to be used when required for work.

Must be authorized to work in the United States on a full-time basis for any employer without sponsorship. Must be located in the state of Texas.

Purpose

We are seeking an Analytics Engineer to join the Data Business Partner team. As an Analytics Engineer, you operate at the intersection of data analytics, data engineering, and business intelligence to build robust, efficient, and scalable data structures to support high-quality, nuanced, and timely data analytics to empower strategic decisions and policies by University leadership and stakeholders.

Responsibilities
Data Analytics & Data Visualizations

• Processes, transforms, analyzes, interprets, builds, and disseminates data into meaningful, eye-catching, and consumable data visualizations, reports, dashboards, and other tools to support University decision-making.
• Applies advanced coding, data visualization techniques, and other analytical skills to translate business logic and produce deliverables in response to routine and non-routine data requests using BI tools such as PowerBI or Tableau.
• Develops, codes, validates, and implements relational databases and integrated data structures that support analytics.
• Crafts code for the translation and transformation of functional business logic into a high-scale database environment that can readily support the production of descriptive, predictive, and prescriptive analytics and consumable reports, dashboards, and other tools to support University decision-making.
• Understands how to best design database structures for meaningful data visualizations and interactive tools.
• Engages in best practices in data analytics and data engineering – including robust validation processes, testing/deployment procedures, algorithms for data mining, version control and code integration, thorough documentation, and automation and streamlining of data processing pipelines.
• Applies creativity and flexibility to finding solutions for new institutional data challenges.
• Assists with special projects and ad hoc data requests as needed.

Collaboration, Communication, & Institutional Knowledge

• Works both independently and collaboratively with cross-functional teams to develop exceptional data products to meet university needs.
• Participates in the Data Project Lifecycle – from conception, requirements gathering and design, documentation, development and testing through deployment.
• Engages and communicates with partners and stakeholders to manage requests, expectations, and deliverables.
• Effectively communicates project status, progress, risks, and issues to drive project to completion.
• Develops an in-depth knowledge of university data processes and technologies.
• Consult with data analysts on specific data and coding questions within and outside of the team.
• Handles confidential information with tact and discretion.

Required Qualifications

Bachelor’s degree with quantitative experience or at least 4 years of professional experience in information technology or related field. Demonstrated passion for using data to answer questions and solve problems. Demonstrated proficiency in using data software such as PowerBI(DAX), Excel, Tableau, SQL, R or Python to query and model data, manipulate and validate data, implement business logic, and analyze data. Excellent knowledge of databases, data flows, and data manipulation in both operational and analytical contexts. Proven ability to synthesize complex and/or ambiguous information from multiple sources using a variety of tools and techniques to transform that information into consumable insights. Ability to communicate effectively with a wide range of stakeholders to gather data requirements and produce appropriate analysis. Excellent interpersonal skills to positively contribute to collaborative team, influence without authority, and thoughtfully and productively give and receive feedback. Proven prioritization and organizational skills with the ability to handle multiple projects simultaneously. Excellent written and verbal communication skills, critical thinking and creative problem-solving, documentation habits, and attention to detail. Demonstrated ability to maintain a high level of professionalism.

Relevant education and experience may be substituted as appropriate.

Preferred Qualifications

Experience working in Microsoft, Amazon Redshift, and PostgreSQL environments. Expert in SQL database design for the purposes of scaling and supporting business intelligence and analytical needs. Experience in multiple BI visualization tools such as PowerBI and Tableau. Experience in higher education administration, programming, or analysis. Knowledge of federal education law and policies related to education records.

Salary Range

$88,000 + depending on qualifications

Working Conditions

• This position is eligible for hybrid remote work in the state of Texas. Incumbents may be asked to work from the UT Austin Campus in Austin, Texas on occasion for collaboration with peers.
• If working on campus, a standard office environment will be provided

Required Materials

• Resume/CV
• 3 work references with their contact information; at least one reference should be from a supervisor
• Letter of interest
• Finalists will be asked to complete assessments applicable to this role.

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.

#LI-Hybrid

—-

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.