City of Austin - JOB DESCRIPTION

IT Data Analyst Senior

IT Data Analyst Seniors are responsible for leading identification, capture, analysis, and management of City IT and department data. Through data conceptualization, modeling, and presentation, IT Data Analyst Seniors lead City departments and leaderships to answer questions and solve pressing City problems. Additionally, this position empower end-users to use data in their decision-making process through education, innovative dashboards, relevant data representation, and through development of new services / products / solutions for users.

1. Designs, creates, and maintains relational databases and data systems.
2. Collaborates with City IT analysts to identify data issues and prioritize improvements.
3. Informs solution design and improvements to meet data quality goals.
4. Leads and oversees data classification and data-mining activities to enable more accurate analysis.
5. Determines necessary actions required to generate and publishes open data on the City’s open data portal.
6. Creates data visualizations and reports to present to audiences using presentation tools.
7. Creates standards and patterns for data distribution and retention.
8. Implements statistical models to identify and reveal trends, patterns, and relationships in data to provide guidance to others for decision making processes.
9. Enables access to City and external data sources.
10. Suggests analytics opportunities and best practices.
11. Contributes to management of central data stores and metadata to establish quality expectations.
12. Identifies opportunities to increase data quality, including automation and data entry procedural training.
13. Creates and implements techniques for data collection, accuracy and management.

May provide leadership, work assignments, evaluation, training, and guidance to others.

• 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.

• 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.