Sr Data Architect

Halvik • Washington, DC

20h

About The Position

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.

Requirements

• 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

Nice To Haves

• 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
• Azure Solutions Architect or similar

Responsibilities

• Serving as the primary data solutions architect for a data services/visualization platform
• Leading the design of data lakes, data warehouses, and visualization services
• Working 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
• Assisting 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
• Providing technical guidance and mentorship to other members of the technical team

Benefits

• Company-supported medical, dental, vision, life, STD, and LTD insurance
• Benefits include 11 federal holidays and PTO
• Eligible employees may receive performance-based incentives in recognition of 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 51-100 employees