Business Analyst Ii

Travis County
Full Time TX 2433 Ridgepoint Dr, Austin, TX 78754, United States
Advertisement

Overview

Are you looking for a career opportunity that provides top tier benefits including paid vacation and sick leave, parental leave, outstanding health, vision, and dental insurance, a free health clinic for you and your dependents, a generous retirement plan, and more? The Travis County Tax Office is seeking a new Business Analyst II to join our IT division.

The ideal candidate for this role must have the skills to envision ways to combine multiple data sources into a cohesive, easier-to-use framework, then develop the systems to store and manage that data. They must know how to execute an end-to-end vision for how a design might translate into physical databases, and how to integrate disparate sources of data. Candidates must know how to model and predict changes in the way an organization acquires data could impact the way it uses that data and map out the way data will flow through the various stages of a project. An ideal candidate must also possess exceptional organizational skills. They must be able to take various data sources, business needs, operations competing elements, and projects that they may be working on and assess methods to best meet the customer's needs.

This position will be eligible for a hybrid work schedule (four telework days and one in-office day per week) following a six-month probationary period. During the first six months on the job, the candidate selected for this role will be required to report to the office in-person. The purpose of this probationary period is to get new employees acquainted with the office environment, colleagues, and department-wide policies and procedures.
 

Distinguishing Characteristics:

This is the third in a series of four business analyst-related job classifications within the Information Technology job family. Provides routine to moderately complex technical consulting and support services for defining, developing and improving functional or business processes to meet user and organizational needs. The Business Analyst II performs moderately complex Information Technology functions and may perform computer hardware and software installation, network administration and database management within a department. This classification may require a flexible work schedule in order to meet the needs of the department.

Duties and Responsibilities

  • Translates business requirements into databases, data warehouses, data lakes and data streams.
  • Creates and executes an end-to-end vision for how a design might translate into physical databases, and how to integrate disparate sources of data into a unified structured database.
  • Model and predict how changes in the way an organization acquires data could impact the way it uses that data and map out the way data will flow through the various stages of an operations or project.
  • Manage various data sources, business needs, operations competing elements, and projects.
  • Creates procedures to ensure data accuracy and accessibility.
  • Analyzes, plans, and defines data architecture framework, including security, reference data, metadata, and master data.
  • Envision ways to combine multiple data sources into a more cohesive, easier-to-use framework, then develop the systems to store and manage that data.
  • Creates and implements data management processes and procedures to ensure data accuracy.
  • Collaborates with other teams within the organization to devise and implement data strategies, build models, and assess shareholder needs and goals.
  • Research data acquisition opportunities.
  • Develops application programming interfaces (APIs) to retrieve and report on respective data business requirements.
  • Lead as subject matter expert managing difficult and complex database problems.
  • Serves as an enterprise-wide technical expert as well as a functional expert and team lead to Database Administrator positions.
  • Creates and manages Quality Assurance test plans to maintain data integrity across various database environments.
  • Communicates with technical and business owners to help identify opportunities to enhance business operations by designing, implementing, and maintaining data libraries, databases, reports, and dashboards. 

Minimum Requirements

Education and Experience:
Bachelor's degree in Computer Science, Information Systems, Business Administration or a directly related field AND three (3) 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:

  • Extensive (over 5 years) experience.
  • Database architecture, engineering, and design of complex heterogeneous database/dataset and operating systems environments.
  • Predictive analytics based on Big Data platforms.
  • Data mining to identify patterns, anomalies, and correlations in large data sets.
  • Data management to optimize how data is collected, stored, and used.
  • Artificial Intelligence and Machine Learning to build scalable, sustainable, and secure systems for handling big data.
  • Structured query language (SQL) to manipulate data.
  • Data modeling tools like ERWin or MySQL Workbench to visualize metadata and database schema, relationships.
  • AWS or Azure data analysis tools and best practices.

Technical skills: Extensive (over 5 years) experience.
  • Using the following software applications and/or practices.
    • Tableau, PowerBI, Crystal Reports, or similar reporting/dashboard applications.
    • TOAD, MS SQL Management Studio or similar workflow applications.
    • MSSQL command language, with the ability to write and optimize complex queries.
    • Coding/Scripting languages like Python, Java, C# and others to develop applications for data analysis.
    • Relational database architecture and concepts.
    • Microsoft Office suite, including O365.
    • Microsoft Visio.
    • Business process models (Workflows, swim lanes, Root cause analysis, etc.).
  • Researching, reviewing, and presenting clear achievable recommendations or solutions to assist with various business needs analysis and project business needs requirements.
  • Working as a lead or team member on large scale projects.
  • Leading and/or assisting with the creation and organization of various technical documents such as Charters, Policies, Playbooks, Standard Operating Procedures, and others.
 
Personal skills:
  • Extensive (over 5 years) experience leading teams and/or assisting teams. 
    • Assessing and proposing recommendations to improve various business practices and/or operations.
    • Active listening.
    • Communications verbal and written.
    • Analytical and methodical.
    • Negotiation with empathy.
    • Emotional intelligence.
    • Customer service focused.

Knowledge, Skills, and Abilities:

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.
  • Existing automated business applications and their relationships to each other and interfaces with other automated systems.
  • Software engineering and the software development lifecycle.
  • Computer equipment to include word processing, spreadsheets, databases and a variety of software packages.
  • May be required to develop knowledge of and adhere to  federal and state laws requiring the confidential handling of certain health information.
Skill in:
  • Understanding technical problems and solutions in relation to current, as well as future, business environment.
  • Problem-solving and decision-making.
  • Training users on computer applications.
  • Translating moderately complex concepts for peers and customers.
  • Network administration and maintenance.
  • Installing, maintaining and troubleshooting of hardware, software and peripherals.
  • Both verbal and written communication, including presentations and communicating technical issues in non-technical language.
Ability to:
  • Identify and analyze end-user problems and develop practical technological solutions.
  • Work independently and efficiently and as part of a team.
  • Manage time well, perform multiple tasks and organize diverse activities.
  • Research, compile, analyze, interpret and prepare a variety of memorandums or reports.
  • Establish and maintain effective working relationships with departmental clientele, representatives of outside agencies and providers, other County employees and officials, and the general 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, walking, sitting, repetitive motion, reaching, climbing stairs, bending, stooping, kneeling, crouching, crawling, pushing, pulling, balancing, client/customer contact, 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.

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.

Work Hours: 8 AM - 5 PM; Monday through Friday. 

Location: 2433 Ridgepoint Drive 

Department: Tax Collector 

Criminal Background Check Required. 

Advertisement