Job Summary
As a Data Analyst, you will be part of a team working to discover and solve problems with varying complexity, uncover insights, and make data-driven recommendations to support critical business decisions. You will work with stakeholders to build tools and analysis that elevate the customer experience. Through data conceptualization, modeling, and presentation, you will help the department answer questions and solve problems. Additionally, you will empower users to use data in their decision-making processes through education, innovative dashboards, and relevant data representation
Distinguishing Characteristics
This classification is the first in a series of two (2) Systems Analyst classifications within the Information Technology job family. Provides assistance to business users in the effective use of complex applications and information technology. The Systems Analyst will analyze and test new or existing procedures, and develop alternative workflow solutions. May assist with analyzing databases, identifying data integrity issues, and develop simple to moderately complex procedures, data processes, and reports. This classification may require a flexible work schedule in order to meet the needs of the department.
Duties And Responsibilities
- Participate in and contribute to analysis activities across teams.
- Integrate data from multiple sources to understand requirements for data use, analysis, and quality.
- Perform initial data exploration (binning, pivoting, summarizing, and finding correlations), conceptualizing, and modeling.
- Analyze and interpret results using standard statistical tools and techniques to uncover trends and insights in complex datasets.
- Identify and communicate data trends and outliers.
- Design and create basic reports using databases, tables, indexes, and/or other data sources to translate data into presentable, easy-to-interpret content.
- Contribute to the design, planning, and implementation of services and solutions.
- Assists with designing, modifying, and implementing new or revised systems by evaluating and developing alternative workflow solutions.
- Performs moderately complex data analysis, which includes compiling and cleaning data, and data manipulation and analysis. Utilizes data analysis software and/or appropriate Structured Query Language to perform the analysis.
- Uses reporting tools to develop simple to moderately complex reports which are needed for business processes and statistical reports to evaluate productivity and workload.
- May assist with monitoring the interface of systems, subsystems, and software applications, and provide system administration for live and test environments.
- Assists with application installation and testing and develops test plans.
- Assists in providing application support and troubleshooting routine to moderately complex software application issues.
- Assists in managing an outsource relationship for third party application development and programming consultants.
- 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 two (2) years of relevant work experience;
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:
- Two (2) years of experience using Microsoft SQL Server, SQL Server Integration Services, Power BI and Excel.
- One (1) year of experience with SAS and/or Python.
- Experience creating reports for leadership and familiarity of Data Governance.
- Work experience in the Juvenile Justice or Criminal Justice field.
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.
- 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.
- Analyzing and evaluating data, and compiling reports.
- Analytical, problem-solving and decision-making.
- Training users on computer applications.
- Translating simple to 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.
- Work independently and efficiently 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: Schedule will vary. Works some weekends
Location: 2515 S. Congress Avenue
Department: Juvenile Probation
Criminal, Driving, Education, and Employment Background Checks Required.
Drug Test, Alcohol Test
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.
You must ensure your application accurately reflects your skills and abilities as they relate to the position. Only periods of employment and experience detailed in the "Work Experience" section of the application will be considered in determining which applicants move forward in the selection process, as well as determining pay level for candidate(s) recommended for hire.
