Business Analyst (Austin)

About the role

The Texas Workforce Commission (TWC) is seeking a Business Analyst II-III (IT Business Analyst II-III) to support the Analytics Infrastructure Department. This position is located within the Analytics Infrastructure Department at 101 E. 15th St, Austin, Texas.

Responsibilities

• Elicit business requirements for new reports and visualizations or enhancement of existing reports and visualizations.
• Develop and/or review complex documents, including Business Requirements Documents, process maps, existing report specifications, entity relationship diagrams, and other documents as appropriate, to convey business requirements and support accurate and efficient report and visualization design.
• Analyze program policies and procedures to determine their effect on reporting needs and requirements; analyze existing summary and detail reports to determine business rules and requirements.
• Lead and/or support internal management and developer review of business requirements.
• Identify potential development risks and difficulties and help design strategies to mitigate or avoid them.
• Answer questions about requirements from ETL and Tableau developers.
• Serve as a liaison by providing consultation, documentation, and direction to other business areas related to analysis, design, configuration, testing, and policy implementation regarding the development and enhancement of reports and visualizations.
• Use SQL-based pseudocode to help developers understand and implement complex business rules.
• Work with developers to review SQL code for logical conformity with business rules and requirements.
• Assist in the location and mapping of source data in an enterprise data warehouse for the development of reports and visualizations.
• Evaluate available source data in the enterprise data warehouse using SQL.
• Evaluate target data to ensure business rules and requirements are accurately implemented.
• Write and maintain documentation of existing Division business processes, reporting specifications, performance measure definitions and calculations, and other items as needed, including Business Requirements Documents, process maps, Standard Operating Procedures, and other documentation products as appropriate.
• Track and regularly update management staff on the status of requirements development.
• May review complex project deliverables such as project charters, design documentation, test plans, and risk assessment plans; and may provide comments and suggestions to document owners.
• May develop user documentation and technical assistance materials covering assigned reports and visualizations.
• May provide formal and informal technical assistance to users regarding assigned reports and visualizations.
• May augment internal teams with report and visualization development and testing as schedule permits.
• Perform other duties as assigned and required to maintain unit operations.

Requirements

• Two years of full-time experience in business administration, business analysis and/or related fields for IT Business Analyst II.
• Three years of full-time experience in business administration, business analysis and/or related fields for IT Business Analyst III.

Qualifications

• Relevant academic credits may be applied toward experience qualifications for this position.
• Business Analyst certification from the International Institute of Business Analysis (CCBA or CBAP) or the Project Management Institute (PMI-PBA).
• Experience using Microsoft Excel, Word, Access.
• Experience in developing Business Requirements Documents, process maps, Standard Operating Procedures, and other documentation products.
• Excellent verbal and written communication skills.
• Expertise using SQL, especially in an enterprise data warehouse environment.
• Experience using Microsoft SharePoint document libraries.
• Experience in performance reporting, statistical analysis, and/or process improvement.
• Skill in analysis, problem solving, data comprehension, reporting methodologies, and understanding statistical reports and charts/graphs.
• Experience in Tableau visualization development.
• Ability to perform detailed work efficiently and extremely accurately.