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 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 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 Bring- 7+ 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 opportunities
- Retirement benefits with company contributions, including 401(k) or pension plans depending on location
- Comprehensive health, dental, vision, and life insurance, with employee coverage 100% funded by Siepe 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 opportunities to stretch beyond your role and gain exposure to new technologies and business strategies
- Employee Referral Program with rewards for helping us grow the team
- Office lunch program, available to employees when working from any Siepe office
- A culture that makes time to connect, with snacks, happy hours, quarterly events, and annual celebrations
Benefits, program eligibility, and coverage may vary by location.
