Senior T-SQL Developer, SQL Server / Snowflake

Job Description: • Design, develop, and optimize complex T-SQL stored procedures, views, and functions • Refactor legacy SQL code for performance, scalability, and maintainability • Perform advanced query tuning using execution plans, indexing strategies, and statistics analysis • Architect and maintain ETL/ELT processes (SSIS and cloud-based pipelines) • Support business-critical reporting and billing systems with high accuracy and performance expectations • Implement CI/CD practices for database deployments (Azure DevOps/Git) • Contribute to Snowflake data warehouse design, optimization, and data modeling • Troubleshoot production performance issues and resolve root causes • Collaborate with cross-functional teams to translate business requirements into scalable data solutions Requirements: • 5+ years of hands-on T-SQL development in production environments • Advanced knowledge of: o Query execution plans o Index design and optimization o Locking, blocking, and transaction isolation levels o TempDB behavior and performance impact o Set-based logic and performance tuning • Experience building and maintaining complex stored procedures (1,000+ lines of logic) • Strong understanding of relational database design and normalization • Experience with SSIS or enterprise ETL frameworks • Experience with Git-based source control and structured SDLC environments • Proven ability to troubleshoot slow queries in high-volume transactional systems • Hands-on experience with Snowflake (Snowpipe, Streams, Tasks, performance tuning) • Data warehousing and dimensional modeling experience • Experience migrating workloads from SQL Server to Snowflake • Exposure to BI tools (Tableau or Power BI) • Familiarity with CI/CD automation for database deployments • Understanding of SOC2 controls and secure data handling practices • Understand how AI-assisted tools can improve development efficiency • Use AI responsibly to enhance — not replace — engineering judgment • Can evaluate AI-generated SQL for correctness, performance, and security • Stay informed on emerging AI capabilities within data engineering ecosystems Benefits: • Medical, Dental and Vision coverage with additional perks through third party vendors offering more virtual and in person care at your fingertips (must be in select locations) • Paid Long-Term disability and Life Insurance • HSA/FSA plans • Varying voluntary benefits such as critical, hospital, pet coverage and much more • Employee benefit education, campaigns and wellness opportunities • 401k retirement matching and financial planning resources • Education reimbursement • Several EAP resources • 13 paid holidays and PTO time • Rewards, incentives and gamification for birthdays, Work-aversery's, professional and personal milestones, company involvement and kudos • Employee referral bonuses • Employee group opportunities • Fun, casual and flexible working environment that embraces the hybrid workstyle • Career growth opportunities • Summer internship program