SQL and Snowflake Developer at Augeo Affinity Marketing, Inc.

St. Paul, Minnesota, United States -

Full Time

Start Date

Immediate

Expiry Date

12 Feb, 26

Salary

0.0

Posted On

14 Nov, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Snowflake, ETL, Data Processing, Data Validation, AI Tools, Microsoft SQL Server, SSIS, C#, Data Warehousing, Tableau, Power BI, GitHub, MongoDB, CI/CD Pipelines, SOC2

Industry

Description

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. Summary 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. Who You Are 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. Responsibilities Design and maintain ETL/ELT pipelines using Copilot-assisted scripting and Cursor’s SQL autocompletion Optimize Snowflake performance with AI query tuning tools like BlazeSQL 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 Competencies 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 Technical Skills Proficiency in Microsoft’s T-SQL query language Proficiency in Snowflake (Snowpipe, Streams, Tasks, performance tuning) Familiarity with Cursor, GitHub Copilot, and AI2SQL 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 Education & Experience 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 Work Environment 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. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch or crawl; talk or hear; and taste or smell. The employee must occasionally lift or move up to 20 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus. Travel Travel is primarily local during the business day, although occasional out-of-area and overnight travel may be expected. Benefits of joining team Augeo 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

Responsibilities

Manage data processing and reporting functions associated with participant and performance data. Develop, test, and implement ETL packages while optimizing Snowflake performance and utilizing AI tools for data analysis.