Principal Data Architect

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.Role And ResponsibilitiesThis position will serve as a primary data architect for the Department of Transportation (DOT) Securet Data Commons / Data Analytics and Visualization Environment (SDC/DAVE) platform. The architect will lead the design of data lakes, data warehouses, and visualization services and will work with data and cloud engineers to design pipelines that ingest, clean, and transform both batch and streaming data. The role requires a broad foundation in data architecture with the aptitude and drive to rapidly learn new tools and platforms as the program evolves.Specific Responsibilities IncludeLeading the design of data warehouses, data lakes, and datamarts, including both logical and physical models.Administering and expanding the program's Databricks platform (currently hosted in AWS), including performance tuning, access control, and platform governance.Supporting the onboarding and eventual administration of the Collibra data governance platform.Assisting in soliciting and assessing data requirements from consumers, analysts, visualization specialists, programmers, and engineers.Optimizing data warehouse design and tuning performance for efficient loading and high-throughput queries.Facilitating change control processes for the data model and integrating changes with CI/CD pipelines.Designing and implementing metadata and data catalog strategies to support data discovery across the enterprise.Engaging with emerging AI and analytics tools being evaluated or adopted by the program, quickly developing working knowledge sufficient to inform architecture decisions.Required SkillsMust be able to obtain and maintain Public Trust security clearanceBachelor's degree in Computer Science, Information Systems, or related field, or 6+ years of equivalent experience.Data Warehousing / Data Architecture (10+ years)Designing and architecting data lakes and/or data warehouses using cloud components (AWS S3, Redshift, Aurora PostgreSQL, or equivalent Azure/GCP services)Creating logical and physical data models for repositories containing heterogeneous sourcesOptimizing data warehouses for varying workloads: high-frequency loads, large batch loads, and high-frequency queriesImplementing archiving, partitioning, and retention strategies to manage storage costs and compliance requirementsDesigning strategies for slowly changing dimensions (SCD) and other data lifecycle patternsBig Data / Cloud Platform Experience (2+ years)Hands-on experience with Databricks or a closely comparable distributed compute platform (e.g., Azure Synapse, AWS EMR, Google Dataproc)Practical experience with AWS as the primary cloud environment; familiarity with Azure and ability to extend to additional cloud providersInfrastructure as Code (IaC) using Terraform for deploying and managing data pipeline componentsData Cataloging / Governance (2+ years)Architecting a data cataloging strategy across a diverse set of sources ingested into a data lake and warehouse environmentImplementing a data catalog on a cloud platformFamiliarity with data governance concepts including data lineage, stewardship, and policy enforcementSystem / Security Architecture (5+ years)Architecting and managing security roles, access controls, and RBAC for data lakes and pipelinesDesigning row-level and object-level security models appropriate for enterprise and federal environmentsPreferred SkillsDatabricks advanced features: Unity Catalog, Delta Live Tables (DLT), and Lakeflow/pipeline orchestrationExperience with Collibra or other enterprise data governance platforms (e.g., Alation, Informatica, Ataccama)Familiarity with Palantir Foundry or comparable ontology-driven data platformsExposure to emerging AI/ML tooling, including LLM-based analytics, vector databases, or AI agent frameworks; willingness to rapidly learn new platforms as the program adopts themExperience integrating visualization tools (Tableau, Power BI, Qlik) with data lakes and warehousesExperience with data replication, high availability, and data migration tools and techniquesExperience designing data models for transactional applicationsAbility to communicate effectively with senior leadership, translating complex technical concepts into actionable recommendationsFederal government or DoD project experienceHalvik Offers a Competitive Full Benefits Package IncludingCompany-supported medical, dental, vision, life, STD, and LTD insuranceBenefits include 11 federal holidays and PTOEligible employees may receive performance-based incentives in recognition of individual and/or team achievements.401(k) with company matchingFlexible Spending Accounts for commuter, medical, and dependent care expensesTuition AssistanceCharitable Contribution matchingHalvik 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's pay 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.