Position: SQL Developer, Remote Part-time, East Coast daytime meeting times requiredLevel: SeniorLocation: Remote, Part-time, East Coast United States timezoneCompensation: Hourly rate based on experienceReports to: CIO
The RoleSherlockTalent is hiring a SQL Developer to build an internal data intelligence platform — a database application that turns procurement documents into structured, queryable competitive intelligence. You'll design, build, and evolve the database layer in a purely Microsoft / Azure Cloud environment. You'll own the schema: designing new entities, refactoring legacy structures, and building the data foundation that powers AI-driven document ingestion and analytics.This is a hands-on build role. You'll work from detailed design references and real-world document cases, translating business rules directly into clean, enforceable database structure.
What You’ll Do- Design and implement relational schemas in Azure SQL — new tables, new fields, and controlled extensions to existing reference data
- Refactor and consolidate legacy structures: merging duplicate entities, deprecating obsolete fields, and migrating data without breaking downstream dependencies
- Build normalized designs using lookup/reference tables, junction tables, and multi-level parent-child hierarchies with proper foreign keys and cascade rules
- Design audit and import-logging structures that capture full traceability for every data load — status states, error detail, user attribution, and raw payloads for reprocessing
- Support an AI-assisted document extraction pipeline: schemas that store raw AI output, staging/validation states, and alias-mapping structures for fuzzy entity matching
- Integrate with Azure Blob Storage — modeling document references and validated output artifacts at the schema level
- Implement data-quality logic at the database layer: computed aggregates, statistical fields (averages, standard deviation), and automated outlier flagging
- Get data typing right: correct numeric precision for financial values, proper handling of ranges, flags, and timestamps
- Model role-based access (edit vs. read-only) at the data level
Required Skills
- Strong T-SQL: DDL, constraints, foreign keys, cascade behavior, indexing
- Proven Azure SQL Database experience — this is a 100% Microsoft/Azure environment
- Schema design and refactoring in live systems: you've consolidated entities, deprecated fields, and versioned schema changes cleanly
- Deep fluency in normalization patterns: lookup tables, junction tables, one-to-many and many-to-many relationships
- Experience designing audit trails and import/ETL logging structures
- Precision with data types — especially DECIMAL handling for pricing/financial data and the pitfalls of integer truncation
- Ability to read a technical design reference and implement it faithfully, flagging conflicts and gaps rather than improvising silently
- Preferred Skills
- Experience supporting AI/LLM extraction pipelines (storing raw JSON responses, validation workflows, human-in-the-loop review states)
- Azure Blob Storage integration patterns
- Data validation and staging workflows (pending ? review ? complete lifecycles)
- Statistical computation in SQL (aggregates, deviation, outlier detection)
- Exposure to procurement, bidding, or pricing-data domains
- Environment
- Microsoft stack only: Azure SQL Database, Azure Blob Storage, Azure Cloud services
- Remote, part-time contract with flexible hours, EAST COAST REGULAR OFFICE HOURS Meeting time required
- Direct collaboration with the platform development team; design references provided
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
