Senior T-SQL Developer (SQL Server / Snowflake)
About the position Hello, we're Augeo – we are a global leader in enterprise-level engagement and loyalty platform technology, delivering compelling experiences and fostering meaningful connections for employees, consumers, members and channel partners across many industries and verticals. We serve hundreds of clients, including 65 Fortune 500 companies, representing millions of end users. We are thought leaders and disruptors who think differently and creatively, built by entrepreneurs, operators, and innovators. At Augeo, we're passionate about providing an inclusive workplace that values diversity and our sustainability initiatives. Everyone is welcome - our employees are comfortable bringing their authentic whole selves to work. Be you, reach your full potential. We work hard, we play hard and, most importantly, we care to our core about our teams and each other. We over-communicate around everything...especially while we navigate our new hybrid world. We are builders, operators, and innovators who take ownership of business-critical systems. If you are a hands-on SQL engineer who enjoys solving complex data challenges at scale, this role is for you. If you are a hands-on SQL engineer who enjoys solving complex data challenges at scale, this role is for you.
Responsibilities
- 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
Nice-to-haves
- 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
- We offer 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)
- We offer paid Long-Term disability and Life Insurance
- HSA/FSA plans
- We offer 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 tot his job Apply To this Job