City of Austin - JOB DESCRIPTION

IT Data Analyst

IT Data Analysts are responsible for identifying, capturing, analyzing, and managing City IT and department data. Through data conceptualization, modeling, and presentation, IT Data Analysts help City leadership and departments answer questions and solve pressing City problems. Additionally, IT Data Analysts empower end-users to use data in their decision-making processes through education, innovative dashboards, and relevant data representation.

1. Catalogs existing data sources and work with City IT partners to understand requirements for data use, analysis and quality.
2. Profiles data from internal and external sources.
3. Participates and sometimes lead data classification and data-mining to identify and assign data categories (e.g., Open, Confidential, Sensitive, HIPAA, etc.) to a data collection.
4. Assists in designing reporting dashboards to translate data to an understandable format.
5. Performs initial data exploration (binning, pivoting, summarizing and finding correlations).
6. Fulfills ad hoc reporting requests.
7. Provides feedback and recommendations regarding the creation of standards and patterns for data distribution and retention.
8. Analyzes and interprets results using standard statistical tools and techniques.
9. Contributes to management of central data stores and metadata to establish quality expectations.
10. Contributes to development of services and solutions to drive decision-making and action.

• Knowledge of data integration tools, data management architectures such as Data Warehouse, Data Lake, Data Hub Management, 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, tools, and 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, program languages, data warehousing, and relational databases skills.
• Skill in data analysis, data visualization, data mining, reporting, and data integrity skills.
• Ability to clearly communicate technical concepts with customers to increase their understanding of their operations.
• Ability to engage in opportunities to see the big picture and make decisions based on strategy and value delivered.
• Ability to articulate and solve problems or answer questions with data.
• Ability to consider and incorporate the implications of analysis into recommendations for business decisions.
• Ability to gather, assemble, correlate, and analyze facts.
• Ability to identify data trends as well as isolated events.
• 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.

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