Job Title: Enterprise Data Developer – State Services
Location: Boston, MA (Onsite)
Duration: 1 Month (Tentative)
Job Type: Contract
We are seeking an experienced Enterprise Data Developer to support the deployment of a SQL Server-based operational data store designed to centralize and streamline public procurement data analysis. This project, the Performance Analytics and Reporting Information System (PARIS), aims to unify data from multiple procurement systems—enhancing transparency, consistency, and actionable insights into vendor and buyer behavior.
The ideal candidate will play a critical role in designing, developing, and optimizing the database infrastructure while ensuring robust integration and data quality standards. This is a hands-on development role with direct impact on a high-priority statewide analytics initiative.
Design and develop SQL Server tables, views, stored procedures, functions, and triggers to support analytics, reporting, and operational logic
Build and maintain ETL pipelines to integrate data from systems such as VRM, COMMBUYS, and MMARS
Implement scalable and efficient data workflows and pipelines for cross-system integration
Collaborate with stakeholders to define and enforce data validation rules and quality control standards
Monitor and evaluate technical metrics to assess system performance and support continuous improvement
Ensure compliance with data governance frameworks and state IT standards
Improve database efficiency through query optimization, indexing, and partitioning
Convert functional requirements into clear and actionable technical specifications
Maintain and refine data models and schema architecture to align with evolving business needs
Document integration processes, data definitions, and system standards to support long-term maintainability
8+ years of hands-on experience in SQL Server development, optimization, and administration
Strong command of SQL programming, including advanced procedures, triggers, and functions
Experience handling data imports/exports using formats such as Excel (.xlsx) and CSV
Deep knowledge of data modeling, ETL design, and multi-system integration strategies
Understanding of data validation techniques to ensure data consistency and accuracy
Familiarity with government or public sector data systems
Experience with Qlik and Microsoft Power BI is a plus
Strong problem-solving and analytical thinking
Proven ability to work collaboratively with technical and business teams
Solid understanding of data governance and compliance practices
Self-motivated with the ability to manage deliverables in a fast-paced, deadline-driven environment