Lead SQL Developer

We don’t just serve the industry – we help modernize it!Siepe is profitable, privately held, and growing fast. This role is accountable for building and operating reliable data pipelines that ingest, normalize, and version data in support of downstream workflows, reporting, and client experience.This role is ideal for a delivery-oriented leader with deep T-SQL expertise and strong ETL fundamentals who can drive disciplined estimation, execution, and operational maturity for mission-critical integrations.What You’ll Be DoingLead and mentor engineers responsible for data integrations and warehouse-quality data pipelines.Own end-to-end technical delivery for Integrations work, from scoping and estimation through production support.Design and evolve ETL/ELT pipelines for loading, normalizing, and versioning data across Solvas, Middle Office, and the Portal.Establish standards for data consistency, concurrency control, and integrity (transactions, isolation levels, idempotency, reconciliation).Define and enforce data quality controls: validation, audit trails, lineage, and exception handling.Drive performance tuning across SQL Server objects (stored procedures, functions, indexing strategies, partitioning) used by pipelines and consumers.Partner with product, operations, and client-facing teams to translate integration requirements into executable delivery plans and SLAs.Build ...