Hybrid Enterprise Data Architect for Scalable Solutions

Vanasse Hangen Brustlin, Inc.; Washington (District of Columbia); Ibrido; USD 120.000 - 175.000; Tempo pieno

Descrizione del lavoro

Vanasse Hangen Brustlin Inc. is seeking a Database Architect to lead enterprise data architecture efforts, shaping scalable database environments across markets such as Transportation, Energy, Government and Real Estate.

You will design data models, governance, and integration strategies to enable data-driven decision-making and innovative digital solutions. The role requires deep SQL Server expertise, cloud experience (Azure or AWS), ETL and data warehousing skills, and collaboration with

Competenze

• 5+ years of directly-related professional database management experience.
• Strong experience with Microsoft SQL Server and cloud platforms (Azure or AWS).
• Experience with Restful API database integration.
• Experience with data governance and enterprise data modeling.
• Familiarity with crash data, transportation safety analytics, or related domains is a plus.
• Applicants must be legally authorized to work in the U.S. without sponsorship.

Mansioni

• Design, develop, and maintain enterprise database architectures, data models, and data integration strategies.
• Lead the planning and implementation of scalable, secure, and high-performing database solutions across multiple applications.
• Collaborate with cross-functional teams, stakeholders, vendors, and leadership to support enterprise data initiatives.
• Design and support databases for transportation safety data management, including data integration, reporting, analytics, and data quality initiatives.
• Develop and maintain conceptual, logical, and physical data models aligned with business and technical requirements.
• Define database standards, governance practices, naming conventions, and data quality processes.
• Analyze current database environments and recommend improvements for performance, scalability, reliability, and maintainability.
• Support data warehousing, ETL processes, and integration of new data sources.
• Provide guidance on database administration, indexing strategies, query optimization, backup/recovery planning, and security best practices.
• Create and maintain technical documentation, architecture diagrams, and database design specifications.
• Partner with development teams to align application and database architectures.
• Participate in ongoing professional development within the Technology Enablement team.

Conoscenze

Database architecture

Data modeling

SQL Server

Azure/AWS

ETL/Data warehousing

Data governance

API integration

Power BI

Security & backup

Formazione

Bachelor's degree in CS/IS

Strumenti

Microsoft SQL Server

SSIS

SSRS

SSAS

Power BI

Azure

AWS

.NET Core

Descrizione del lavoro

Vanasse Hangen Brustlin Inc. is seeking a Database Architect to lead enterprise data architecture efforts, shaping scalable database environments across markets such as Transportation, Energy, Government and Real Estate.

You will design data models, governance, and integration strategies to enable data-driven decision-making and innovative digital solutions. The role requires deep SQL Server expertise, cloud experience (Azure or AWS), ETL and data warehousing skills, and collaboration with