Job Title: Data Developer
Duration: 3 Months
Location: Boston, MA (Hybrid)
A leading organization is developing an in-house SQL Server-based operational data store to centralize and enhance the analysis of public procurement data. The Performance Analytics and Reporting Information System (PARIS) will streamline data management, offering valuable insights into vendor and buyer activities within statewide contracts.
The goal of PARIS is to integrate multiple databases and systems into a single, centralized repository, enabling comprehensive data analysis. To support this initiative, we are seeking an experienced Data Developer to assist in launching the PARIS SQL database and integrating key procurement systems.
The ideal candidate will have expertise in MS SQL database design, data modeling, schema development, and unit testing for system integrations. This role involves optimizing data retrieval, ensuring data consistency, and developing standardized data feeds.
Responsibilities:Design and develop SQL tables, views, stored procedures, functions, and triggers to support reporting, analytics, and business logic.
Support ETL processes and automation for integrating internal and external data sources.
Design and implement data pipelines to facilitate seamless data transfer and integration across systems.
Collaborate with data teams to establish data validation rules and quality control measures.
Monitor technical metrics to track progress, assess project success, and drive improvements.
Ensure adherence to data management best practices and organizational policies.
Implement best practices for indexing, partitioning, query optimization, and data standardization.
Translate functional requirements into technical design documentation.
Manage relational database models and schemas to align with business needs.
Document data models, integration processes, and best practices for knowledge sharing.
8+ years of experience in SQL Server database design, administration, and optimization.
Expertise in SQL programming, including writing procedures, functions, and triggers.
Strong skills in SQL querying, reporting, and data extraction, including importing/exporting data (Excel, CSV).
Proficiency in data modeling, ETL processes, and system integration.
Experience designing and managing data pipelines for smooth data flow.
Strong understanding of data validation controls and ensuring consistency across systems.
Familiarity with public sector data systems (preferred).
Experience with Qlik and Microsoft Power BI (preferred).
Strong problem-solving and analytical skills for database performance, system integration, and automation.
Ability to collaborate effectively with cross-functional teams (data management, development, business teams).
Experience with data governance and ensuring compliance with data management standards.
...of leading a team and providing our guests with an exceptional dining experience? Our popular restaurant seeks a skilled executive chef who can create innovative menus and dishes, supervise all food leaving the kitchen, and ensure health and safety requirements are followed...
...Project Manager needs Data Digital Solutions and 7 years' experience Snr Project Manager requires: -Project Management Professional (PMP) certification -At least 7 years of experience in a project-oriented environment required -IT environment strongly preferred. -...
...dnata is hiring Cabin Cleaning Agents at LAX Airport! Pay Rate $25.23/hr ~ Weekly pay, 401K, paid time off, paid training and company... ...0,000 meals. Responsible for cleaning all assigned customer aircraft thoroughly Ensure cleaning supplies readied for each arrival...
...Job Title: Brand Ambassador Location: Atlanta, GA Position Type: Full-time, Non-exempt Salary: $48,000 annual base salary, with... ...Ambassador, you will represent our brand in various capacities, working to engage with potential customers, support our sales efforts...
...Description: We are looking for a highly-analytical certified public accountant (CPA) to join our talented team at AM Advisors. To... ...related issues. Requirements: Bachelor's degree in accounting, finance, or a related field. A minimum of 10 years' proven...