Enterprise Data Architect – Hybrid & Scalable

Vanasse Hangen Brustlin Inc.; Watertown (MA); Hybrid; USD 120,000 - 175,000; Full time

Benefits offered by this job

Hybrid work model

Comprehensive benefits package

Job summary

Vanasse Hangen Brustlin Inc. seeks a Database Architect to design and lead enterprise data architecture solutions that support the markets we serve, including Transportation, Energy, State/Local Government and Real Estate.

You will help shape scalable, secure, and high-performing database environments enabling data-driven decision-making across the organization. Hybrid work model and strong benefits are available.

Qualifications

• 5+ years of directly-related professional database management experience.
• Bachelor's degree in Computer Science, Information Systems, or a related technical field.
• Strong experience with Microsoft SQL Server and relational database technologies including Cloud Platform (Microsoft Azure or AWS), SSIS packages, SSRS, SSAS, and PowerBI.
• Experience with Restful API database Integration.
• Experience or knowledge of .net core API's preferred.
• Strong technical expertise with relational databases, SQL development, database administration, and enterprise data modeling.
• Experience working with transportation crash data, roadway safety systems, or safety management and analytics platforms preferred.

Responsibilities

• 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 business applications.
• Collaborate with cross-functional teams, stakeholders, vendors, and leadership to support enterprise data initiatives and system integration efforts.
• Design and support databases and data architectures for transportation safety and crash data management systems, 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 into existing enterprise systems.
• Provide guidance on database administration, indexing strategies, query optimization, backup/recovery planning, and security best practices.
• Review and evaluate business requirements related to data usage, reporting, analytics, and system performance.
• Create and maintain technical documentation, architecture diagrams, and database design specifications.
• Partner with development teams to ensure alignment between application architecture and database architecture.
• Participate in ongoing professional development and contribute to continuous improvement initiatives within the Technology Enablement team.

Skills

Database architecture

Data modeling

Data governance

Performance tuning

Query optimization

Data integration

ETL processes

Data warehousing concepts

Cloud platforms (Azure or AWS)

API integration (RESTful)

Education

Bachelor's degree in Computer Science, Information Systems, or a related technical field

Tools

Microsoft SQL Server

Azure

AWS

SSIS

SSRS

SSAS

Power BI

RESTful API integration

.NET Core APIs

Job description

Vanasse Hangen Brustlin Inc. seeks a Database Architect to design and lead enterprise data architecture solutions that support the markets we serve, including Transportation, Energy, State/Local Government and Real Estate.

You will help shape scalable, secure, and high-performing database environments enabling data-driven decision-making across the organization. Hybrid work model and strong benefits are available.