Data Architect

Job Description

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! Halvik is seeking an experienced Tech Lead - Principal Solutions Architect.  This position will be responsible for serving as the primary data warehouse architect for a data services/visualization platform for a federal agency. The architect will lead the design of data lakes, data warehouses, and visualization services for that data. The architect will work with data/cloud engineers to design data pipelines to ingest, clean and transform both batch and streaming data.Specific roles inside an AWS environment include:Leading the design of data warehouses, data lakes and datamarts including both the logical and physical models.Assist in soliciting and assessing requirements for the data warehouses/data lakes among data consumers/analysts, visualization specialists, programmers, and engineers.Optimizing the design and tuning the performance of data warehouses for efficient loading and high performance for data queriesFacilitating change control processes for the data model within the repositories including integrating with CI/CD pipelinesDesigning and implementing a metadata repository to be used for data discovery/catalog services across the enterprise.Required Skills:Data Warehousing/Data Architect Experience (10+ years)Architecting a data lake and/or data warehouse model including defining the use of standard conventions using cloud components (AWS S3, Databricks, Palantir Foundry, AWS Redshift, AWS Aurora Postgres)Creating logical and physical data models for data repositories containing a number of heterogenous sourcesOptimizing data warehouses for high performance for varying types of use cases (high frequency loads, large loads, high frequency queries)Implementing various archiving and partitioning approaches to optimize data ingestion, data storage costs and meet data retention requirementsDesigning strategies for handling slowly changing dimensionsPreferred Skills:Ability to communicate effectively with senior leadership including translating complex technical concepts into specific and understandable technology recommendationsExperience working in a Palantir Foundry environment including use of Code Repositories, Ontology, and visualization tools like Contour, Quiver and WorkshopUse of integrating visualization tools, such as Tableau, Qlik, Socrata, with data lakes and data warehouses (2+ years)Data Cataloging Experience (2+ years)Architecting a data cataloging strategy for a myriad of data sources pulled into a data lake and warehouseImplementing a data catalogue on a cloud platformSystem Architecture Experience (5+ years)Architecting and manager the security roles for a data lake and pipelinesUse of Infrastructure as Code (IaC) tools to deploy pipelines and componentsTechnical Documentation (5+ years)Developing and delivering quality technical documentation deliverables on designed solutionsDefining, guiding and contributing to complete documentation for development efforts  Clearance: SecretLocation: Northern Virginia, This is a hybrid position that will require ability to attend meetings at Halvik HQ as well as customer location.Degree: Bachelor's degree in Computer Science, Information Systems, Software Engineering, or related fieldYears of Experience: 8+ years  Privacy Policy – Halvik Corp Halvik offers a competitive full benefits package including:Company-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.