IT Business Systems Analyst

This position will have a data-driven focus and will pull data, develop reports and dashboards to help Austin Water Engineers make informed business decisions and will work with various departments to support departmental goals and objectives. This position will also be involved in coaching/training others how to use business intelligence data, and must be able to communicate and work with individuals at all levels of the organization.

Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.

1. Meet with decision makers, system owners and end users to define business, financial and operations requirements and systems goals
2. Assist with requirements gathering sessions to elicit requirements, specifications, business processes and recommendations related to potential IT solutions
3. Create models, use cases, process flows, specifications, diagrams and charts to provide direction to developers, designers, and vendors
4. Assist with converting requirements into developing a statement of work for use in requests for proposals
5. Evaluate compatibility and interoperability of commercial off-the-shelf or in-house technology systems
6. Review and analyze the effectiveness and efficiency of existing systems and assist with developing strategies for improving or further leveraging these systems 
7. Perform cost-benefit and return-on-investment analyses to aid in making IT business decisions
8. Conduct research on software and hardware products and technology services to justify recommendations and to support purchasing efforts
9. Write and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in IT applications across the organization 
10. Coordinate and perform tests, including end-user reviews, for modified and new systems, training and other post-implementation support

Responsibilities- Supervision and/or Leadership Exercised: None

Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

• Knowledge of concepts and principles of application programming, database and system design including Internet, and network architectures
• Knowledge of legacy, and web-based systems interfaces
• Knowledge of importing data for use in report software, spreadsheets, graphs, and flow charts
• Knowledge of cost-benefit analysis and total cost of ownership modeling
• Skill in performing requirements development, process modeling, reporting and project management tools
• Skill in developing process models and data flow diagrams using industry-standard modeling techniques
• Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts
• Ability to accurately identify/determine customer needs and take appropriate actions and/or steps to address identified needs
• Ability to recognize, value, and include different perspectives, experiences, approaches, and cultures in achieving organizational goals
• Ability to gain and maintain the trust and confidence of others and the organization through consistency and reliability
• Ability to give, receive, or share thoughts, ideas, perspective, and data to create shared understanding
• Ability to define, analyze, and find solutions for difficult or complex problems
• Ability to view the big picture
• Ability to quickly become familiar with emerging technologies
• Ability to identify trends as well as isolated events

Minimum Qualifications:

• Graduation with a Bachelor’s degree from an accredited college or university with major course work in a field related to the job.
• Experience may substitute for education for up to (4) years.

Licenses or Certifications:

• None.

Preferred Qualifications:

• Experience supporting teams through business intelligence integration, project delivery, and ongoing operations and maintenance
• Demonstrated experience performing business analysis, identification of requirements and testing for a variety of software and Business Intelligence development projects including highly complex enterprise-wide projects
• Experience regularly interacting with different levels of personnel throughout an organization and adapting communication styles to meet the needs of internal and external customers
• Strong organizational skills and demonstrated experience in planning, organizing, and working with frequent interruptions and changes in priorities and collaborating effectively with other departments or units within an organization to meet business objectives
• Experience performing advanced GIS data analytics including special analysis queries and database integrity quality control
• Experience with writing and executing complex SQL queries to extract data from a variety of data sources to provide business user support and develop and design reports and dashboards for enterprise-wide applications, such as the City of Austin’s Hansen/IPS, CC&B, AMANDA or similar systems
• Ability to travel to more than one work location
• Must be able to perform on call rotation that will include nights and weekends