Data Architect
$180,000–$190,000 year
On-siteVienna, Virginia, United States
Job Summary
Lead the technical design and execution of a large-scale BI migration at the U.S. Department of Transportation, moving thousands of reports from Oracle Data Warehouse/OBIEE to a Databricks platform with Tableau. Architect the Tableau data source layer, design gold-layer data models, and maintain automated and manual conversion processes that leverage AI/LLM-generated outputs. Resolve structural differences between OBIEE and Tableau architectures while collaborating with Data Engineers on ETL pipeline design and Unity Catalog governance. Own validation frameworks for source-to-target reconciliation and provide technical mentorship to Junior BI Developers. Participate in Agile ceremonies, contribute to migration playbooks, and present to stakeholders.
Required Qualifications
- BS degree in Computer Science, Data Analytics, Information Systems, Engineering, Mathematics, Statistics, or a related discipline
- 10+ years of experience in data architecture, including designing dimensional models for analytical and reporting environments
- At least 5 years of that experience must include hands-on work with BI tools and reporting platforms, designing data structures to serve BI consumption (Tableau, Power BI, OBIEE or comparable tools)
- Hands-on proficiency with Databricks
- Must be able to write Spark SQL
- Must be able to design medallion-layer architectures
- Expert-level SQL skills
- Ability to design repeatable processes, standards, and architectural patterns that enable a team to execute consistently at scale
- Effective at communicating architectural decisions and trade-offs to both technical teams and non-technical stakeholders
- Effective at working in Agile delivery environments with cross-functional teams
Desired Qualifications
- Experience with BI platform migrations (OBIEE-to-Tableau, or similar conversions)
- Experience using AI/LLM tools in a professional workflow - particularly for code generation, metadata analysis, or pipeline automation
- Familiarity with OBIEE RPD architecture (physical, logical, presentation layers)
- Python proficiency for scripting, automation, or metadata analysis
- Experience with Tableau APIs
- Experience working in a federal government IT environment
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.