Database Specialist - Tetra Tech

Discover your full potential. At Tetra Tech, we are collaborating with industry-leading experts for a sustainable future for our world. We combine consulting and engineering with advanced analytics and technology to solve the world’s most complex challenges. Our innovation hubs across the globe will enable you to share ideas and best practices while growing your professional network. Wherever you are in your career journey, you will benefit from working with world-class engineers, scientists, and technical specialists.

Apply today and join the company that is Leading with Science®.

The Database Specialist will support data management, reporting, and quality assurance for research and evaluation projects serving commercial, state, and federal clients. This role designs, maintains, documents, and improves project databases used for survey research, program evaluation, performance measurement, and compliance reporting. Working on interdisciplinary teams, the Database Specialist helps ensure data is secure, organized, accessible, and accurate. Proficiency in Python and SQL is required; strong data governance skills, including validation, analysis, and reporting, are preferred. This position will be based in Madison, Wisconsin. Opportunity for advancement. Salary will be commensurate with experience.

Your Role

• 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

Preferred Qualifications

• Bachelor’s degree
• Relational database design, implementation, and maintenance experience
• Responsible data stewardship
• Technical problem solving
• Client service mindset
• Continuous improvement and process efficiency