Senior Business Data Analyst

About the role

Peak Performers is partnering with a Texas State Agency to find a Senior Business Data Analyst in Austin, TX. The analyst will work across a legacy application, its underlying database, business stakeholders, and an incoming vendor to recover, document, and translate existing reporting logic into requirements for a modernized reporting solution.

Responsibilities

• Reverse engineer legacy reports into documented business logic for a modernized reporting solution.
• Write and run SQL against the legacy database to trace field lineage, validate assumptions, reconcile report totals, and profile source data.
• Interview business users, subject matter experts, and the incumbent vendor to capture report intent, usage, and requirements.
• Build and maintain a data dictionary and business glossary for report‑related terms.
• Identify reports that are redundant, unused, or duplicative and recommend retirement instead of migration.
• Translate legacy logic into future‑state report requirements, acceptance criteria, and test cases for the new vendor.
• Support build, testing, and UAT by serving as the day‑to‑day point of contact for vendor clarification, defect triage, feedback capture, and sign‑off.
• Track open questions, assumptions, and decisions in a shared log for business stakeholders and both vendors.

Requirements

• 8 years of experience as a business analyst supporting data, reporting, or system migration initiatives.
• 5 years of strong SQL experience, including complex joins, window functions, CTEs, aggregation, and working with stored procedures or views written by others.
• 5 years of hands‑on data profiling experience using a tool or SQL written from scratch to identify value domains, null patterns, cardinality, and data quality issues.
• 5 years of strong requirements‑writing experience, producing clear, testable, and specific requirements a third‑party vendor can build from without follow‑up.
• 5 years of experience interviewing non‑technical business users and eliciting intent and business rules that have not previously been documented.
• 3 years of experience running or supporting UAT, including defect triage and stakeholder sign‑off.
• 3 years of experience working with external vendors on requirements clarification, delivery review, and issue resolution.

Preferred Qualifications

• 3 years of experience with Power BI.

Compensation

Rate: $101.00 per hour (W2 contract).

Location & Schedule

Worksite Location: Austin, TX 78701 (Hybrid). Contract Length: 6 months.

Benefits

• Excellent medical health, dental, and vision insurance after 60 days.
• Eligibility to participate in a 403(b) retirement plan.
• Priority placement for qualified applicants with chronic medical conditions and/or disabilities.
• Weekly direct‑deposit payroll.
• Employment contingent on successful pre‑employment criminal background check.
• Work authorization that does not require visa sponsorship now or in the future.