SQL Development Leader - Integrations

Why SiepeSiepe 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.What You'll GetImpactful 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!How We Show UpWe 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 ForWe’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 DoingProvide 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 improvement for integration reliability.Evaluate and apply modern data platform patterns and tooling (e.g., Databricks, Snowflake, CDC/streaming) where they improve scalability or resiliency.Leverage AI-enabled tools to accelerate development, improve test coverage, and reduce cycle time without sacrificing correctness.What You’ll Bring7+ years of software engineering experience, including technical leadership, delivery leadership, or people management.Experience providing technical direction, reviewing work, mentoring engineers, and driving team execution while remaining hands-on. Direct people management experience - including performance management, work allocation, and team development - is required for candidates considered for the people manager scope.Prior experience in consulting or professional services environments with direct accountability for delivery outcomes.Demonstrated ownership of estimation accuracy, scheduling, and delivery commitments.Advanced T-SQL skills with strong experience in data modeling, transformation, and performance optimization for high-volume transactional and OLTP applications.Experience building data-centric solutions across data warehouses, data lakes, dashboards, and reporting systems.Solid understanding of modern software development practices, architectures, and integration patterns.Experience designing or supporting integrations with third-party or client-owned systems, including APIs, data feeds, cloud data platforms, or enterprise tools.Practical experience applying AI tools or techniques within engineering workflows to improve development quality and delivery.Experience with Databricks, Snowflake, or similar cloud data platforms.Financial services experience, particularly in structured finance, loan operations, or middle-office data workflows, is a plus.Experience implementing data observability practices - including freshness checks, anomaly detection, and automated reconciliation - is preferred.All applicants must have current and ongoing authorization to work in the country of employment without the need for visa sponsorship, now or in the future.What We OfferGreat work should come with more than a paycheck. At Siepe, we invest in the things that help you build a career, take care of yourself and your family, plan for the future, and enjoy the people you work with.Our Total Rewards are designed to support you at work and beyond:Competitive compensation, including annual performance-based bonus opportunitiesRetirement benefits with company contributions, including 401(k) or pension plans depending on locationComprehensive health, dental, vision, and life insurance, with employee coverage 100% funded by Siepe where applicableFlexible Time Off (FTO) because life happensLearning & Development budget to invest in your professional growthCareer growth and on-the-job learning, with opportunities to stretch beyond your role and gain exposure to new technologies and business strategiesEmployee Referral Program with rewards for helping us grow the teamOffice lunch program, available to employees when working from any Siepe officeA culture that makes time to connect, with snacks, happy hours, quarterly events, and annual celebrationsBenefits, program eligibility, and coverage may vary by location.Siepe is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, marital status, or protected veteran status. If you require an accommodation to participate in our application or interview process, please let us know - we're happy to work with you to make it accessible.