IT Data Analyst Senior

Minimum Qualifications
Education and/or Equivalent Experience:

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

Licenses and Certifications Required:
None.
Notes to Applicants
The Transportation and Public Work's Data & Technology Services Division ( DTS ) is hiring a permanent full-time position, an IT Data Analyst Senior to join our Application & Solutions team. We're looking for a curious and hard-working person who is excited about bringing modern digital products to the government.

DTS is a division of the Transportation and Public Works Department ( TPW ) that embraces progressive civic tech values including open technology, agile development, and user-centered design to build impactful products with Austin's mobility planners, engineers, technicians, and staff.

What is it like to work at TPW Data & Technology Services Team?


You'll be working alongside people who care deeply about what they do, driven to tackle the hard problems that City government and Austinites face every day. We're a growing team, and you'll have a chance to make an immediate impact. You'll be empowered to dive into our processes, test new tools, and give your thoughts on how we can do better.

We administer critical IT systems, engineer open transportation data, and geek over maps and open-source projects. We embrace mature frameworks, with an eye towards maintainability and long-term stability. We use a wide range of modern tools and technologies to deliver solutions to our stakeholders. We love web mapping, and we champion open-source and open data across the City of Austin.

What we're looking for


The role is open to all levels of IT practitioners with a background or interest in: GIS , database design, information architecture, computer science, data visualization, user-centered design, urban planning, public policy, and social impact.

This position will be focused on architecting, building, and maintaining form-based web applications. We build enterprise business applications for ATD staff using Knack , a no-code workflow management service, and we also have a team of developers who build custom software when out-of-the-box doesn't cut it.

This position will support a range of users from field technicians who install traffic signals to planners designing Austin's bike lanes, by digitizing paper processes, optimizing operational workflows, and improving data quality. You'll work with transportation staff and engineers to build software to manage the end-to-end workflow of putting new assets into operation; maintain and build new features for our enterprise platforms.

You'll have the chance to work on TPW's growing portfolio of products ranging from workforce management, field asset tracking, and permitting, as well as analytics dashboards and mobile data collection.

What You'll Do

• Develop, design and maintain our no-code enterprise applications.
• Troubleshoot technical issues and organize training resources, workflows, diagrams, help guide material for our end-users.
• Work with stakeholders to assess our legacy systems, evaluate problems, and identify solutions that meet evolving business needs.
• Lead identification, capture, analysis, and management of City IT and department data.
• Work closely with our solution architect, product manager, and developers to design and deliver user-centered products in an agile fashion; participating in two-week sprint cycles and sprint reviews where you'll demo your work for stakeholders.
• Maintain data standards, author technical documentation, and participate in interdepartmental meetups and events.
• Organize and understand datasets and data pipelines
• Collaborate with cross-disciplinary teams of transportation engineers, city planners, systems analysts, and software developers.

Travel:

If you are selected for this position, and meet the Driver Safety Standards in the City of Austin Driver Safety Program, you may drive when necessary to multiple locations as part of your regular job duties. Otherwise, you are responsible for getting to and from these locations.

Watch the video linked below to learn more about Austin Transportation and Public Works and its role in the region's mobility landscape.

Inside TPW : https://www.youtube.com/watch?v=wu4fqWGoH0E

Working for the City of Austin provides a number health and welfare benefits such as low-cost medical, dental, vision, paid leave time, a highly competitive retirement plan, career development opportunities and more. For more information on City of Austin Benefits click here!

Regarding your Application:

A detailed and complete employment application is required to help us better evaluate your qualifications and will be used to determine salary if you are selected for this position. Please list your complete employment history (to include all job duties responsibilities and employment dates) on your online application. The application is an official document; incomplete applications will not be considered (e.g., "see resume" or "see Linked In Profile"). Resumes will not be used to qualify for the position and will not be used to recommend salary.

Assessment:

This position may require a skills assessment.

Close Job Posting:

Department may close the job posting at any time after 7 days.

90 Day Provision for Additional Vacancy:

This posting may be used to fill other vacancies in other sections within the Division. Decisions on assigned section will be made at the time of hire based on business needs.

