TRC is seeking highly motivated and diverse Data Science Interns for our Summer 2027 intern program. This is a paid full-time position. Anticipated duration will be from June through August 2027 (flexible). The successful candidate will work under the supervision of Project Managers and Team Leaders and partner with engineers, scientists, and technologists.
Compensation
USD $20.00 - USD $28.00 /Hr.
Responsibilities
Assist with improving process efficiency, automating data extraction, reporting and analysis of environmental data
Conduct research
Work on client software planning and implementation projects
Provide support with an interest in learning and education
Support the preparation of reports, plans and specifications for client
Requirements
Junior, senior, or master's student pursuing PhD, Masters, Bachelor or Associate Degree in Data Analytics, Computer Science or similar or any related Science field
Experienced Data Platform Engineer to support the existing RepSaS data landscape, focusing on legacy support, operational stability, troubleshooting, and controlled retirement of existing databases and data solutions using Microsoft SQL Server and BI.
Responsibilities
Analyze and resolve production incidents, technical issues, and data quality problems within existing RepSaS solutions
Troubleshoot and maintain T-SQL code, Stored Procedures, Views, Functions, SQL Agent Jobs, and ETL pipelines
Analyze and optimize SQL queries, database objects, execution plans, indexes, loading processes, and overall database performance
Maintain, stabilize, and selectively refactor long-established database and reporting logic
Monitor production environments, perform root-cause analysis, and document bug fixes and workarounds
Provide production support for mission-critical database environments supporting the Case Management Modernization (CMM) Program for the Administrative Office of the US Courts (AOUSC).
Compensation
The likely salary range for this position is $116,450 - $157,550.
Responsibilities
Provides production support for mission-critical database environments, including shift-based coverage and on-call support
Monitors database performance, responds to incidents, troubleshoots production issues
Performs root-cause analysis for production defects
Works within an Agile solution development environment
Develops operating standards and best practices for performance, security, scalability, and maintainability
Requirements
Bachelor’s degree in computer science, computer programming, computer engineering, or relevant computer-based major
Nice to have: Databricks Certified Data Professional
Nice to have: AWS Certified Database – Specialty
Nice to have: AWS Certified Solutions Architect - Associate
Nice to have: AWS Certified Solutions Architect - Professional
Support HVAC field engineers and technicians with a focus on IT-related troubleshooting. Provide level 2 technical support via phone, email and chat technology on Johnson Controls Direct Digital Controls and Building Automation Systems (BAS) problems and applications.
Compensation
HIRING SALARY RANGE: $85,200-118k(Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, internal equity, and alignment with market data.)
Responsibilities
Troubleshoot and resolve escalated server, network, control system problems and applications
Research, replicate, determine root cause and test solutions to field and customer reported problems
Create and document product application and problem solution articles and videos in a support Knowledge Base
Document accurate case records of customer issues, status progress and problem resolutions utilizing Salesforce CRM
Manage the action plan of cross functional teams to resolve escalated customer or systemic product issues
The Applications Engineer designs, develops, and supports the in-house software, system integrations, reports, and automated workflows that connect the company's core business applications.
Responsibilities
Design, develop, test, and maintain in-house applications, scripts, and tools that support field and office operations
Write clean, documented, and maintainable code following IT development standards, including version control and code review
Build, maintain, and troubleshoot system integrations using Boomi, APIs, data staging, and SFTP file transfers
Support data integration, data export, and data import for business systems
Develop and support Boomi-integrated web applications
Manage and maintain established data-processing reporting applications for the Department of Homeland Security (DHS).
Compensation
Target Salary: $ 120,000.00 - $ 145,000.00 /yr.
Responsibilities
Process data received from external providers, converting various file formats, troubleshooting data issues, and importing information into SQL Server
Analyze incoming CSV, Excel, HTML, and other structured or semi-structured data files to identify fields, data types, relationships, and quality issues
Convert and standardize source files into approved CSV formats for database imports
Create and modify SQL Server tables using approved database designs
Modify and maintain existing C# Windows Services using .NET Framework 4.8 to automate data-loading processes
Requirements
Nice to have: SQL Server bulk-loading techniques
Nice to have: Legacy application maintenance and support
Nice to have: Experience working in restricted Federal Government environments
Design, develop, integrate, and support REST APIs and web services using .NET technologies, Power Platform, and Microsoft Azure platforms.
Responsibilities
Design, develop, and deploy scalable business applications using .NET technologies, web services, Power Platform, and third-party components across on-premises and Microsoft Azure platforms.
Integrate and support REST APIs and web services that align with the organization’s application and digital strategies.
Collaborate with business stakeholders and technology team members to deliver efficient scalable applications based on agile methodologies.
Participate in database and technical design of new data applications.
Create and manage project documentation using Microsoft Office 365, Visio, and other tools.
Requirements
Bachelor’s degree in Computer Science, Information Systems, or related field
Senior Database Administrator responsible for production support of mission‑critical database environments for the Case Management Modernization Program.
Compensation
The likely salary range for this position is $116,450 - $157,550.
Responsibilities
Provides production support for mission‑critical database environments, including shift‑based coverage and on‑call support
Monitors database performance, responds to incidents, troubleshoots production issues, and coordinates with development and operations teams to restore service quickly
Performs root‑cause analysis for production defects and contributes to long‑term stability improvements
Works within an Agile solution development environment with daily scrums, biweekly sprint planning and quarterly Program Increment planning
Develops operating standards and best practices, including performance, security, scalability, and maintainability
Requirements
Bachelor’s degree in computer science, computer programming, computer engineering, or relevant computer-based major
Nice to have: Bachelor’s degree in computer science, computer programming, computer engineering, or relevant computer-based major & 7+ years of experience in server database maintenance and database analysis
Nice to have: Databricks Certified Data Professional
Nice to have: AWS Certified Database – Specialty
Nice to have: AWS Certified Solutions Architect – Associate and/or Professional