Business Analyst III

TX-HHSC-DSHS-DFPS • Austin, TX

2d

About The Position

The Texas Department of Family and Protective Services (DFPS) is seeking a Business Analyst III for a full-time position within the IT Department's Application Development team. This position and will report directly to the Business Analyst Manager.
As a Business Analyst III on the Application Development team, this position is responsible for performing advanced (senior-level) business and data analysis tasks. This includes gathering, developing, and documenting user stories, defining acceptance criteria, and evaluating and improving business processes and tools. The primary focus of the BA III is to collaborate with internal and external agency stakeholders to analyze, gather, and document reporting requirements and data needs for software development projects, system enhancements, and production defects. This role will work closely with the Data Management team, the ODSI team, and various stakeholders or customers to provide status updates on defects and enhancements while managing and maintaining the backlog of data requirements for ongoing and upcoming initiatives. The ideal candidate should have a strong understanding of the Agile framework, as well as expertise in data manipulation, extraction, and validation processes. Additionally, this role requires knowledge of data warehouse dimensional modeling and experience with leveraging ETL tools and frameworks to design, develop, and optimize data pipelines.
This position is classified as a full-time position (40 hours a week). Work outside of regular hours may be required. Travel to other Austin offices(s) may be required. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

Requirements

• Ability to use SQL queries to join and pull data from various databases.
• Ability to write SQL scripts to transform, filter, sort, and group data according to business needs.
• Ability to analyze complex data sets by joining information from multiple tables to identify data anomalies
• Ability to read Stored Procedures, Unix Scripts and SQL queries to troubleshoot data anomalies in an ETL pipeline.
• Ability to write SQL queries systematically scan datasets for deviations from the established normal behavior.
• Ability to Verify data quality using SQL to ensure the accuracy and reliability of analysis and reports.
• Ability to Create source to target mapping documents for ETL pipelines.
• Knowledge of Business Analysis key concepts, elicitation and collaboration, strategy analysis, solution evaluation, competencies, and techniques.
• Knowledge of Software Development Life Cycle (SDLC) and high-level system design methodologies and techniques (entity/relationship models, data/process flow diagrams); object-oriented programming and programming client/server applications.
• Ability to research, understand, and summarize key and abstract ideas and when applicable, suggest recommendations from those findings.
• Strong analytical and critical thinking skills.
• Ability to identify and mitigate key issues affecting the progress of an organization and present solutions.
• Working knowledge of productivity software including Microsoft Office Suite to include MS Word, Excel, PowerPoint, MS Project, SharePoint, Visio and/or SQL.
• Demonstrates excellent organization skills, e.g., defines and organizes tasks, responsibilities, and priorities.
• Ability to develop documentation that maps and illustrates processes and develop framework for process improvement.
• Demonstrated experience in expressing technical and business concepts and conclusions orally and in writing.
• Ability to lead others.
• Skilled in problem root cause analysis and negotiating problem resolution.
• Graduation from an accredited College or University
• At least three (3) years’ full-time experience in data analysis, data integration, and ETL processes.

Nice To Haves

• Degree in computer science, computer information systems, management information systems, or a related field, preferred.
• Business Analysis experience is preferred
• DFPS program experience preferred
• Scrum Master or Scrum Product Owner certification is a plus but not required.
• CBAP or similar Business Analyst certification is a plus but not required.
• ETL and Data Analytics Certifications

Responsibilities

• Performs advanced data analysis to support defect resolution or enhancement projects.
• Gather and document user stories and acceptance criteria.
• Host/Contribute to Agile Scrum events such as Daily Stand ups, Sprint Planning, Refinement sessions, etc.
• Engage with internal and external agency stakeholders to gather and document reporting requirements and data needs.
• Contribute, Maintain, and prioritize the backlog for the Data Management team.
• Provide regular updates to agency customers and stakeholders on the status of defects and enhancement requests.
• Work with ETL tools and frameworks to design, maintain, and optimize data pipelines.
• Conducts work sessions with users and project team members to document requirements, develop use cases, and/or technology solutions.
• Assists Business analysts from project teams to ensure reporting and data requirements are gathered and delivered within project timelines working with Data Management and ODSI.
• Participates in release activities and application development implementation activities.
• Develops and coordinates other special projects and performs other duties as assigned.
• Train other business analysts on using SQL to perform analysis.

Benefits

• 100% paid health insurance for you, and 50% paid for eligible family members—saving you hundreds every month in out-of-pocket medical costs
• Retirement plans with lifetime monthly payments after five years of state service, plus options to save even more with 401(k) and 457 plans
• Paid vacation, holidays, and sick leave so you can recharge and take care of life outside work (that’s time off you’re actually paid for)
• Optional dental, vision, and life insurance—at rates much lower than most private plans
• Flexible spending accounts for added tax savings on health and dependent care
• Employee discounts on things like gym memberships, electronics, and entertainment

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1-10 employees