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
Apply Now
Apply Now
• 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
Apply Now
Apply Now