Systems Analyst Sr

Travis County•Austin, TX

22h•Onsite

About The Position

Travis County Technology & Operations Department is seeking a Systems Analyst Sr to join the team. This role performs moderately complex to complex computer systems analysis, business intelligence engineering, and data pipeline work. Analyzes user business requirements, maps data workflows, and develops automated reporting and integration solutions to improve Travis County operations. Builds, tests, and maintains modern analytics infrastructure with high autonomy under general supervision. This classification is the second in a series of two (2) Systems Analyst classifications within the Information Technology job family. Consults with technical team members and business stakeholders to design data solutions, manage automated workflows, and maintain enterprise business intelligence tools. The Systems Analyst Sr specializes in building analytics infrastructure, understanding and leveraging relational databases, resolving data integrity issues, and translating business workflows into modern cloud or on-premise pipeline solutions.

Requirements

Bachelor’s degree in Computer Science, Information Systems or a directly related field AND five (5) years of relevant work experience, including three (3) year of systems analysis and process redesign work; OR, Any combination of education and experience that has been achieved and is equivalent to the stated education and experience and required knowledge, skills, and abilities sufficient to successfully perform the duties and responsibilities of this job.
Valid Texas Driver’s License.

Nice To Haves

Experience with SSRS, SSIS, Power BI, Power Automate, Azure Data Factory.
Strong communication skills.
Knowledge of: Policies, practices, procedures and terminology of assigned function.
Knowledge of: Federal, State, Local and County applicable laws, rules, regulations and guidelines.
Knowledge of: Information technology hardware, software and peripherals as related to assigned function.
Knowledge of: Automated business applications and their relationships to each other and interfaces with other automated systems.
Knowledge of: Software engineering and the software development lifecycle.
Knowledge of: Relational databases, database design and Structured Query Language.
Knowledge of: Data collection and analysis, and utilizing analytical tools.
Working knowledge of Microsoft Office (Excel, Word, Access, Outlook), Microsoft Visio, and Microsoft Project.
Skill in: Understanding technical problems and solutions in relation to current, as well as future, business environment.
Skill in: Scheduling, testing, installing, implementing, and troubleshooting application systems.
Skill in: Analyzing and documenting software design requirements and workflows.
Skill in: Analytical, problem-solving and decision-making.
Skill in: Training users on computer applications.
Skill in: Translating moderately complex concepts for peers and customers.
Skill in: Both verbal and written communication, including presentations and communicating technical issues in nontechnical language.
Ability to: Identify and analyze end-user problems and develop practical technological solutions.
Ability to: Lead, supervise and/or work independently and efficiently and as part of a team.
Ability to: Manage time well, perform multiple tasks, organize diverse activities and manage changing priorities.
Ability to: Research, compile, analyze, interpret and prepare a variety of memorandums or reports.
Ability to: Maintain and update knowledge of latest technologies.
Ability to: Establish and maintain effective working relationships with departmental clientele, representatives of outside agencies and providers, other County employees and officials, and the public.

Responsibilities

Designs, builds, modifies, and implements secure data integration processes using tools like SSIS and Azure Data Factory.
Analyzes and understands relational databases, understands the principles of extract/transform/load through the lens of data integrity, troubleshoots complex Transactional SQL (T-SQL) queries, and understands the principles of data governance.
Uses reporting tools including Power BI, SSRS, and Power Platform to develop workflows, reports, dashboards, and more broadly “automations”.
Develops alternative workflow solutions and business apps using modern low-code suites like Power Apps and Power Automate.
Manages application and gateway administration for live and test environments across Power BI Service and Power Platform environments.
Conducts deep data analysis and confers directly with end-users to gather detailed business requirements for new analytical dashboards and database solutions.
Performs other job-related duties as assigned.