Database Specialist

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

Benefits offered by this job

Competitive salary package

Career development opportunities

Hybrid office/remote work

Health, dental, vision insurance

Job summary

Tetra Tech, Inc. seeks a Database Specialist in Madison, Wisconsin, to design and maintain project databases, ensure data quality, and support reporting for diverse clients.

Strong Python and SQL skills are required, with emphasis on data governance and secure data practices. Join interdisciplinary teams and help optimize data workflows, validation, and extraction processes while contributing to accurate, compliant reporting across commercial, state, and federal projects.

Qualifications

• Bachelor's degree in a relevant field.
• Experience designing relational databases for projects.
• Proficiency in Python and SQL.
• Strong data governance, validation, and reporting skills.
• Excellent documentation and communication.

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.
• Review and improve data workflows for accuracy and efficiency.
• Conduct data intake, cleaning, validation, transformation, and integration.

Skills

Relational DB design

Python

SQL

Data governance

Data quality

Client communication

Data security

Education

Bachelor's degree

Job description

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

• 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 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 www.tetratech.com 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.

Additional Information

• Organization: 207 GSD