Power BI Analyst

Title: Power BI Analyst

Location: Austin United States

Job type: Hybrid
Time Type: Full Time
Job id: R_00044081
 

Job Description:

Job Posting Title:

Power BI Analyst
Hiring Department:

Financial and Administrative Services

Position Open To:

Weekly Scheduled Hours: 40FLSA Status:

Exempt Earliest Start Date:

Immediately

Position Duration:

Expected to Continue Until Oct 30, 2027:

General Notes

The Data Analyst is responsible for designing, developing, and maintaining enterprise analytics and reporting solutions with a strong emphasis on Power BI semantic modeling, advanced DAX, and SQL-based analysis. This role supports university leadership by delivering trusted, scalable, and well-governed data products used for financial, workforce, and operational decision-making.

This position goes beyond report creation and focuses on data modeling, metric definition, validation, and performance optimization.

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

This position provides life/work balance with typically a 40-hour work week and travel generally limited to training (e.g., conferences/courses).

This position is expected to continue until October 30, 2027.

Your skills will make a difference.

You'll be working for a university that is internationally recognized for our academic programs and research. Your work will make a difference in the lives of university staff, thereby enhancing 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
• 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

Must be authorized to work in the United States on an ongoing, full-time basis for any employer without sponsorship.

Purpose

We are seeking a Data Analyst to join the office of the CFO. As Data Analyst, you operate at the intersection of data analytics, data wrangler, 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

Power BI & Data Modeling

• Design, develop, and maintain Power BI semantic models and datasets using dimensional and star-schema best practices.
• Build scalable and high-performing models to support enterprise and executive reporting.
• Implement and maintain Row-Level Security (RLS) and adhere to established data governance standards.
• Optimize model performance through effective management of relationships, cardinality, storage modes, and aggregations.

DAX Measure Development & Validation

• Develop and maintain advanced DAX measures, including time intelligence, virtual tables, and complex filtering logic.
• Refactor and optimize existing DAX to improve performance and accuracy.
• Translate business rules and policy definitions into validated, reusable calculations.
• Document metric definitions and ensure consistency across reports and datasets.

SQL Querying & Analytical Support

• Write and maintain complex SQL queries using joins, CTEs, window functions, and aggregations.
• Validate and reconcile data across multiple systems and sources.
• Partner with data engineering and upstream teams to resolve data quality or integration issues.
• Perform ad hoc analysis to support leadership, planning, and operational decision-making.

Stakeholder Collaboration & Communication

• Collaborate with finance, HR, and operational stakeholders to gather requirements and deliver analytical solutions.
• Translate ambiguous business questions into structured and actionable insights.
• Present findings and recommendations to technical and non-technical audiences.
• Provide guidance on data interpretation, limitations, and appropriate use.

Other Duties as Assigned

• Perform additional duties and responsibilities assigned to support departmental and institutional objectives.
• Participate in meetings, training, documentation, and process improvement efforts as required.
• Support evolving priorities in alignment with organizational needs.

Required Qualifications

• Bachelor's Degree in Analytics, Information Systems, Business, Finance, Computer Science, or a related field.
• 2+ years of professional experience developing analytics or business intelligence solutions.
• Hands-on experience building reports and datasets using Power BI.
• Working knowledge of DAX for calculated measures and business logic.
• Working knowledge of SQL, including joins, aggregations, and basic query optimization.
• Experience working with relational data and structured datasets.

Relevant education and experience may be substituted as appropriate.

Preferred Qualifications

• 4-6+ years of progressive experience in analytics or business intelligence roles.
• Advanced proficiency in Power BI semantic modeling, including star schemas and performance optimization.
• Strong mastery of DAX, including time intelligence, virtual tables, and complex filter context management.
• Advanced SQL skills (CTEs, window functions, query tuning across large datasets).
• Experience supporting financial, payroll, budget, or workforce analytics.
• Experience with Microsoft Fabric, Analysis Services, or Direct Lake models.
• Experience implementing or supporting Row-Level Security (RLS) and governed datasets.
• Experience supporting executive-level or enterprise-wide reporting environments.

Salary Range

$80,000 + depending on qualifications

Working Conditions

• This position is based on-site in Austin, Texas, with up to 50% remote work (The selected candidate must be located in Texas. Texas residents only)
• Typical office environment
• Standard schedule Monday - Friday 8:00 AM - 5:00 PM
• Repetitive use of a keyboard
• Occasional extended work hours or on-call obligation

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 and 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.