Data Architect (Hybrid): Build & Govern Databases

Tetra Tech; Madison (WI); Hybrid; USD 75,000 - 100,000; Full time

Benefits offered by this job

Health insurance

Retirement plans

Paid time off

Hybrid work environment

Career development opportunities

Job summary

Tetra Tech in Madison, Wisconsin is seeking a Database Specialist to design, build, and maintain project databases supporting survey research, program evaluation, and reporting. You will implement data security policies and collaborate with interdisciplinary teams to ensure data reliability and accessibility.

Proficiency in Python and SQL is required; strong governance, validation, and reporting skills are preferred.

Qualifications

• Proficiency in Python and SQL is required; strong data governance skills, including validation, analysis, and reporting, are preferred.
• Design, build, and maintain relational databases tailored to project needs.
• Collaborate with interdisciplinary team members and provide technical support to align database information with project needs.

Responsibilities

• Design, build, and maintain relational databases tailored to project needs
• Implement policies for data storage and security
• Collaborate with interdisciplinary team members and provide technical support to align database information with project needs
• Review and improve existing data workflows and processes to enhance accuracy and operational efficiency
• Conduct data intake, cleaning, validation, transformation, and integration processes from multiple sources
• Write, test, optimize, and document SQL queries, stored procedures, scripts, and data extracts to support analysis and reporting
• Implement data validation to identify missing, inconsistent, duplicate, or out-of-range data and coordinate resolution with project teams
• Support secure data transfer, access control, backup, retention, and versioning practices consistent with project requirements and internal data policies
• Prepare recurring and ad hoc datasets, reports, extracts, and data summaries
• Troubleshoot database issues, improve workflow efficiency, and recommend process improvements that strengthen data reliability and reduce manual effort
• Develop backend processes for independent data filtering, aggregation, and reporting by team members

Skills

Python

SQL

Data governance

Client service mindset

Continuous improvement

Job description

Tetra Tech in Madison, Wisconsin is seeking a Database Specialist to design, build, and maintain project databases supporting survey research, program evaluation, and reporting. You will implement data security policies and collaborate with interdisciplinary teams to ensure data reliability and accessibility.

Proficiency in Python and SQL is required; strong governance, validation, and reporting skills are preferred.