Job Closed
This listing is no longer active.
Global leader in engagement platform technologies and data-driven experiences that cultivate brand advocates worldwide.
Senior T-SQL Developer, SQL Server / Snowflake
Location
United States
Posted
113 days ago
Salary
$105K - $115K / year
Seniority
Senior
Job Description
Senior T-SQL Developer, SQL Server / Snowflake
Augeo
• 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
• Collaborate with cross-functional teams to design, implement, and support integration solutions aligned with business needs. • Create low-level integration designs that can be effectively implemented and maintained by the wider team. • Review, analyze, and challenge high-level designs to ensure alignment with integration technologies, standards, and technical strategy. • Develop integration solutions hosted on AWS, ensuring scalability, reliability, and performance. • Define and perform unit testing and validation to ensure integration quality and long-term stability. • Provide production and operational support, including participation in major incident resolution. • Monitor integration performance and usage; implement alerts and observability practices. • Assist in the automation of CI/CD deployment pipelines using modern DevOps practices. • Provide technical mentorship and code reviews for junior developers.
• Collect the required data and develop fundamental methods and software tools and interfaces required to support large scale electric system capacity expansion. • Develop the generalized frameworks to link capacity expansion models (CEM), such as GenX and ReEDS, and production cost models (PCM), such as Sienna\Ops. • Develop automated workflows to estimate maximum power flow transfer constraints between any arbitrary set of aggregated spatial regions (or 'zones'). • Work towards automating transmission network designs to enable generation interconnections and transmission capacity augmentations consistent with results from CEMs and develop methods for automated downscaling of zonal CEM results to a nodal PCM for further reliability analysis.
• Ensure the performance, quality, and responsiveness of applications • Refactoring existing code to improve its design working in an agile environment. • Develop test-covered code at a high quality and take part in team decisions to build scalable and maintainable apps. • Participate in code reviews to ensure code quality, best practices, and standards are followed. • Document technical specifications, installation procedures, and other relevant information for applications.
Director, Engineering
Green Thumb Industries (GTI)Green Thumb Industries promotes well-being through the power of cannabis.
• The Director, Manufacturing – Engineering and Packaging will provide oversite, direction, and technical/training support to our team of Engineers and facilities team members. • A primary goal of this role is to development automated solutions and CI for our sites to deliver outstanding quality cannabis to our consumers and patients at scale. • The Director, Manufacturing – Engineering and Packaging, and their team, will play a pivotal strategic role in ushering priority projects from a feasibility though a full IQ/OQ/PQ validation and hand-off with a technical transfer to the site production team. • This team will also work with the facilities team to deliver productivity improvements and execute GTI’s automation strategy. • Develop and execute the company’s manufacturing strategy in alignment with overall business strategy. • Evaluate, source, integrate, commission and transfer knowledge for automated systems capable of packing, labeling, sealing, erecting, weighing, dispensing, inspecting and other common automated CPG needs. • Build cost model and justification for projects that accelerate the business and generate revenue. • Accountable for keeping all projects on schedule, within budget and finished to completion. • Coordinate the efforts of Engineering and technical resources based on Senior Leadership Priorities and Site 90-day plan priorities. • Mentor and coach direct reports to ensure full utilization of team members skills and capabilities. • Establish and maintain best-practice standards for policies, procedures, and engineering documentation. • Work with other departments (i.e. Prod Development, Project Management, Quality, Compliance, Operations, etc.) to integrate new systems. • Conduct studies, identify problems, recommend alternatives, and implement solutions in coordination with engineering team and local facility teams to ensure constant optimization. • Provide support to Start-up GM’s in delivering a successful ramp up: Staffing, equipment layout and requirements, construction hand off, regulatory engagement, best-practice processes, and technical transfer for equipment.



