Back to Employment Opportunies

Data Warehouse Architect (Federal, Azure)

Job Description

The Data Warehouse Architect will be the specialist technical lead for a multiyear data access modernization project and will work as a coequal leader with the Program Manager and Solutions Architect to provide a compliant, functional, and performant product that meets the requirements of multiple stakeholders in a federal agency.

This is a lead-by-example role and will produce code and frameworks for others to emulate and use; the architect will be a trusted partner of both agency stakeholders and the solution delivery team.

This role will require not just data warehousing design skills but also pre-SQL data engineering interest and data archaeology skills.


  • 15 years of progressive technical responsibility, 10 of which as a developer or lead
  • Thorough understanding of:
    • SQL database design and implementation
    • ETL
    • Governance concerns and strategies
    • Data warehouse/lake models and tradeoffs
    • Data engineering and pipelines
    • Data cleansing and resilient format conversion
  • Polished communication and presentation skills via phone/video
  • Influencing skills
  • Risk evaluation and mitigation planning
  • Detailed, actionable technical writing
  • Open view of best-tools-for-the-job, versus a favorite-technology-first approach
  • US Citizen or permanent resident, clearable


  • Azure solutions implementation experience (beyond VMs and storage)
  • At least one experience in the past ten years of a cross-functional systems implementation in a federal agency (with a completed ATO)
  • Understanding of Azure services including PaaS offerings
  • Office 365 development experience
  • Data migration and modernization experience

Want to find out more about OPTiMO?

Learn More About Us