top of page
City of Austin
Posted On:
5/31/24
Professional
Full-Time
Austin, TX
$37.14 – $47.35 per hour
Data Governance principles and processes. Analyze, design, and maintain relational databases; collaborate with City IT analysts; create data systems; perform statistical modeling for decision-making processes; implement data collection and management techniques; knowledge of data integration tools, analytics, visualization, and business intelligence tools; knowledge of data structures and industry-standard methodologies; knowledge of statistical software and programming languages; knowledge of Big Data concepts and tools.
Apply Via Email:
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 – Supervisor 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.
bottom of page