Sr Data Architect

Join to apply for the

Sr Data Architect

role at

Halvik .

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.

Role and Responsibilities

Serve as the primary data solutions architect for a data services / visualization platform for FHWA Application Environment. Lead the design of data lakes, data warehouses, and visualization services and work with data / cloud engineers to design data pipelines to ingest, clean and transform both batch and streaming data.

Lead 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 / lakes among data consumers / analysts, visualization specialists, programmers, and engineers.

Optimize the design and tune the performance of data warehouses for efficient loading and high performance for data queries.

Facilitate change control processes for the data model within the repositories including integration with CI / CD pipelines.

Design and implement a metadata repository to be used for data discovery / catalog services across the enterprise.

Provide technical guidance and mentorship to other members of the technical team.

Required Skills

10+ years of experience architecting enterprise data systems or large‑scale analytical platforms.

Expertise in Azure Synapse, Data Factory, Databricks, and SQL Server (on‑prem and managed instances).

Proficiency in Python, PySpark, and SQL, with experience building ETL / ELT processes and automation frameworks.

Strong understanding of CI / CD, GitHub, Azure DevOps, and integration with Power BI datasets.

Demonstrated experience in data governance, lineage, and metadata management.

Ability to engage senior stakeholders, translate requirements, and drive modernization strategy.

Preferred Skills

Experience with federal data compliance standards (e.g., Evidence Act, Section 508, data retention, and auditability).

Experience designing datamarts for use by BI tools like Tableau and Power BI.

Experience working with Azure AD and / or Okta authentication, MFA policies, and role‑based data access control.

Certification : Azure Solutions Architect or similar.

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.

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

#J-18808-Ljbffr