Senior T-SQL Developer; SQL Server​/Snowflake

Full-time

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.

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

• 5+ years of hands-on T-SQL development in production environments
• Advanced knowledge of:
  • Query execution plans
  • Index design and optimization
  • Locking, blocking, and transaction isolation levels
  • TempDB behavior and performance impact
  • 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

• Explain how they diagnose and resolve a slow-running stored procedure
• Interpret and optimize complex execution plans
• Design an indexing strategy for a high-volume billing table
• Refactor cursor-based logic into set-based operations
• Describe transaction isolation impacts in high-concurrency systems
• Explain trade-offs between SQL Server and Snowflake architectures

• Improved query performance across reporting and billing systems
• Reduced production incidents related to database performance
• Clean, maintainable SQL code with strong documentation
• Ownership mentality — you treat the database as a product, not a ticket queue

• Engineers who enjoy solving complex performance problems
• Developers who prefer depth over surface-level scripting
• Professionals who take pride in clean, efficient database design
• Individuals who want architecture exposure, not just task execution

• Two- or four-year degree…