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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

T-SQLSQL code refactoringquery tuningETLELTCI/CDdata modelingrelational database designdimensional modelingAI-assisted tools

Soft Skills

troubleshootingcollaborationproblem-solvingcommunicationanalytical thinkingattention to detailadaptabilitycritical thinkingtime managementcreativity