IT Data Architect

City of Austin WaterAustin, Texasa month ago

Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.

  1. Manages logical, physical and dimensional modeling
  2. Creates accurate modeling reflecting user requirements
  3. Performs systems interfacing
  4. Develops physical databases meeting performance requirements
  5. Defines strategies for database implementation
  6. Defines and implements processes for extracting and loading data
  7. Develops infrastructure, data, software, security, and/or business process architectures
  8. Develops data management policies and standards
  9. Implements key components
  10. Develops test criteria
  11. Provides technical assistance in identifying, evaluating, and developing systems and procedures


Responsibilities- Supervision and/or Leadership Exercised:

  • Technical leadership to database and systems development group, lead project teams, may supervise and/or lead technical staff

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 Database Design
  • Knowledge of Data Migration Tools
  • Skill in data Analysis and
  • Skill in Data Modeling
  • Skill in Data Integration
  • Skill in Data Warehousing
  • Skill in Database
  • Skill in oral and written communication
  • Skill in Consulting
  • Skill in building team relationships and partnerships
  • Ability to lead groups
  • Ability to solve complex data design problems 
  • Ability to manage multiple tasks/functions concurrently

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, two (2) years of which were in a lead or supervisory capacity.
  • Masters degree may substitute for experience up to two (2) years.
  • Education or experience may substitute up to four (4) years.

Preferred Qualifications:

  • Demonstrated experience with design, development, testing and maintenance of complex applications using Agile Methodology
  • Experience with large enterprise-wide database systems, and integration between related systems
  • Experience configuring, providing business user and technical support for large Enterprise Applications
  • Demonstrated experience in maintaining and designing data warehouses, data marts, data cubes and data lakes
  • Experience developing infrastructure, data, software, security, and/or business process architectures
  • Demonstrated experience in Service Oriented Architecture, including data integration and development of Web Services Simple Object Access Protocol (SOAP)/ Representational State Transfer (REST)
  • Experience with MS SSRS and SSDT (SSIS) for data source integration or a similar integration tool
  • Experience using MS SQL Server, Oracle, data development skills and SQL queries optimization/database performance tuning
  • Ability to travel to more than one work location

Subscribe to Job Alerts

All Categories