Job ID: TX-DIRCPOITSAC2001 (911890306)
Data Warehouse Architect with data governance/engineering/management, MySQL/Oracle/SQL Server/PostgreSQL, S3, HDFS, MongoDB, BI, MDM, metadate, business analytics and cloud storage experience
Location: Austin TX (DIR)
Duration: 6 months
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.
YearsRequired/PreferredExperience
10RequiredExperience in enterprise information management processes and methodologies, relational database management systems
10RequiredExperience in data management and data governance
10RequiredExperience working with a variety of data sources such as MySQL, Oracle, SQL Server, PostgreSQL, S3, HDFS, and MongoDB
8RequiredExperience in data warehouse strategy, data engineering, and designing data warehouses using modern technologies
8RequiredExperience in master data, metadate, reference data, data warehousing, and business intelligence principles and processes
8RequiredExperience with full life cycle development, architecture and implementation, of an enterprise data warehouse.
8RequiredExperience in data engineering for business intelligence and business analytics
5RequiredKnowledge of modern cloud storage characteristics and operational efficiencies based on business use and data types.
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.