Knowledge architect vs data warehouse architect

Differences between knowledge architect and data warehouse architect duties and responsibilities

Knowledge architect example responsibilities.

• Design, develop, and manage SharePoint portal sites for teams and departments to communicate effectively and exchange information.
• Manage offshore engineering team, overcoming challenges including technical, resource planning & motivation, communication, and infrastructure.
• Hire technical talent to build a successful cloud platform data services organization.
• Develop script to automatically verify writer's XML and show exact location of invalid XML.
• Develop Splunk dashboards for proactive monitoring and support of each service tier of cloud ETL ecosystem.
• Designate as project lead for evaluation and acquisition of SAN architecture, including IBM, NetApp and EMC storage.
Show more

Data warehouse architect example responsibilities.

• Design dimensional data models, develop SQL and UNIX scripts to automate extraction and loading of data.
• Report procedures against SSAS are constructed and ExcelWriter templates are developed to automate and replace existing manually generate, client-contract reports.
• Design and build PL/SQL code to extract, transform and load the data into the star schema objects.
• Design the data warehouse with star and snowflake schemas.
• Develop the SAS enterprise guide data research and ad hoc reports and store procedures.
• Debug and tune queries for semantic layer (consume by Java screens and MicroStrategy).
Show more