SQL and Snowflake Developer

Description

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.

This role will manage the data processing and reporting functions associated with participant and performance data. An Augeo SQL Developer is responsible for utilizing Augeo's data assets and AI to provide analysis and reporting to end users and internal customers as well as manage the flow of data within the environment. You will be developing, testing and implementing ETL packages within Microsoft SQL Server SSIS along with creating ad-hoc queries and reports using SSMS, AI-native tools like Cursor, and Visual Studio Code.

Excitingly, Augeo has a new Snowflake data warehouse that you will be helping to build out and transition to. This role blends traditional data engineering with modern AI capabilities to drive innovation and efficiency.

• Innovator: You explore AI tools to solve problems faster and smarter.
• Collaborator: Contribute to the team and help accomplish amazing things
• Curious: You experiment with AI agents to automate tasks and uncover insights.

• Design and maintain ETL/ELT pipelines using Copilot-assisted scripting and Cursor’s SQL autocompletion
• Optimize Snowflake performance with AI query tuning tools like Blaze
  
  SQL and Cortex AISQL
• Use AI to generate and validate data models, schemas, and transformations
• Document data processing and data validation procedures for all assigned programs and keep documentation updated
• Monitor and troubleshoot ETL failures with AI-driven anomaly detection
• Automate documentation using AI summarization tools
• Validate data using AI-powered test generation and schema comparison
• Support account teams with AI-assisted data queries and visualizations
• Contribute to process improvements by piloting new AI tools and workflows
• Embrace Augeo’s CORE values:
  Collaborative, Objective, Responsive, Earnest

• Strong written and verbal communication
• Analytical mindset with a passion for AI-augmented problem solving
• Experience collaborating in AI-enhanced development environments
• Organized, with the ability to work independently toward project driven deadlines

• Proficiency in Microsoft’s T-SQL query language
• Proficiency in Snowflake (Snowpipe, Streams, Tasks, performance tuning)
• Familiarity with Cursor
  , Git Hub Copilot
  , and AI2
  
  SQL
• Experience with C# for scripting tasks
• Experience with code repositories including Azure Dev Ops / Git
• Familiarity with Mongo and the ability to write queries against data stored in Mongo
• Exposure to Tableau BI or Power BI reporting tools
• Knowledge of data warehousing practices, data marts, and operational data stores
• Experience working with CI/CD pipelines
• Knowledge of SOC2 process controls and security standards

• Two- or four-year degree preferred
• Experience with SSIS, complex stored procedures, and data imports
• Familiarity with AI-enhanced development workflows and tools
• Proficient in Microsoft SQL Server and relational database technologies

This role operates in a hybrid environment enhanced by AI collaboration platforms
. You’ll use tools like Cursor and Copilot to work smarter, not harder. This role routinely uses standard office equipment such as laptop computers and smartphones.

The physical demands described…