Austin Aviation IT Data Architect
About This Position
As an IT Data Architect, you will design, build, and optimize the enterprise data platform that powers reporting, analytics, artificial intelligence, and business decision-making.
You'll develop scalable data pipelines, integrate data from multiple systems, and create modern data architectures such as data warehouses, data lakes, and data hubs. Working closely with business stakeholders, data analysts, engineers, and application teams, you'll ensure data is accurate, secure, accessible, and production-ready.
This role combines technical expertise with strategic thinking, requiring experience in ETL/ELT, SQL, cloud data platforms, data modeling, automation, and modern analytics technologies. Success in this position means transforming complex data into trusted enterprise assets that enable smarter decisions across the organization while following governance, security, and change management best practices.
Job Description
IT Data Architect
Purpose
IT Data Architects build and manage the data pipelines necessary to support value creation, growth, and delivery of IT results through designing and implementing the data and analysis infrastructure. This position optimizes data pipelines and moves data pipelines effectively into production for key data and analytics consumers by working across the City and with IT and other subject matter experts to plan and deliver optimal analytics and data solutions to users.
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.
- Assists in building and managing the data pipelines necessary to support value creation, growth, and delivery of business and IT results.
- Designs and implements the data and analysis infrastructure, including complex databases.
- Assists in developing different technical tools/services to enable large scale machine learning solutions.
- Works closely with Data Analysts, and others to develop scalable and production ready Advanced Analytics and supporting software.
- Assists in building and maintaining data management systems and data pipelines that combine core data sources into data warehouses or other accessible
- structures to support reporting and analytical systems.
- Documents models, solutions, and implementations (e.g., Data Mapping, Technical Specifications, Production Support, Data Dictionaries, Test Cases, etc.).
- Creates data transformation processes (ETL, SQL stored procedures, etc.) to support moderately complex to complex business systems and operational data flows.
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 languages such as (R, Pearl, Python, Java, C++, C#, Scala etc.), modern data storage and access technologies, including caching, application of NoSQL, Key/Value, and RDBMS datastores.
- Knowledge of commercial data science platforms (e.g., Python, R, KNIME, Alteryx, etc.).
- Knowledge of Extract-Transform-Load (ETL) processing and Change Data Capture (CDC) technologies.
- Knowledge of big data concepts and frameworks and business intelligence tools (such as Tableau, Qlik, PowerBI) and AI frameworks (Caffe, TensorFlow)
- Knowledge of Data Management architectures like Data Warehouse, Data Lake, Data Hub and the supporting processes like Data Integration, Governance,
- Metadata Management.
- Knowledge of data pipeline guiding principles, and best practices to build and maintain data pipelines.
- Skill in data storage, data processing, database fundamentals, data orchestration and automation, programming, CI/CD, data validation and testing, version control systems, scripting and coding, cloud migration, metadata management, infrastructure as a code (IAC), data monitoring and observability skills.
- 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 to identify critical issues faster in order to debug and troubleshoot quickly.
- Ability to work with and across teams and foster a cooperative and efficient working environment.
- Ability to consider and incorporate the implications of analysis into recommendations for business decisions.
- 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.
Minimum Qualifications
- Graduation with a Bachelor’s degree from an accredited college or university with major coursework in Information Science or in a field related to the job, plus five (5) years related experience.
- Masters degree may substitute for experience up to two (2) years.
- Education or experience may substitute up to four (4) years.
Licenses and Certifications Required
None.
Preferred Qualifications
- Experience designing and implementing enterprise data architectures, including conceptual, logical, and physical data modeling, dimensional modeling (Star Schema), data warehouses, and governed data marts to support enterprise analytics and data reuse.
- Experience establishing enterprise data governance frameworks, including data taxonomy, master data management (MDM), 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 (ADF), Azure SQL Database, and Azure Data Lake Storage Gen2, with advanced SQL proficiency and enterprise data integration experience.
Compensation Range
The annual hiring range for this position is $96,180.00-$123,100.00
Notes to Candidate
As an IT Data Architect, you will design, build, and optimize the enterprise data platform that powers reporting, analytics, artificial intelligence, and business decision-making.
You'll develop scalable data pipelines, integrate data from multiple systems, and create modern data architectures such as data warehouses, data lakes, and data hubs. Working closely with business stakeholders, data analysts, engineers, and application teams, you'll ensure data is accurate, secure, accessible, and production-ready.
This role combines technical expertise with strategic thinking, requiring experience in ETL/ELT, SQL, cloud data platforms, data modeling, automation, and modern analytics technologies. Success in this position means transforming complex data into trusted enterprise assets that enable smarter decisions across the organization while following governance, security, and change management best practices.
Salary Range: $96,180-$123,100
Travel
This position requires traveling to multiple sites as part of the regular job duties. A driving record verification will be conducted. 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. Go to the Driver Safety Program for more information at City of Austin Driver Safety Standards.
Skills Assessment
A skills assessment/s will be required for this position.
Essential Personnel
This position is categorized as essential personnel. Essential personnel are required to come to work during emergencies or bad weather at the airport if they are scheduled to work and, in some cases, when they are not scheduled.
Application Information
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 (i.e., “see resume” or “see LinkedIn profile”). Resumes will not be used to qualify for the position and will not be used to recommend salary. Supplemental information or changes to your application will not be accepted after the job posting closes. The responses to the supplemental questions inquiring about experience should be reflected on your application.
Applicants/Candidates must personally respond to all application questions, interview questions, technical questions, assessments, and other job-related evaluation activities. The use of artificial intelligence or other tools to generate, augment, or provide responses during the evaluation process is prohibited.
Important Note to Applicants
Please be aware that the Job Posting Close Date and the final day to apply will be at 11:59 PM the day before the date listed. All application steps, including attachments and submission, must be fully completed before that time.
Department may close this job posting at any time after 7 days
We also recommend that you save or print a copy of the job posting for your records. Once a posting has closed, it will no longer be viewable in the system.
Post Interview Verification
If you are selected as the top candidate for a position, we will contact your current and former employers, as well as the references listed in your application. Please do your best to ensure that the contact information on the application is accurate. Top candidates are also required to provide proof of education from an...