SQL & API Developer at Weston & Sampson in Reading, MA | USD90,000-110,000 | Kablio

Role

Description

deltek vantagepoint

sql development

ssrs reporting

api integration

data management

issue resolution

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

Articles

Contact

Join Our Team

GIS Services

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

Articles

Contact

Join Our Team

GIS Services