Job Description :
DirectClient: Texas Comptroller of Public Accounts (CPA)
Title: Data Warehouse Architect
Location: Austin, Texas 78774
Duration: Until August 31, 2019 with possible extension
Last date for submission: October 31, 2018 (2.00 PM-CST)
Job Description:
As a Data Warehouse Architect, the Worker must have a strong background architecting and developing technical solutions for data warehouse and business intelligence. The Worker will be extensively engaged with customers to collect requirements and must have had highly advanced oversight and responsibility for modeling, configuration, development, and implementation of Data Warehouse solution for a large group or organization. The Worker must be able to quickly understand existing architecture and application requirements. The Worker should be able to design and develop enterprise ready solution with conformed data warehouse standards. The worker should provide solutions to Application reporting requirements as well as Data Warehouse needs. The worker must have experience developing processes and procedures in support of a large enterprise BI/DW environment. The Worker must be able to follow software development processes, prepare detailed documentation and generate work estimates in an SDLC environment. The Worker must be quality conscious and be dedicated to delivering quality products on time and on budget.
WORKER SKILLS AND QUALIFICATIONS
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 (TSQL, 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