Data Warehouse Architect

We are seeking an experienced data warehouse architect and team lead to join a growing BI development team. Experience with data warehouse design, advanced SQL, and PL/SQL development is essential. Please note that this is a Department of State contract and all candidates must be U.S. citizens to be considered.
  • 7+ years experience working with complex data warehouse projects
  • Experience implementing data warehouse projects following the Business Dimensional Lifecycle/Kimball method
  • Experience in architecting a data warehouse from the ground up, including but not limited to Business Objects Universe design, design of ETL processes and ETL strategy, security, auditing, maintenance, availability, etc.
  • Experience with Oracle 10g databases
  • Development experience Business Objects Data Services
  • Experience with Business Objects XI r2 Business Intelligence suite
  • Proficient in dimensional data modeling
  • Develop both logical and physical architectures from defined requirements
  • Knowledge of and experience with implementing Data Management standards
  • Knowledge of network architecture and hardware required to implement a data warehouse, such as servers, NetApp SAN, etc.
  • Capable of providing technical leadership to the EDW team and government customer.
  • Ability to analyze source data for potential data quality issues
  • Sufficient knowledge to identify and help avoid pitfalls associated with data warehousing
  • Capable of documenting system architecture and prepare a design document that is easily understandable to less technical individuals
  • Must be self-motivated and able to manage priorities among multiple demanding tasks
  • Experience as a contractor working on-site in a government facility
  • Ability to effectively communicate information, both verbally and written, to end users and executive management
  • Team player, must be able to work professionally and collaboratively with the government customer and other contract members of the project team.
  • Facilitate meetings with subject matter experts, business, and technical teams as well as documenting agreements and generating meeting minutes.
  • Experience with SAP Business Objects
  • Enterprise BI toolset, specifically Data Services and Universe Designer
  • Experience with one or more enterprise level ETL tool
Ballston VA
Send An Email (