IT Data Architect

City of Austin WaterAustin, Texas25d 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:

  • Experience with AMI (Advanced Metering Infrastructure) or another large enterprise-wide database system, and integration between related systems
  • Demonstrated experience in Service Oriented Architecture, including data integration and development of Web Services Simple Object Access Protocol (SOAP) / Representational State Transfer (REST)
  • Experience configuring, providing business user and technical support for asset and work order management systems such as Infor Public Sector (IPS), Enterprise Asset Management (EAM), Maximo, Customer Care and Billing (CC&B), or comparable systems
  • 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
  • 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
  • Experience implementing complex projects using Agile Methodology
  • Ability to travel to more than one work location

Subscribe to Job Alerts

All Categories