Data Architect

Tetra Tech; Vienna (VA); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Company-supported benefits

Federal holiday + PTO

401(k) with company matching

Tuition assistance

Commuter benefits

Job summary

Halvik Corp is seeking a Data Architect with significant BI experience to lead a large-scale migration from Oracle Data Warehouse/OBIEE to a Databricks platform with Tableau reporting. You will design gold-layer data models for Tableau, define the Tableau data source layer, and oversee automated and manual conversion processes.

The role requires deep data modeling expertise and hands-on BI tooling knowledge.

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, and 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.

Responsibilities

• Maintain the Databricks gold-layer data models that serve as the foundation for all Tableau data sources and reports.
• Architect the Tableau data source (TDS) layer, defining how gold-layer tables are surfaced as published data sources.
• Own the repeatable report conversion process - AI-assisted and manual paths with quality gates.
• Resolve the structural differences between OBIEE and Tableau architectures.
• Collaborate with Data Engineers on ETL pipeline design and governance considerations.
• Design validation frameworks and automated reconciliation pipelines.
• Maintain and improve the AI/LLM-assisted conversion pipeline.
• Analyze OBIEE RPD metadata to map data lineage and inform migration sequencing.
• Provide technical mentorship to Junior BI Developers.
• Contribute to migration playbooks, architecture docs, and agile ceremonies.

Skills

BI design

Mentoring

Agile delivery

Communication

Architecture decisions

Education

BS degree in Computer Science or related field

Tools

Databricks

Spark SQL

SQL

Tableau

Power BI

OBIEE

Python

Tableau APIs

Job description

Halvik Corp delivers a wide range of services to 13 executive agencies and 15 independent agencies. Halvik is a highly successful WOB business with more than 50 prime contracts and 500+ professionals delivering Digital Services, Advanced Analytics, Artificial Intelligence/Machine Learning, Cyber Security and Cutting-Edge Technology across the US Government. Be a part of something special!

Position Overview

Halvik is seeking a Data Architect with significant BI experience to lead the technical design and execution of a large-scale BI migration at the U.S. Department of Transportation. This program is migrating thousands of reports and their underlying data structures from Oracle Data Warehouse / OBIEE into a Databricks platform with Tableau as the reporting layer.

The Data Architect will design the Databricks gold-layer data models that serve Tableau, architect the Tableau data source (TDS) layer, define and maintain the automated and manual conversion processes that transform legacy report definitions into Tableau workbooks, and resolve the complex structural differences between OBIEE and Tableau (multi-fact decomposition, join strategies, naming authority). A significant part of the conversion pipeline leverages AI/LLM-generated outputs, and the Data Architect will maintain and enhance that pipeline to support the conversion goals.

The ideal candidate combines data architecture expertise with substantial hands-on BI experience. The Data Architect must understand how data models are consumed by BI tools, how report logic maps through presentation and logical layers, and how to design data structures that support both automated report generation and ad-hoc analysis at scale.

Core Responsibilities

• Maintain the Databricks gold-layer data models that serve as the foundation for all Tableau data sources and reports. Ensure models support both automated report generation and ad-hoc analytical use.
• Architect the Tableau data source (TDS) layer, defining how gold-layer tables are surfaced as published data sources, including single-fact and multi-fact structures, join strategies, extract vs. live connection decisions, and performance optimization patterns.
• Own the repeatable report conversion process - covering both the LLM-assisted path (AI-generated report scaffolds reviewed and refined by BI developers) and the manual path (structured step-by-step procedures). Define quality gates and validation criteria for each path.
• Resolve the structural differences between OBIEE and Tableau architectures.
• Collaborate with Data Engineers on ETL pipeline design, ensuring transformation logic produces gold-layer structures optimized for Tableau consumption. Provide architectural direction on Unity Catalog governance, metadata management, and access control.
• Design validation frameworks - including source-to-target reconciliation queries, fidelity checks, and automated comparison pipelines - that confirm migrated reports faithfully reproduce legacy business logic.
• Maintain and improve the AI/LLM-assisted conversion pipeline.
• Analyze legacy OBIEE RPD metadata (physical, logical, and presentation layers) to map source-to-target data lineage, identify technical debt, and inform migration sequencing and rationalization decisions.
• Provide technical mentorship to Junior BI Developers. Serve as the escalation point for complex data modeling, join logic, and fidelity questions.
• Contribute to migration playbooks, architectural documentation, knowledge transfer materials, and stakeholder presentations. Participate in Agile ceremonies and sprint-level planning.

Minimum Requirements

• 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, and 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.

Preferred Expertise

• 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.

Halvik offers a competitive full benefits package including:

• Company-supported medical, dental, vision, life, STD, and LTD insurance
• Benefits include 11 federal holidays and PTO
• Eligible employees may receive performance-based incentives in recognition of individual and/or team achievements.
• 401(k) with company matching
• Flexible Spending Accounts for commuter, medical, and dependent care expenses
• Tuition Assistance
• Charitable Contribution matching

Halvik Corp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Halvik'spay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.