Senior Manager, SQL Development - MOS and CA

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, move quickly, challenge how things are done, and give people meaningful ownership and the opportunity to make a real impact.

Why Join Us

• 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.
• A culture that blends fun with purpose.

Our Culture

• We lead with trust, transparency, and a team‑first mindset.
• We communicate early, follow through on commitments, and take ownership of outcomes.
• When problems arise 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.

Role Overview

Siepe is seeking a Senior Manager, SQL Development, who will also be our lead data engineer: a hands‑on owner of the data platform end‑to‑end, not just someone who manages people who own it. The pipelines you’ll be responsible for turn custodian and administrator feeds into the numbers our hedge‑fund clients rely on every day. Correctness, performance, and uptime are essential.

Responsibilities

• Onboard new custodian, administrator, and vendor feeds end‑to‑end: landing, canonical mapping, pipeline wiring, and delivery SLA.
• Write code that eliminates manual work: parameterized reruns and backfills, idempotent loads, shared tooling instead of one‑off scripts.
• Lead root‑cause work on production pipeline issues and close them out with permanent fixes.
• Design, plan, build, and tune set‑based T‑SQL (stored procedures, normalization views, indexing strategy, execution plans) and collaborate with the SQL Development team and DBAs.
• Build a sequenced modernization roadmap with a defensible business case.
• Make build/buy/migrate decisions on orchestration, transformation, and observability.
• Apply strangler‑fig discipline: new capability behind stable contracts, incremental cutover, always‑reversible steps.
• Raise the engineering floor: testing, release standards, schema‑change practice, and a fast change process.
• Establish evidence‑based SLOs for feed timeliness and completeness with telemetry.
• Set technical direction for onshore and offshore engineers through design review, code review, and pairing; grow the bench so knowledge is shared.

Requirements

• 8+ years building and operating production data pipelines, including experience as a lead, staff, principal, or hands‑on manager setting technical direction.
• Expert T‑SQL and deep SQL Server knowledge: set‑based transformation, window functions, merge patterns, safe dynamic SQL, indexing, execution plans, statistics, isolation levels, blocking and deadlock analysis.
• Hands‑on SSIS experience: control flow, data flow, deployment models, parameters, dtexec, and judgment on when to improve versus replace a package.
• Warehouse fundamentals: staging vs. conformed layers, upsert/merge patterns, slowly changing dimensions, surrogate/natural keys, effective dating, auditability.
• Understanding of AI‑first delivery, orchestration, and guardrails; familiarity with LLMs, plugins, and multi‑agent management.
• Data‑engineering and modeling experience on cloud platforms (Snowflake, Databricks, Microsoft Fabric) with a defensible point of view.
• Experience with dbt or an equivalent declarative transformation framework, including testing and documentation.
• Production experience with a workflow orchestrator (Airflow, Dagster, Prefect, Azure Data Factory, etc.) – DAG design, retries with backoff, idempotency, backfills, SLA monitoring, dependency management.
• Knowledge of Data Vault 2.0 or dimensional (Kimball) modeling.
• Proficiency in PowerShell (modules, manifests, Pester, PSScriptAnalyzer) and PowerShell 7 migration.
• AWS experience in a Windows estate: EC2, S3, Secrets Manager, Systems Manager, CloudWatch, infrastructure as code (Terraform, CloudFormation).
• Messaging and event‑driven integration experience: RabbitMQ, Kafka, Azure Service Bus, outbox pattern, idempotent consumers, dead‑letter queues, replay.
• Current authorization to work in the country of employment without the need for visa sponsorship now or in the future.

Benefits

• Competitive compensation with annual performance‑based bonus opportunities.
• Retirement benefits with company contributions (401(k) or pension plans, depending on location).
• Comprehensive health, dental, vision, and life insurance (employee coverage 100 % funded where applicable).
• Flexible Time Off (FTO) because life happens.
• Learning & Development budget to invest in your professional growth.
• Career growth and on‑the‑job learning with exposure to new technologies and business strategies.
• Employee Referral Program with rewards.
• Office lunch program for employees working from any Siepe office.
• Cultural events: snacks, happy hours, quarterly events, and annual celebrations.