Previous Job
Technical Architect
Ref No.: 18-00457
Location: Jefferson City, Missouri
Position Type:Contract
Start Date: 08/22/2018
Job Description - Technical Architect
Location: Jefferson City, MO and Santa Fe, NM
No of Seats 2 – one for each location
Duration – Long Term

Conceptual understanding of the following are required beyond solid DW Architecture, DWH Modelling and Healthcare industry experience for a couple of DWH projects.
  • Understanding of ETL/BI Architecture landscape and best practices
  • Conceptual understanding of following Key ETL Concepts:
    • Handling incremental load Process;
    • Designing Change Data Capture process;
    • Fact and Dimension load process;
    • Fundamentals of Handling high data volume load;
    • Performance optimization best practices
  • Conceptual understanding of following Key BI Concepts:
    • BI Design best practices;
    • Report/Dashboard Performance optimization best practices;
    • Understanding of SQLs and SQL optimization best practices;
    • Handling User & Data Security