Augeo
Global leader in engagement platform technologies and data-driven experiences that cultivate brand advocates worldwide.
Senior T-SQL Developer, SQL Server / Snowflake
Software EngineerSoftware EngineerFull TimeRemoteTeam 501-1,000Since 1978H1B No SponsorCompany SiteLinkedIn
Location
United States
Posted
24 days ago
Salary
$105K - $115K / year
Bachelor Degree5 yrs expExperience acceptedEnglishAzureCloudETLSDLCSQLSSISTableau
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
Job 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
Related Guides
Related Job Pages
More Software Engineer Jobs
Software Engineer24 days ago
Full TimeRemoteTeam 51-200Since 2011H1B No Sponsor
Integration Developer designing and implementing solutions for a property and casualty insurer
ApacheAWSCloudDockerEC2JavaJavaScriptJenkinsKubernetesMicroservicesNode.jsPythonSpringSpring BootSpringBootTerraform
Software Engineer25 days ago
Full TimeRemoteTeam 1,001-5,000Since 1977H1B No Sponsor
Developing methods and software tools for large scale electric system capacity expansion
Python
Director, Engineering
Green Thumb Industries (GTI)Green Thumb Industries promotes well-being through the power of cannabis.
Software Engineer25 days ago
Full TimeRemoteTeam 1,001-5,000Since 2014H1B No Sponsor
Director of Engineering managing automated solutions for cannabis manufacturing
Talent Engineering and Operations Lead
Center for Health Care StrategiesBetter care where it's needed most
Software Engineer25 days ago
Full TimeRemoteTeam 51-200Since 1998H1B No Sponsor
Lead design and build of automated recruiting systems: sourcing bots, market intelligence monitors, referral/backchannel databases, interviewer/candidate prep automation, careers site redesign, and ATS data integrity tooling. Partner with hiring teams to scale high-quality candidate pipelines and improve hiring operations through engineering-driven solutions.
ClayClaude CodeCursorV0SlackLinkedinAtsJob BoardsCalendar IntegrationsSeoAeo
California
