Data Warehouse Sr. Information Architect in San Jose, CA at APEX Systems

Date Posted: 2/14/2020

Job Snapshot

Job Description

Job #:  1020493


Project Specific Tasks/Deliverables:

Description of Work:
The Public Health team has created a prototype of a new data warehouse using the Data Vault 2.0 methodology. An Information Architect with expert skills and extensive background in Data Vaulting is needed to review, validate, and provide information architecture guidance to the project. The Information Architect is expected to review and develop data models and standards in support of this large data integration and analytics project. They will review the identity
matching and reconciliation processes and make recommendations for synchronizing identities across operational and analytical systems. They will help classify data and recommend any necessary security and access control policies.

In addition, the Senior Information Architect is expected to help plan and conduct a Proof of Concept (POC) and Training project using the Snowflake Cloud Data Warehousing services. Ideally, the Senior Information Architect would have recent experience with Snowflake, but additional resources may be necessary. The County desires to provide certified Data Vault
2.0 training to approximately 6-10 people. Some or all of these resources will then form a POC team, and receive additional training in Snowflake, to reproduce the existing Public Health Data Vaults in the Snowflake cloud environment. The project involves making a copy of on-premise raw staging data and loading it into Data Vault structures in Snowflake. Existing SQL Server SSIS ETL processes will be recoded and implemented in Snowflake and performance and scalability
tests will be conducted comparing the existing on premise SQL Server environment to the cloud Snowflake environment. A “lessons learned” findings report and presentation will be delivered to several IT managers and executives. The report should highlight the benefits and potential pitfalls of using Snowflake.

Outcomes of Deliverables:
  • Documented information architecture and data models of Public Health Data Vaults for Phase 2
  • Documented Identity synchronization strategies and plans
  • Fully functional prototype of data vaults in Snowflake cloud environment
  • Proof of Concept Findings Report



Knowledge Transfer Plan:
  • Weekly Status Reports
  • Certified technical training for staff in Data Vault 2.0 methodology
  • Proof of Concept findings report and presentation

     

Generic County Job Description:

