Senior Business Data Analyst - SQL & Enterprise Analytics

Cornerstonetechtalent; Austin (TX); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Cornerstone Tech Talent seeks a Senior Business Data Analyst to drive enterprise data initiatives in a large public-sector environment. This hybrid role blends business analysis with hands-on data work, including advanced SQL, data profiling, source-to-target mapping, and data lineage.

The ideal candidate has 8+ years in analytics within enterprise IT, excels at requirements gathering, BRD creation, data definitions and KPIs, and partners with stakeholders to deliver SDLC artifacts and validated

Qualifications

• 8+ years of Business Analyst / Business Data Analyst experience within enterprise IT environments.
• 8+ years of hands-on SQL experience, including complex queries, joins and data investigation.
• 8+ years of data analysis, including profiling, validation, data definitions, and business-rule documentation.
• 8+ years of requirements gathering and documentation.
• 8+ years analyzing and documenting business processes, including as-is/to-be process flows and data-flow diagrams.
• 8+ years translating requirements into BRDs and functional/data requirements.

Responsibilities

• Lead requirements elicitation through stakeholder interviews, workshops, and facilitated sessions.
• Analyze and document complex business and data requirements.
• Develop BRDs and functional/data requirements for technical teams.
• Perform hands-on data analysis using advanced SQL.
• Profile and validate large datasets and investigate data-quality issues.
• Document data lineage and support enterprise data-governance initiatives.
• Analyze current-state and future-state business processes; create data-flow diagrams.
• Define data elements, definitions, and business rules and data dictionaries.
• Collaborate with reporting teams to establish data-source requirements and testing.

Skills

Advanced SQL

Data profiling

Source-to-target mapping

BRD documentation

Stakeholder communication

Data governance

Education

Bachelor's degree in Information Systems or related field

Job description

Senior Business Data Analyst – SQL & Enterprise Analytics ****NOT OPEN TO THIRD PARTY CANDIDATES****** Location: Austin, TX Work Arrangement: Hybrid – 3 Days Onsite / 2 Days Remote Schedule: Monday–Friday, 8:00 AM–5:00 PM Contract: October 19, 2026 – August 31, 2027 Extension Potential: Up to three additional one-year renewals Experience: 8+ Years

Position Overview We are seeking a highly experienced Senior Business Data Analyst to support complex enterprise technology, data, and reporting initiatives within a large public-sector environment. This is a hybrid Business Analyst + Data Analyst position. The successful candidate must be equally comfortable leading requirements discussions with business stakeholders and working hands‑on with complex SQL, data profiling, validation, source-to-target mapping, business rules, KPIs, and data lineage. This is not a traditional Business Analyst position focused primarily on meetings and documentation. Strong hands‑on SQL and data analysis experience are core requirements.

Key Responsibilities

• Lead requirements elicitation through stakeholder interviews, workshops, and facilitated sessions.
• Analyze and document complex business and data requirements.
• Develop detailed Business Requirements Documents (BRDs) and functional/data requirements for technical teams.
• Perform hands‑on data analysis using advanced SQL.
• Profile and validate large datasets and investigate data‑quality issues.
• Perform source‑to‑target mapping and document data transformations.
• Define data elements, definitions, business rules, and data dictionaries.
• Document data lineage and support enterprise data‑governance initiatives.
• Analyze and document current‑state (as‑is) and future‑state (to‑be) business processes.
• Create process flows and data‑flow diagrams.
• Perform gap analysis between existing processes/data and desired future‑state outcomes.
• Define business measures, metrics, and KPIs.
• Partner with reporting and analytics teams to establish reporting specifications and data‑source requirements.
• Support User Acceptance Testing, including developing test scenarios and test cases from documented requirements.
• Collaborate with business stakeholders, data engineers, architects, application teams, and reporting teams throughout the SDLC.

Critical Required Qualifications

• 8+ years of Business Analyst / Business Data Analyst experience within enterprise IT environments.
• 8+ years of hands‑on SQL experience, including complex queries, joins, aggregations, validation, and ad hoc data investigation.
• 8+ years of data analysis, including profiling, validation, data definitions, and business‑rule documentation.
• 8+ years of requirements gathering and documentation.
• 8+ years analyzing and documenting business processes, including as‑is/to‑be process flows and data‑flow diagrams.
• 8+ years translating requirements into BRDs and functional/data requirements.
• 8+ years defining business metrics, measures, and KPIs.
• 8+ years performing business and data gap analysis.
• 8+ years supporting UAT, including test‑case and test‑scenario development.
• Experience working within formal enterprise SDLC processes.
• Bachelor's degree in Business Administration, Information Systems, or a related discipline, or equivalent professional experience.
• Excellent written, verbal, facilitation, and stakeholder‑management skills.

What We're Really Looking For

The strongest candidate will demonstrate all three areas: Business Analysis + Hands‑On Data Analysis + Advanced SQL Candidates should be able to move comfortably from a requirements workshop into the data—writing SQL to investigate an issue, validating the results, documenting business rules and lineage, and then translating those findings into requirements that engineering and reporting teams can implement. Experience within Texas state government, another public‑sector organization, or a large enterprise environment following formal SDLC processes would be particularly valuable.

Preferred Experience

• Enterprise data governance
• Source‑to‑target mapping
• Data lineage
• Data dictionaries
• Enterprise reporting and analytics
• Data‑quality initiatives
• Process reengineering
• Cost/benefit and ROI analysis
• Buy-vs.-build analysis
• Project management experience
• PMP certification is a plus.

Work Location

Candidates must already be local to the Austin, Texas area. The expected schedule is three days onsite and two days remote, with Tuesdays and Thursdays remote. Candidates currently outside Texas who plan to relocate should not be submitted.