View all jobs

Data Warehouse Architect - Texas Department of Information Resources - Austin, TX

Austin, TX · Information Technology
Data Warehouse Architect - Texas Department of Information Resources - Austin, TX

Data warehouse architect will help modernize DIR’s data warehouse infrastructure by assessing the current data warehouse environment, understanding DIR’s agency wide data needs and architect a new data warehouse for the use of the entire agency. The design should include optimizing performance and ease of use for end users, enhancing functionality, decreasing total cost of ownership while making it possible for real-time decision making. Role will include data profiling, data standardization, data acquisition, data transformation, and integration best practices along with policies to maintain and support data integrity and security.
The agency’s current data warehouse is using an Oracle Supercluster. The agency uses both Oracle and SQL databases to support our applications and reporting needs. The Oracle Supercluster will be replaced by either Oracle Exadata or Fractional servers to be determined.
The data warehouse architect will focus on designing a solution and recommending a database strategy to be procured through the DIR Master Contracts and consult during the development and implementation phase. 
Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity and the resume will not be submitted to the customer.
Years Required/Preferred Experience
10 Required Experience in enterprise information management processes and methodologies, relational database management systems
10 Required Experience in data management and data governance
10 Required Experience working with a variety of data sources such as MySQL, Oracle, SQL Server, PostgreSQL, S3, HDFS, and MongoDB
8 Required Experience in data warehouse strategy, data engineering, and designing data warehouses using modern technologies
8 Required Experience in master data, metadate, reference data, data warehousing, and business intelligence principles and processes
8 Required Experience with full life cycle development, architecture and implementation, of an enterprise data warehouse.
8 Required Experience in data engineering for business intelligence and business analytics
5 Required Knowledge of modern cloud storage characteristics and operational efficiencies based on business use and data types.

To be considered for this position, please send the following to Zandra at Pedigo Staffing Services, zandra@pedigostaffing.com
  • Resume in MS Word .doc or .docx format
  • Current & Expected Salary 
  • Date available to start
Powered by