Job Description :
DirectClient: Texas Department of Comptroller of Public Accounts(CPA)
Solicitation#304125923
Title: Data Warehouse Architect
Location: Austin, Texas 78774
Duration: Until 8/31/2021
Last date for submission: September 14, 2017(2.00 PM-CST)
Minimum Requirements:
Years Skills/Experience
8 Extensive hands-on experience in architecting, configuring and implementing Data Warehouse solutions for a large group or organization
8 Expertise in requirement gathering, customer engagement and project management
8 Experience with multi-database environment development
8 Experience with data warehousing design/development (ties to HCM/Financial desired)
8 Experience with database programming (T-SQL, PL/SQL, BTEQ)
8 Experience with ANSI standard database environment development (DB2/Oracle/Teradata)
8 Experience with metadata solution development
8 Experience with advanced reporting and analytics
8 Advanced ETL tool or solution development
7 Experience with data warehouse architecture standards, process, and methodology, with good knowledge of data integration, data quality, multi-dimensional design and ETL tools.
5 Experience with DB2 data warehouse (10.1v or higher) development
5 Experience in re-architecting existing systems to an enterprise ready solutions
4 Hands-on experience with near/real-time data integration design
4 Extensive experience with complex application and data security requirements
4 Experience working with IT and business customers
1 Hands-on experience in designing solutions with end user self-service as the primary focus.
Preferences:
Years Skills/Experience
3 Proficient with the Microsoft Windows and Office products
3 Public sector experience (Federal, State or Local Government)
1 Working with State agency projects preferably Comptroller of Public Accounts (TX-CPA) experience