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
- Clear documentation and communication
Starting Salary$75,000-$100,000 depending on level of education, qualifications, and experience
Line Management ResponsibilityPhysical Demands and Work Environment- Hybrid office environment (3 days in-office/2 days remote)
- Constantly operates a computer and other office productivity machinery, such as a computer monitor, computer mouse, calculator, and computer printer
- Able to communicate information and ideas so others will understand. Must be able to exchange accurate information in these situations
What We Can Offer You:- Competitive Salary and Benefits: Competitive compensation packages that recognize the value and experience you bring, complemented by a comprehensive benefits package including health, dental, and vision insurance, retirement plans, and paid time off
- Advanced Career Development Opportunities: Career development opportunities that align with your aspirations and expertise, including leadership training, advanced certifications, and future opportunities to lead projects
- Resource Availability: Take advantage of the extensive resources and tools available in our organization to support your project work, professional development, and career advancement
- Sustained Excellence and Stable Growth: Tetra Tech has ranked No. 1 in Water in ENR's "Top 500 Design Firms" for the 20th year in a row. In recent years, our company has continued to expand its reach, diversify its project portfolio, and increase its workforce, demonstrating our stability and the trust our clients place in us
- Hybrid office/remote work: Hybrid office/remote work option that allows our employees to balance quality work and their personal lives