Office Location Notes:

Office location is subject to change based on department needs and programs.

Austin Transportation and Public Works positions are not at 100% remote operation.

Video Conferencing Software Technology:

The Austin Transportation and Public Works Department uses the communication platform, Microsoft Teams, to conduct virtual interviews.

Preferred Qualifications
Preferred Experience:

• Experience supporting customers and managing applications in an enterprise software environment (ex. Maximo, SharePoint, Knack, ArcGIS Online, etc..).
• Experience with designing, creating and maintaining relational databases, understanding database principles and methods for extracting, transforming, and loading data.
• Experience in developing, configuring and maintaining no-code web forms/applications (ex. Knack, MS SharePoint sites, MS Access, Salesforce, etc..).
• Excellent communication skills, both verbal and written, with emphasis on providing exceptional customer service.
• Strong technical writing skills including experience creating technical documentation, documenting business processes, workflow diagrams, and training materials.
• Experience building user defined queries, reports and developing data representations, visualizations using business intelligence tools.

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

Designs, creates, and maintains relational databases and data systems.

Collaborates with City IT analysts to identify data issues and prioritize improvements.

Informs solution design and improvements to meet data quality goals.

Leads and oversees data classification and data-mining activities to enable more accurate analysis.

Determines necessary actions required to generate and publishes open data on the City's open data portal.

Creates data visualizations and reports to present to audiences using presentation tools.

Creates standards and patterns for data distribution and retention.

Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes.

Enables access to City and external data sources.

Suggests analytics opportunities and best practices.

Contributes to management of central data stores and metadata to establish quality expectations.

Identifies opportunities to increase data quality, including automation and data entry procedural training.

Creates and implements techniques for data collection, accuracy and management.

Responsibilities- Supervision and/or Leadership Exercised:

May provide leadership, work assignments, evaluation, training, and guidance to others.
Knowledge, Skills and Abilities
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 data integration tools, data management architectures such as Data Warehouse, Data Lake, Data Hub Management, and data exploration techniques (binning, pivoting, summarizing, and finding correlations).
• Knowledge of analytics, visualization and business intelligence tools.
• Knowledge of data structures, patterns and data models and related industry-standard methodologies.
• Knowledge of Source-to-Target Mapping, Extract-Transform-Load ( ETL ) processing and Change Data Capture ( CDC ) concepts.
• Knowledge of statistical software, database queries and programming languages (e.g., Java, C++, Scala, SQL , Hive, Python and R), XML , JSON and XSD's.
• Knowledge of Big Data concepts, frameworks, products, and tools.
• Knowledge of data models and structures as well as database design tools (e.g., Visio, SQL , tec.)
• Skill in data modeling, database and data management, SQL coding, data warehousing, reporting, data warehousing, relational databases, and data integrity skills.
• Skill in data analysis, data visualization, data mining, reporting, and data integrity skills.
• Ability to clearly communicate technical concepts with clients to increase their understanding of their operations.
• Ability to consider and incorporate the implications of analysis into recommendations for business decisions.
• Ability to see the big picture and make decisions based on strategy and value delivered.
• Ability to turn data insights into recommendations for both clients and internal stakeholders based on context.
• Ability to adhere to required compliance to all change management policies and procedures.
• Ability to adhere to required compliance to all information security policies and procedures.

Criminal Background Investigation This position does not require a Criminal Background Investigation EEO/ADA
City of Austin is committed to compliance with the Americans with Disabilities Act. If you require reasonable accommodation during the application process or have a question regarding an essential job function, please call (512) 974-3210 or Texas Relay by dialing 7-1-1.

The City of Austin will not discriminate against any applicant or employee based on race, creed, color, national origin, sex, gender identity, age, religion, veteran status, disability, or sexual orientation. In addition, the City will not discriminate in employment decisions on the basis of an individual's AIDS , AIDS Related Complex, or HIV status; nor will the City discriminate against individuals who are perceived to be at risk of HIV infection, or who associate with individuals who are believed to be at risk.

Information For City Employees: If you are an employee within the department, are in good standing and meet both the minimum and preferred qualifications, then you will receive an initial interview.