Data Architect

Data Architect

Phoenix, AZ

Client Job ID : 87718

Job Description

• The Architect shall provide a Data Architecture to develop and implement an enterprise Data Warehouse Solution in support of the single source of truth and business process root cause analysis. The data warehouse will serve as a centralized repository for multiple data sources from internal and external sources. Gather requirements from stakeholders, prepare Data Warehouse Requirements Document, and create Data Warehouse Design Document.

The Data Warehouse Requirements Document will include usability requirements, security requirements, businesses requirements, data requirements, query requirements, and interface requirements. The Data Warehouse Design Document shall include the operational requirements, application architecture, information architecture, interface architecture, technology architecture, and security architecture.

Qualifications:

Qualifications / Skills Matrix

• Must have a thorough understanding of modern information technology infrastructure practices and possess at least ten (10) years of experience doing the following:
• Defining, designing and building relational and dimensional databases. Performing data access analysis design, and archive/recovery design and implementation.
• Maps source system data to data warehouse models
• Translating business needs into long-term architecture solutions.
• Developing and testing ETL processes
• Reviewing and developing object and data models and the metadata repository to structure the data for better management and quicker access.
• Coordinating with business users to develop scripts, queries, or software code to accomplish specific requirements or tasks.
• Hands-on expertise in data warehousing and architecture, data modelling, master data, big data analytics, real-time analytics, and data visualization, and reporting
• Hands-on management of SQL Server 2012 or higher, Oracle, or IBM DB2, involving implementation of schemas, indexes, and query optimization
• Experience with Developing strategies for data acquisition, archive recovery, and implementation of a database.

PLEASE ASK IF THEY HAVE BEEN SUBMITTED TO DES IN THE LAST 3 MONTHS

Local AND non-local Candidates - Resumes must specify the current location of the candidate, all those who do not state current location will not be considered. - AS A REMINDER - Candidates must be available to interview within 1 week of the posting close date. Candidates must also be able to start by the target start date set down in the offer email. Any non-local candidate must be willing to relocate by the targeted start date at NO FEE to the agency.

Tentative start date will be dependent upon interviews conducted, successful background check process, and the state agency issuing a PO

***The resource MUST be able to clear a 7 year Package A background, obtain a Fingerprint Clearance Card, and complete a Certification of Criminal Offense Form with notary.