Business Analyst (SQL)

Location: Hybrid in Austin, TX; three days onsite at the client site and two days remote on Tuesdays and Thursdays. Candidates must be local to Austin or willing to relocate.

Company

Texas-based IT staffing and IT delivery firm serving Texas state and local government agencies since 2002, providing IT professionals and full-lifecycle technology delivery services.

What you will do

• Review, analyze, and evaluate business systems and user needs.
• Analyze current-state and future-state business processes, including process flows and data flow diagrams.
• Perform requirements elicitation, data profiling, validation, source-to-target mapping, and complex SQL analysis.
• Prepare solution options, risk identification, cost-benefit, ROI, and buy/build analyses.
• Document user needs, program functions, business rules, KPIs, data dictionaries, data lineage, BRDs, and functional/data requirements.
• Support data governance, gap analysis, enterprise reporting and analytics initiatives, and UAT throughout the SDLC.

Requirements

• At least 8 years of experience as a Business Analyst or Business Data Analyst gathering, analyzing, and documenting business requirements in an enterprise IT environment, including state government or large enterprise settings using formal SDLC processes.
• At least 8 years of experience analyzing and documenting current-state and future-state business processes, process flows, and data flow diagrams.
• At least 8 years of experience with data profiling, validation, data element definitions, and business rules.
• Extensive hands-on experience writing and interpreting complex SQL queries, joins, and aggregations against relational databases for data analysis, validation, and ad hoc investigation.
• At least 8 years of experience engaging business stakeholders through workshops, interviews, and facilitated sessions to elicit, clarify, and validate requirements.
• At least 8 years of experience translating business requirements into functional/data requirements documents and BRDs for technical teams.
• At least 8 years of experience defining business measures, metrics, and KPIs and working with reporting and analytics teams on report specifications and data sourcing.
• At least 8 years of experience performing gap analysis and supporting UAT, including test scenarios and test cases based on documented requirements.
• At least 10 years of strong written and verbal communication experience and a bachelor's degree in Business Administration, Information Systems, or a related field, or equivalent work experience.

Nice to have

• Project management experience with PMP.
• Strong experience as a Data Analyst and Business Analyst in technology environments.

Culture & Benefits

• One-year position supporting a government client.
• Competitive compensation and benefits.
• Professional growth, career support, and well-being support for consultants.
• Hybrid schedule with two remote days and three onsite days per week.