Database Specialist

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. 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 Relational database design, implementation, and maintenance experience Technical problem solving Client service mindset Continuous improvement and process efficiency Clear documentation and communication $75,000-$100,000 depending on level of education, qualifications, and experience Line Management Responsibility None Physical 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 About Tetra Tech: Tetra Tech combines the resources of a global, multibillion-dollar company with local, client-focused delivery in more than 470 locations around the world. Our reputation rests on the technical expertise and dedication of our employees—22,000 associates working together to provide smart, scalable solutions for challenging projects. We are proud to be home to leading technical experts in water, environment, infrastructure, resource management, energy, and international development. Tetra Tech is proud to be an Equal Opportunity Employer. Diversity, inclusion, and equity are among Tetra Tech’s core values. Throughout our history, the company has prioritized equitable inclusion of all people. All qualified candidates will be considered without regard to race, color, religion, national origin, military or veteran status, gender, age, disabilities, sexual orientation, gender identity, pregnancy and pregnancy-related conditions, genetic information and any other characteristics protected by the law. We invite resumes from all interested parties. Please visit our website at to see the array of diverse services and exciting projects we are currently working on. Tetra Tech is a VEVRAA federal contractor and we request priority referral of veterans for available positions. We thank all applicants for their interest, however, only those candidates selected for interviews will be contacted. #J-18808-Ljbffr