Archived listing. The details below describe a past opening.
Job Summary Are you looking for career opportunities that provide top-notch benefits including paid parental leave, outstanding health & dental insurance, on-site health clinics for you & your dependents, a generous retirement plan, and much more? 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.
Distinguishing Characteristics
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. Duties and Responsibilities
- Data Pipelines & Integrations: Designs, builds, modifies, and implements secure data integration processes using tools like SSIS and Azure Data Factory. Making data available, secure, and scalable is at the core of what we do.
- Database Management: 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.
- Business Intelligence Infrastructure: Uses reporting tools including Power BI, SSRS, and Power Platform to develop workflows, reports, dashboards, and more broadly “automations”.
- Process Automation: Develops alternative workflow solutions and business apps using modern low-code suites like Power Apps and Power Automate.
- System Administration: Manages application and gateway administration for live and test environments across Power BI Service and Power Platform environments.
- Requirements Gathering: 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.
Minimum Requirements
Education and Experience:
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.
Licenses, Registrations, Certifications, or Special Requirements:
Valid Texas Driver’s License.
Preferred Qualifications:
Experience with SSRS, SSIS, Power BI, Power Automate, Azure Data Factory.Strong communication skills.
Knowledge of:
- Policies, practices, procedures and terminology of assigned function.
- Federal, State, Local and County applicable laws, rules, regulations and guidelines.
- Information technology hardware, software and peripherals as related to assigned function.
- Automated business applications and their relationships to each other and interfaces with other automated systems.
- Software engineering and the software development lifecycle.
- Relational databases, database design and Structured Query Language.
- 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.
- Scheduling, testing, installing, implementing, and troubleshooting application systems.
- Analyzing and documenting software design requirements and workflows.
- Analytical, problem-solving and decision-making.
- Training users on computer applications.
- Translating moderately complex concepts for peers and customers.
- 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.
- Lead, supervise and/or work independently and efficiently and as part of a team.
- Manage time well, perform multiple tasks, organize diverse activities and manage changing priorities.
- Research, compile, analyze, interpret and prepare a variety of memorandums or reports.
- Maintain and update knowledge of latest technologies.
- Establish and maintain effective working relationships with departmental clientele, representatives of outside agencies and providers, other County employees and officials, and the public.
Work Environment & Other Information Physical requirements include the ability to lift/carry up to 35-40 pounds occasionally, visual acuity, speech and hearing, hand and eye coordination and manual dexterity necessary to operate a computer and office equipment. Subject to standing, sitting, walking, climbing, crawling, bending, stooping, crouching, kneeling, pushing, pulling, reaching, twisting, balancing, repetitive motion, and squatting to perform the essential functions. Subject to exposure to variations in extreme heat, cold, mechanical, fume/odor, and dust/mites.
Travis County employees play an important role in business continuity. As such, employees can be assigned to business continuity efforts outside of normal job functions.
Work Hours: 8 am - 5 pm, Monday-Friday. Location: 700 Lavaca Street Austin, Texas 78701
Department: Information Technology
Criminal Background, Driving, Employment, Reference Checks, and CJIS Fingerprints Required.
For updates or questions on this position, contact: ashley.pena@traviscountytx.gov
This job description is intended to be generic in nature. It is not necessarily an exhaustive list of all duties and responsibilities. The essential duties, functions and responsibilities and overtime eligibility may vary based on the specific tasks assigned to the position.
Benefits
Benefits
Employment at Travis County comes with a full array of benefits. We offer comprehensive health insurance, a no-cost, on-site Health and Wellness clinic, longevity pay, paid vacations, sick time and personal holidays, not to mention an industry competitive salary structure and a friendly, stable work environment.FY2027 Travis County Benefit Guide In this valuable Travis County Benefits Guide you will find benefit summaries, eligibility requirements, costs, contact numbers and addresses as well as other general information on the benefits available to Travis County Employees and Retirees. Credit Union Employees may join the Travis County Credit Union which offers low-interest loans, savings plans through payroll deduction, safe deposit boxes and other benefits. Deferred Compensation Employees may enroll in a tax- free sheltered investment plan through payroll deduction. Direct Deposit Employees may sign up for direct bank deposit. Employee Assistance Program Travis County provides a confidential counseling and referral service free of charge to county employees and their family. Employee Organizations Membership in the American Federation of State, County, and Municipal Employees Union is available through payroll deduction. Employee Health & Wellness Clinic Employees may access the clinic for a variety of wellness program and health care services with no co-pay, no deductible and no co-insurance costs. Holidays An average of eleven paid holidays are designated by the Travis County Commissioners Court at the beginning of each fiscal year.
Insurance Employees may select from four plans: an Exclusive Physician Organization (EPO), Choice Plus Preferred Physician Organization (PPO), Consumer Choice or a High Deductible Health Plan (HDHP) with a Health Savings Account (HSA). All four options include a Pharmacy Plan. Travis County’s current policy is to pay 100% of the employee’s health insurance premium for the Consumer Choice and HDHP. Employees will pay a premium for both the EPO and PPO. Other insurance benefits include $50,000 Basic Life and AD&D paid by the County.
The following benefits are employee paid:
- Dental
- Vision
- Supplemental Life, AD&D
- Dependent Life
- Short Term Disability
- Long Term Disability
- Long Term Care
New employees are covered on the first day of the month following 28 calendar days of employment. Longevity Longevity pay is paid for each year completed after three years of continuous service. Peace Officers in a law enforcement activity, whose job requires state peace officer certification, receive pay after one year of certification.
On the regular payday on or after the employee's fourth and subsequent adjusted service dates, he or she receives a single payment for the previous year. Parking A limited number of assigned parking spaces are available to employees in the Courthouse Complex. Personal Holidays Regular, full-time employees are eligible for up to three paid personal holidays each calendar year. Part-time employees shall be granted personal holidays on a prorated basis. New employees earn personal holidays for the calendar year in which he/she begins employment, based on the month in which employment begins: January – March 3 personal holidays April - June 2 personal holidays
July - September 1 personal holiday
October - December None
New employees are eligible to take personal holidays after 90 days of employment.Retirement Travis County is a member of the Texas County & District Retirement System with mandatory participation by certain classes of employees. Seven percent (7%) of the gross salary is deducted each pay period. An employee is fully vested after eight years of service. Benefits are prorated for part-time employees. Sick Leave Regular employees earn sick leave at a rate of eight hours per month with unlimited accrual during employment. Part-time employees earn sick leave on a pro-rated basis.
Parental Leave Each Full-time Paid Parental Leave Eligible (PPL) Employee is entitled to a total of 320 hours of Paid Parental Leave in a 12 month period. Paid Parental Leave for Part-time PPL Eligible Employees is prorated based on the number of hours that they are regularly scheduled to work. Tuition Refund Certain classes of full-time employees may receive reimbursement for fees associated with pre-approved, job related course work completed satisfactorily. Vacation Based on years of county service, regular, full-time employees earn vacation time at the following rates: 0 to 5 years 4.0 hours per pay period 6 to 10 years 4.5 hours per pay period 11 to 15 years 5.0 hours per pay period 16 to 20 years 5.5 hours per pay period 21 plus years 6.0 hours per pay period
Part-time employees earn vacation leave on a pro-rated basis.Workers' Compensation The county provides all employees workers' compensation coverage with benefits in accordance with state statute, if the employee sustains an injury out of, or in the course of work.