Manage and optimize data within Deltek Vantagepoint ensuring data integrity and quality across all modules.
Create and maintain technical documentation for ERP-related SQL code, API integrations.
Troubleshoot and resolve data-related issues within ERP systems, working closely with business users.
Write complex SQL queries, and stored procedures to support ERP modules.
Build SSRS reports that meet business requirements and integrate them into Deltek Vantagepoint.
Collaborate with the ERP Administration team, and business users to understand requirements and translate them into SQL solutions.
Monitor and improve ERP workflows ensuring they meet business requirements.
Develop and maintain API connections to integrate Deltek Vantagepoint with other business applications.
Requirements
sql server
sql developer
3+ years
bachelor's
erp
schema design
3+ Years of experience as a SQL Developer with a focus on SQL Server databases.
Bachelor's degree in computer science, Information Technology, or a related field. Equivalent work experience will also be considered
Experience with ERP data models, tables and Schema Design.
Benefits
Information not given or found
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
$135M in Revenue
Annual Revenue
The firm generates substantial annual revenue as a privately held company, now fully employee-owned through an ESOP.
125 Years
Company Milestone
In 2024, the company celebrated its 125th anniversary, marking over a century of innovation in wastewater treatment and environmental services.
Founded in 1899 by Robert Spurr Weston, the firm pioneered U.S. wastewater treatment and grew with George Sampson to become a water-treatment innovator.
From a one-person consultancy in Boston, it expanded across the East Coast into a multi-practice engineering and environmental services firm.
Today it delivers interdisciplinary design, engineering, and environmental services for public and private sectors, tackling projects from parks to water treatment plants.
Typical engagements include large urban park renewals, flood mitigation studies, PFAS removal at treatment facilities, and structural engineering for civic plazas.
Sector strengths include infrastructure systems and water resource projects, supported by environmental permitting, geotechnical, landscape architecture, and construction management.
Unusual facts: it continues to build on century-old innovations in wastewater treatment while evolving into climate resiliency and community revitalization.
Culture + Values
Over 100 Years
Years of Tradition
The firm has a proud history and deep roots in its community, with over a century of experience.
Interdisciplinary collaboration across engineering, environmental, planning and landscape teams
Commitment to innovation and reliability on every project
Emphasis on meaningful, community‑impacting work (‘improving the communities where you live, work, and play’)
Fun workplace culture that values growth and professional development
Environment + Sustainability
1,000+ energy audits
Conducted energy audits
The company has conducted over 1,000 energy audits to optimize energy efficiency.
2050 net-zero target
Municipal climate plan
Municipalities like Andover are aiming for net-zero by 2050 through tailored plans.
Every 50 miles
EV charging stations
installed ultra-fast EV charging stations every 50 miles as part of MassDOT's NEVI initiative.
$190K+ grant
Green infrastructure project
Received a significant grant for a green infrastructure project in Rhode Island.
Provides energy & sustainability consulting including GHG inventories, climate action planning, renewable energy feasibility and audits.
Supports renewable energy projects: solar, PV, geothermal, biomass, wind; plus EV charging infrastructure.
Developed/led municipal Climate Action & Sustainability Plans aligned to net-zero targets.
Delivered zero-net-energy training programs for Salem and Beverly to support building retrofit targets.
Inclusion & Diversity
No DEI strategy or gender statistics publicly available