Previous Job
Previous
Sr. Information Architect - Data Vault, Snowflake
Ref No.: 19-01472
Location: San Jose, California
You’re covered with eXcell. We offer our temporary employees full benefits. Always have. Always will. Join us!
 
Our client 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 client intends 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 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.

Qualifications:
  • 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
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
  • Possession of a valid California Driver's License prior to appointment
  • Related certifications may be required or desirable
Knowledge of:
  • Principles of leadership
  • External (industry) collaboration areas
  • Business view of data across the education, research, and administrative functions
  • Principles of training and staff development
  • Regulatory issues related to information assets
  • IT system strategy
  • Information architecture standards, and methodologies
  • Strategic requirements, principles, models, and designs related to information architecture
  • Information structure and features, functionality, and user interface design
  • Data valuation process for data objects
  • Well-integrated development activities
  • Data mappings of application interfaces and data models
  • Information architecture models (e.g., conceptual, logical, canonical)
  • Roadmaps analysis, design, and implementation
  • Enterprise disaster recovery and planning
  • Organization requirements for the resources, structures and cultural changes necessary to support initiatives
  • Applicable policies, standards, guidelines, and procedures pertaining to information architecture
  • Technical change, verification of testing results, and monitoring of technical standards compliance and deployment
  • Business processes in a work environment
  • Guidelines and standards for cataloging and maintaining data repositories
  • Single source data strategy
  • Data design and transformation procedures
  • Data models, associated metadata models, common business vocabulary, ontologies and taxonomies
  • Consumer privacy laws, data retention policies, outsourced data, and specific industry guidelines
  • Mapping and audit-ability of information assets
  • Site maps, use cases, business process flows, and navigational flows
  • Conflict resolutions among models, ensuring that data models are consistent with the enterprise model
  • High level modeling of key program processes and key data entities
  • Methods to align architectural strategy with business requirements
  • Analysis, design, and development of a roadmap and implementation plan based upon a current versus future state in a cohesive architecture viewpoint
  • Post-implementation continuous-improvement efforts to enhance performance and provide increased functionality
Ability to:
  • Lead technical and business discussions
  • Align strategy with organization goals
  • Consolidate business view of data across the education, research and administrative functions
  • Review and approves data model designs
  • Lead the development and execution of a communication and education plans
  • Coordinate development activities to ensure consistency and integration
  • Create information architecture models (e.g. conceptual, logical, canonical)
  • Analyze, design, and develop roadmaps and implementation plans
  • Define and implement disaster recovery approach plans
  • Implement data design and transformation procedures
  • Develop usable information architecture
  • Adhere to applicable regulations surrounding information assets
  • Create a framework for representing the data elements
  • Resolve conflicts between data models
  • Consult and collaborate with multiple IT teams and business leaders
  • Write effective policies, standards, guidelines and procedures
  • Gather and analyzes data at the project / program level
  • Assess business needs and establish business priorities
 
We will consider for employment all qualified applicants, including those with criminal histories, arrest, and conviction records in a manner consistent with the requirements of applicable state and local laws. This includes the City of Los Angeles Fair Chance Initiative for Hiring Ordinance as well as the San Francisco Fair Chance Ordinance.

W2 only, no Corp to Corp. We are unable to sponsor H1B visas at this time. **eXcell™ Supports Equal Employment Opportunity** eXcell™, a division of CompuCom® Systems, Inc., a global company headquartered in Bellevue, Washington, provides IT staffing services and solutions to Fortune 1000 companies as well as small and medium business. For more information, visit www.excell.com.