Sr 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 Responsibilities • This position will be responsible for serving as the primary data solutions architect for a data services/visualization platform for FHWA Application Environment. The architect will 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. • 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 queries. • Facilitating change control processes for the data model within the repositories including integrating with CI/CD pipelines. • Designing and implementing 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 PowerBI Experience working with Azure AD and/or Okta authentication, MFA policies, and role-based data access control. • Certification: Azure Solutions Architect or similar 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 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.