Austin Aviation IT Data Architect

City of Austin•Island, KY

23h•$96,180 - $123,100

About The Position

The IT Data Architect designs, builds, and optimizes the enterprise data platform supporting reporting, analytics, artificial intelligence, and business decision-making. The role develops scalable data pipelines, integrates data from multiple systems, and creates data architectures such as data warehouses, data lakes, and data hubs. Working with business stakeholders, analysts, engineers, application teams, and other subject matter experts across the City, the architect delivers accurate, secure, accessible, production-ready data and analytics solutions. The position designs and implements data and analysis infrastructure, including complex databases, and helps move optimized data pipelines into production for key data and analytics consumers. It also supports large-scale machine learning and advanced analytics solutions, creates ETL and SQL-based transformation processes, and documents data models, mappings, technical specifications, production support, data dictionaries, and test cases. The role follows data governance, information security, and change management policies and procedures. It may provide leadership, work assignments, evaluation, training, and guidance to others. The minimum qualification is a bachelor’s degree from an accredited college or university in Information Science or a related field, plus five years of related experience. A master’s degree may substitute for up to two years of experience, and education or experience may substitute for up to four years. No licenses or certifications are required. The position requires travel to multiple sites as part of regular duties and is categorized as essential personnel, which may require reporting during emergencies or bad weather. A skills assessment is required. Work hours are Monday through Friday, 8:30 a.m. to 5:30 p.m., and may change based on departmental needs, including after-hours, holiday, and weekend work.

Requirements

Bachelor’s degree from an accredited college or university with major coursework in Information Science or a field related to the job, plus five years of related experience.
A master’s degree may substitute for up to two years of experience; education or experience may substitute for up to four years.
Knowledge of programming languages such as R, Perl, Python, Java, C++, C#, or Scala, and of modern data storage and access technologies, including caching, NoSQL, key/value, and relational database systems.
Knowledge of commercial data science platforms such as Python, R, KNIME, or Alteryx.
Knowledge of ETL processing and Change Data Capture technologies.
Knowledge of big data concepts and frameworks, business intelligence tools such as Tableau, Qlik, or Power BI, and AI frameworks such as Caffe or TensorFlow.
Knowledge of data management architectures, including data warehouses, data lakes, and data hubs, and supporting processes such as data integration, governance, and metadata management.
Skills in data storage and processing, database fundamentals, data orchestration and automation, programming, CI/CD, data validation and testing, version control, scripting and coding, cloud migration, metadata management, infrastructure as code, data monitoring, and observability.
Ability to build, manage, and optimize data pipelines that facilitate data movement.
Ability to reduce manual data work and improve productivity.
Ability to build robust data operations and quickly identify, debug, and troubleshoot critical issues.
Ability to work across teams and foster a cooperative, efficient working environment.
Ability to incorporate analytical implications into recommendations for business decisions and turn data insights into recommendations for clients and internal stakeholders.
Ability to comply with change management and information security policies and procedures.
Ability to read, write, and speak English fluently.
Must meet City of Austin Driver Safety Program standards to drive when necessary; otherwise, responsible for travel to and from multiple work locations.
Must complete a skills assessment.
Must be able to perform essential job functions with or without reasonable accommodation.

Nice To Haves

Experience designing and implementing enterprise data architectures, including conceptual, logical, and physical data modeling, dimensional modeling using Star Schema, data warehouses, and governed data marts for enterprise analytics and data reuse.
Experience establishing enterprise data governance frameworks, including data taxonomy, master data management, metadata management, data quality, lineage, and standardized data products to support a single source of truth.
Hands-on experience architecting Microsoft Azure data platforms, including Azure Synapse Analytics, Azure Data Factory, Azure SQL Database, and Azure Data Lake Storage Gen2, with advanced SQL proficiency and enterprise data integration experience.

Responsibilities

Assist in building and managing data pipelines that support value creation, growth, and business and IT results.
Design and implement data and analysis infrastructure, including complex databases.
Assist in developing technical tools and services that enable large-scale machine learning solutions.
Work with data analysts and others to develop scalable, production-ready advanced analytics and supporting software.
Build and maintain data management systems and pipelines that combine core data sources into warehouses or other accessible structures for reporting and analytics.
Document models, solutions, and implementations, including data mappings, technical specifications, production support materials, data dictionaries, and test cases.
Create data transformation processes, including ETL and SQL stored procedures, for moderately complex to complex business systems and operational data flows.
Work across City departments with IT teams and subject matter experts to plan and deliver analytics and data solutions.
May provide leadership, work assignments, evaluation, training, and guidance to others.
Travel to multiple sites as part of regular job duties.
Report to work during emergencies or bad weather when required as essential personnel.