Job Description :
DirectClient: Texas Department of Comptroller of Public Accounts(CPA)
Title: Data Warehouse Architect
Location: Austin, Texas 78774
Duration: 12+ Months Contract with possible 2 years extension
Last date for submission: August 16, 2017(2.00 PM-CST)

Job Description:
The Worker will perform highly advanced oversight and direction in support of a Business Intelligence / Data Warehouse project in order to ensure project success. The Worker must also have strong hands-on experience and proven success designing/architecting technical solutions for a large Business Intelligence / Data Warehousing project. The worker will also identify problems, propose innovative solutions, and provide advanced system expertise and training oversight. The worker will evaluate and recommend business needs, analyze processes and provide independent verification and validation throughout the project life cycle. The Worker will oversee and/or participate in day-to-day management of the design, development, testing and implementation of the BI/DW project.

Must be able to work with Business Customers, Section Managers, Project Managers, Business Analysts and Subject Matter Experts (SMEs) in a professional and collaborative manner to design strategies and implementation approaches
Must be able to work with the Data Warehouse, Database Administration, and Business Intelligence Teams in a professional and collaborative manner to ensure that data models comply with organizational standards
Must prepare all required artifacts accurately and in a timely fashion
Must possess strong written, verbal, and interpersonal communication skills
Must be able to develop processes and procedures for Data Warehouse and Business Intelligence infrastructure
Must be able to work independently in a team environment with local and remote teams
Must possess knowledge of project management methodologies both traditional and Agile/Scrum
Must possess problem-solving skills and ability to multi-task with readiness to put in extra efforts when necessary
Must perform work as assigned without direct supervision

Minimum (Required):
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
7 Experience with data warehouse architecture standards, process, and methodology, with good knowledge of data integration, data quality, multi-dimensional design and ETL tools.
4 Experience working with data bases DB2 LUW, Oracle 12c, MSSQL Server, NoSQL and Teradata
4 Experience with DB2 data warehouse development
4 Experience in re-architecting existing systems to an enterprise ready solutions
3 Extensive experience with complex application and data security requirements
3 Experience working with IT and business customers
1 Hands-on experience in designing solutions with end user self-service in focus.

Preferred (Optional):
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

Client : CPA