Database Architect
About the role
- 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 and Attributes: Knowledge of database architecture principles, data modeling methodologies, and data governance best practices
- Experience with performance tuning, query optimization, indexing, and database troubleshooting
- Familiarity with ETL processes, data warehousing concepts, and enterprise system integration
- Understanding of database security, backup/recovery strategies, and high-availability solutions
- Excellent analytical, problem-solving, and organizational skills
- Strong verbal, written, and interpersonal communication abilities
- Ability to manage multiple priorities independently in a collaborative team environment
- Self-motivated with strong attention to detail and a commitment to continuous improvement
- Proficiency with Microsoft Office Suite
- 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 PowerBIExperience 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
- Familiarity with crash data integration, data governance, reporting, and performance measures related to transportation safety initiatives is a plus
- Experience supporting enterprise applications and collaborating with software engineering teams
- Familiarity with cloud-based data platforms and modern data architecture practices is a plus
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
