Senior Consultant, Data Analytics Engineering

Job Posting Title:

Senior Consultant, Data Analytics Engineering

----

Hiring Department:

Financial and Administrative Services

----

Position Open To:

All Applicants

----

Weekly Scheduled Hours:

40

----

FLSA Status:

Exempt

----

Earliest Start Date:

Apr 14, 2025

----

Position Duration:

Expected to Continue Until Apr 14, 2028

----

Location:

UT MAIN CAMPUS

----

Job Details:

General Notes

Reporting to the Data Business Partner (DBP) for the VP/CFO, provide business leaders with direction as a Sr. Data Analytics Engineer and finance 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 leaders, 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 advise 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. You lead the development and refinement of Financial Data Models and forecasts as well as drive operational efficiency and optimization with the use of automation and AI.

More Information can be found here: https://financials.utexas.edu/

You’ll be working for a university that is internationally recognized for our academic programs and research. Your work will contribute to operational excellence and enhance the student experience. If you’re the type of person that wants to know your work has meaning and impact, you’ll like working in our department and for UT Austin. UT Austin provides an outstanding benefits package including but not limited to: 

• Competitive health benefits (employee premiums covered at 100%, family premiums at 50%) 
• Voluntary Vision, Dental, Life, and Disability insurance options 
• Generous paid vacation, sick time, and holidays 
• Teachers Retirement System of Texas, a defined benefit retirement plan, with employer matching funds 
• 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 
• Robust free training access through LinkedIn Learning plus professional conference opportunities 
• Tuition assistance 
• Expansive employee discount program including athletic tickets 
• Free access to UT Austin's libraries and museums with staff ID card 
• Free rides on all UT Shuttle and Austin CapMetro 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 

Responsibilities

• Developing and engineering Data Models to deliver on expected business outcomes.
• Developing and publishing PowerBI reports along with supporting documentation and training to support business continuances.
• Supporting financial analytic requirements and requests as needed. The presenting findings to leadership and other business constituencies. Examples include forecast models and predictive analytics.
• Collaborate with Business SMEs, FAPA Team, and other data teams at UT Austin to create data standards, improve data integrity, and produce sustainable, repeatable outcomes.
• Project Management of owned reporting and analytic outcomes.
• Additional duties as required to deliver on overall expected outcomes for FAPA team.

Required Qualifications

• Bachelor’s degree in finance & accounting or other quantitative type degree or at least 10 years of professional experience in financial analytics with Power BI.
• Demonstrated passion for using data to answer questions and solve problems.
• Demonstrated proficiency in using Microsoft Fabric with Power BI, and Microsoft SQL Server or Azure to query large databases, 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.
• Extensive experience and training in systems conceptualization, analysis, design, and implementation

Relevant education and experience may be substituted as appropriate.

Preferred Qualifications

• R or Python, Amazon Redshift, Greenplum, and/or PostgreSQL environments. Expert at data analytics and data modeling for the purposes of scaling and supporting business intelligence and analytical needs.
• Experience with Microsoft PowerBI/IBM Cognos/Tableau or other data visualization tools.
• Experience in higher education administration, programming, or analysis. Knowledge of federal education law and policies related to education records.

Salary Range

145,000/yr

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.