Strategic Data & Process Analyst

ACS Consultancy Services; Austin (TX); Hybrid; USD 80,000 - 110,000; Full time

Job summary

ACS Consultancy Services is seeking a Business Data Analyst in Austin, TX (Hybrid). The role requires a Bachelor’s degree in Business Admin/Info Systems or equivalent, strong SQL, data analysis, and stakeholder engagement skills.

You will liaise between business and IT, map current/future processes, and support UAT with rigorous requirement traceability. The position emphasizes data governance collaboration, report specification, and ROI analyses, with a focus on enterprise IT environments and

Qualifications

• Bachelor's degree in Business Administration, Information Systems, or a related field, or equivalent work experience.
• Strong written and verbal communication skills.
• Strong experience as a Business Analyst or Business Data Analyst in an enterprise IT environment.
• Experience working in state government or large enterprise environments following formal SDLC processes.
• Strong experience gathering, analyzing, and documenting business requirements.
• Experience analyzing and documenting business processes, including current-state and future-state process flows and data flow diagrams.
• Experience performing data analysis, profiling, validation, and documentation of data elements, definitions, and business rules.
• Extensive hands‑on experience writing and interpreting complex SQL queries, joins, and aggregations for data analysis and validation.
• Experience engaging business stakeholders to elicit, clarify, and validate requirements.
• Experience translating business requirements into functional and data requirements documentation and BRDs.
• Experience defining and documenting business measures, metrics, and KPIs.
• Experience working with reporting and analytics teams to define report specifications and data sourcing requirements.
• Experience performing gap analysis between current-state business processes/data and desired future-state outcomes.
• Experience supporting UAT, including developing test scenarios and test cases based on documented requirements.
• Strong communication, facilitation, analytical, and documentation skills.

Responsibilities

• Review, analyze, and evaluate business systems and user needs.
• Formulate systems and solutions that align with overall business strategies.
• Serve as a liaison between the business community and Customer IT teams.
• Perform business process reengineering and identify new applications of technology to improve business effectiveness.
• Analyze raw data and perform detailed data analysis to support business and technology initiatives.
• Conduct requirements elicitation through workshops, interviews, and facilitated sessions with business stakeholders.
• Analyze and document current-state (as-is) and future-state (to-be) business processes.
• Develop business process maps and data flow diagrams.
• Perform data profiling, data validation, source-to-target mapping, and data element documentation.
• Perform complex SQL analysis, including queries, joins, aggregations, data validation, and ad hoc investigation against relational databases.
• Translate business requirements into functional requirements, data requirements, and Business Requirements Documents (BRDs).
• Define and document business rules, business measures, metrics, KPIs, data dictionaries, and data lineage.
• Perform gap analysis between current business processes/data and desired future-state outcomes.
• Prepare solution options, identify risks, and perform financial analyses such as cost/benefit, ROI, and buy/build analysis.
• Support data governance initiatives and enterprise reporting and analytics initiatives.
• Collaborate with business stakeholders, data engineers, architects, reporting teams, and technical teams throughout the SDLC.
• Support User Acceptance Testing (UAT), including development of test scenarios and test cases based on documented requirements.
• Write detailed descriptions of user needs, program functions, and steps required to develop or modify computer programs.
• Facilitate communication and collaboration across business and technical teams.
• Support project management activities; PMP experience is a plus.

Skills

SQL proficiency

Data analysis

Stakeholder engagement

Communication

Documentation

Facilitation

Education

Bachelor's degree in Business Administration/Information Systems

Job description

ACS Consultancy Services is seeking a Business Data Analyst in Austin, TX (Hybrid). The role requires a Bachelor’s degree in Business Admin/Info Systems or equivalent, strong SQL, data analysis, and stakeholder engagement skills.

You will liaise between business and IT, map current/future processes, and support UAT with rigorous requirement traceability. The position emphasizes data governance collaboration, report specification, and ROI analyses, with a focus on enterprise IT environments and