SQL Development Leader - Integrations

Why Siepe

Siepe is a fast-growing technology company helping investment managers turn complexity into clarity. We build software and data solutions that give hedge funds and financial services firms the real-time insights and operational visibility they need to make better decisions faster.

Our clients manage billions in assets and rely on Siepe for critical technology, data, and operational workflows. We serve sophisticated global clients and move quickly, challenge how things are done, and give people meaningful ownership and the opportunity to make a real impact.

Impactful work on problems that matter. Direct visibility into how your contributions affect clients and real input on decisions. Competitive pay, great benefits, and opportunities to learn and take on more as Siepe grows. Teammates who are sharp and collaborative, whether they come from the industry or are charting a new path entirely. You will get to be part of a culture that blends fun with purpose!

We lead with trust, transparency, and a team-first mindset. We communicate early, follow through on our commitments, and take ownership of outcomes - not just execute. When there’s a problem, we bring ideas and solutions, ask the next question, and keep things moving. We stay curious, challenge ideas, and prioritize what’s best for our clients and Siepe. We move with urgency, learn as we go, and work together to leave things better than we found them.

Who We Are Looking For

We’re looking for a hands‑on SQL development professional to own the technical delivery of Siepe’s integration layer between Solvas, our Middle Office systems, our client‑facing Portal, and third‑party systems. This role is accountable for building and operating reliable data pipelines that ingest, normalize, and version data in support of downstream workflows, reporting, and the client experience. Based on the selected candidate’s experience and strengths, the role may be structured as either a Lead SQL Development - an individual contributor and subject matter expert - or Manager, SQL Development, leading a small team while remaining hands‑on.

This role is ideal for a delivery‑oriented technical expert or people leader with deep T‑SQL expertise and experience working across transactional data and OLTP systems, data warehouses, data lakes, and ETL/ELT pipelines who can drive disciplined estimation, execution, and operational maturity for mission‑critical integrations.

What You’ll Be Doing

• Provide technical leadership and mentorship to engineers responsible for data integrations and warehouse‑quality data pipelines. This may include directly managing a small team.

• 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.

• Design and expose data access APIs and platform endpoints (Databricks, Snowflake, REST) enabling clients' internal applications to consume their Siepe data securely and at scale.

• 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.

• Partner with our Database Administration team to 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 operational readiness: monitoring/alerting, runbooks, incident response, and continuous…