Senior Data & Business Analyst - Hands-on SQL (Hybrid, Austin)

CornerStone Technology Talent Services; Austin (TX); Hybrid; USD 125,000 - 170,000; Full time

Job summary

CornerStone Technology Talent Services in Austin, TX seeks a highly experienced Senior Business Data Analyst to support complex enterprise technology, data, and reporting initiatives within a large public-sector environment.

This hybrid role combines Business Analyst and Data Analyst duties; you will lead requirements discussions with stakeholders and perform hands-on SQL, data profiling, data lineage, source-to-target mapping, and KPI definition. UAT and SDLC experience are required.

Qualifications

• 8+ years of Business Analyst / Business Data Analyst experience in enterprise IT.
• 8+ years of hands-on SQL experience, including complex queries and data investigation.
• 8+ years of data analysis, profiling, validation, and business-rule documentation.
• 8+ years of requirements gathering and documentation.
• 8+ years analyzing and documenting business processes with as-is/to-be flows.
• 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 with test-case development.
• Bachelor's degree in Business Administration, Information Systems, or a related discipline, or equivalent professional experience.
• Excellent written, verbal, facilitation, and stakeholder-management skills.

Responsibilities

• Lead requirements elicitation through stakeholder interviews, workshops, and facilitated sessions.
• Analyze and document complex business and data requirements.
• Develop detailed 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 and future-state 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 UAT, 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.

Skills

SQL

Data profiling

Data lineage

BRDs

Requirements gathering

KPIs

Data mapping

UAT

Stakeholder mgmt

Business analysis

Education

Bachelor's degree in Business Administration, Information Systems, or related

Job description

CornerStone Technology Talent Services in Austin, TX seeks a highly experienced Senior Business Data Analyst to support complex enterprise technology, data, and reporting initiatives within a large public-sector environment.

This hybrid role combines Business Analyst and Data Analyst duties; you will lead requirements discussions with stakeholders and perform hands-on SQL, data profiling, data lineage, source-to-target mapping, and KPI definition. UAT and SDLC experience are required.