Data Architect

About the Role

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, architect the Tableau data source (TDS) layer, define and maintain conversion processes, and resolve structural differences between OBIEE and Tableau. A significant part of the conversion pipeline leverages AI/LLM-generated outputs, and the Data Architect will maintain and enhance that pipeline.

Responsibilities

• Maintain the Databricks gold-layer data models that serve as the foundation for all Tableau data sources and reports, ensuring they 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 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, to 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 and 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.

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 hands-on experience 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, including writing Spark SQL and designing 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 communication of architectural decisions and trade-offs to both technical and non-technical stakeholders.
• Experience working in Agile delivery environments with cross-functional teams.

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

Benefits

• Company-supported medical, dental, vision, life, STD, and LTD insurance.
• 11 federal holidays and PTO.
• Performance-based incentives for 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.