General Experience:
Typical Tasks:
1. Confirms regulatory issues are considered surrounding information assets (such as
  consumer privacy laws, data retention policies, outsourced data and specific industry
  guidelines are adhered to;
2. Monitors data quality, and analytical systems usage, and takes corrective and
  enhancement actions as necessary
3. Leads the IT enterprise-wide technical and business discussions relative to future
   enterprise direction;
4. Develops IT strategy and aligns the strategy with organization goals;
5. Establishes the scope of information architecture activities, including external
  (industry) collaboration areas;
6. Oversees the implementation of a discipline and approach for information assets;
7. Consults on the identification of information that the organization produces and
  consumes;
8. Consolidates a business view of data across the education, research and
  administrative functions;
9. Reviews and approves data model designs with a focus on those areas influencing
  interoperability, analytics including compliance with the portfolio information model;
10. Reviews and/or analyzes and develops architectural requirements for the IT
  enterprise-wide level;
11. Approves modification of the information architecture to accommodate project needs;
12. Leads the development and execution of a communication and education plan for the
  IT system architecture; responsible for the overall training and development of the
  architect family staff;
13. Collaborates in defining solution architecture for Master Data Management (MDM);
14. Reviews and approves the strategic requirements, principles, models and designs that
  strengthen the network effect of sharing such information across the IT system;
15. deployment;
16. Collaborates in the definition and implementation of the enterprise disaster recovery
  approach and plan for the recovery of the IT service portfolio and environment, to
  meet the need for immediate business continuity and resumption;
17. Provides strategic consultation to clients and IT teams; advises on options, risks, costs
   versus benefits, system impacts, and technology priorities;
18. Develops IT enterprise-wide policies, standards, guidelines and procedures
  pertaining to information architecture, sharing and integration;
19. Collaborates with other IT teams in the management of technical change, verification
   of testing results, and monitoring of technical standards compliance and deployment;
20. Reviews and approves the organizational requirements for the resources, structures
  and cultural changes necessary to support initiatives;
21. May be assigned as a Disaster Service Worker, as required;
22. Performs other related duties as required.
 
Employment Standards:
Sufficient education, training, and experience to demonstrate the possession and direct application of the following knowledge and abilities.

Training and Experience Note:
Bachelor’s degree in Computer Science, Information Systems, Computer Engineering, System
Analysis or a related field from an accredited college,
And
Fifteen (15) years of IT and business/industry work experience including data modeling, data
integration, metadata management, master data management, business intelligence and analytics,
or establishment of data architecture. Five (5) years of experience must have been at a level
comparable to the County’s Information Architect.
 
OR
 
Bachelor’s degree from an accredited college,
And
Seventeen (17) years of IT and business/industry work experience including data modeling, data
integration, metadata management, master data management, business intelligence and analytics,
or establishment of data architecture. Five (5) years of experience must have been at a level
comparable to the County’s Information Architect.
 
Special Requirements

• Possession of a valid California Driver’s License prior to appointment

• Depending on the position, related certifications may be required or desirable.
 
Knowledge of:
1. Principles of leadership;
2. External (industry) collaboration areas;
3. Business view of data across the education, research and administrative functions;
4. Principles of training and staff development;
5. Regulatory issues related to information assets;
6. IT system strategy;
7. Information architecture standards and methodologies;
8. Strategic requirements, principles, models and designs related to information
  architecture;
9. Information structure and features, functionality, and user-interface design;
10. Data valuation process for data objects;
11. Well-integrated development activities;
12. Data mappings of application interfaces and data models;
13. Information architecture models (e.g., conceptual, logical, canonical);
14. Roadmaps analysis, design, and implementation;
15. Enterprise disaster recovery and planning;
16. Organization requirements for the resources, structures and cultural changes necessary to
  support initiatives;
17. Applicable policies, standards, guidelines and procedures pertaining to information
  architecture;
18. Technical change, verification of testing results, and monitoring of technical standards
  compliance and deployment;
19. More than one design method and at least one discipline that is considered to be at the
  level of a subject matter expert;
20. Business processes in the work environment;
21. Guidelines and standards for cataloging and maintaining data repositories;
22. Single source data strategy;
23. Data design and transformation procedures;
24. Data models, associated metadata models, common business vocabulary, ontologies and
  taxonomies;
25. Consumer privacy laws, data retention policies, outsourced data and specific industry
  guidelines;
26. Mapping and audit-ability of information assets;
27. Site maps, use cases, business process flows, and navigational flows;
28. Conflict resolutions among models, ensuring that data models are consistent with the
  enterprise model (e.g.: entity names, relationships and definitions;
29. High level modeling of key program processes and key data entities;
30. Methods to align architectural strategy with business requirements;
31. Analysis, design, and development of a roadmap and implementation plan based upon a
  current versus future state in a cohesive architecture viewpoint; Specialized architecture  
  governance processes;
32. Post-implementation continuous-improvement efforts to enhance performance and
  provide increased functionality.
 
Ability to:
1. Lead technical and business discussions;
2. Align strategy with organization goals;
3. Consolidate business view of data across the education, research and administrative
  functions;
4. Review and approves data model designs;
5. Lead the development and execution of a communication and education plans.
6. Coordinate development activities to ensure consistency and integration;
7. Create information architecture models (e.g. conceptual, logical, canonical);
8. Analyze, design, and develop roadmaps and implementation plans;
9. Define and implement disaster recovery approach plans;
10. Implement data design and transformation procedures;
11. Develop usable information architecture;
12. Adhere to applicable regulations surrounding information assets;
13. Create a framework for representing the data elements;
14. Resolve conflicts between data models;
15. Consult and collaborate with multiple IT teams and business leaders;
16. Write effective policies, standards, guidelines and procedures;
17. Gather and analyzes data at the project/program level;
18. Assess business needs and establish business priorities.
 
 
 
 
 
 
 
 
EEO Employer
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at 844-463-6178.