What are the responsibilities and job description for the SQl Data Developer position at Augeo Affinity Marketing?
Job Description
Job 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 70 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 Data Developer will be responsible for utilizing Augeo's data assets 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. Excitingly, Augeo has a new Snowflake data warehouse that you will be helping to build out and transition to. Additionally, you will be expected to support data architecture and management efforts as required. You will be required to work on fairly complex assignments and collaborate with Augeo's IT applications team. The ideal candidate understands business needs and translates them into technical solutions, as well as manages internal and external client relationships as needed.
Location :
Minnetonka, MN or Remote
Who You Are
Innovator : Bring ideas to the table, work hard, tell your story, and build new tech
Collaborator : Contribute to the team and help accomplish amazing things
Curious : Keep learning, keep implementing, and iterate
High-level Job Requirements
- Design, develop, and maintain ETL / ELT pipelines for data integration from multiple sources into Snowflake.
- Optimize and fine-tune Snowflake data warehouse to ensure performance, scalability, and cost efficiency.
- Develop and manage data models, schemas, and transformations for analytics and reporting.
- Monitor, troubleshoot, and correct ETL failures, optimize data loads, and ensure data integrity.
- Document data processing and data validation procedures for all assigned programs and keep documentation updated
- Load and perform data validation procedures / checklist for participant and performance data on assigned programs and data migrations
- Develop automated and reusable routines for extracting requested information
- Produce accurate and timely reports, both online and offline as appropriate to client needs
- Compiling detailed reports using data reporting tools such as Stored Procedures executed from within the platform websites
- Assist account team with data queries and support Program Success Metrics process and account reviews on assigned programs
- Analyze performance of database queries and take action to correct deficiencies
- Monitor scheduled tasks and queries post-implementation
- Foster an innovative and inclusive team-oriented work environment.
- Contribute to process improvement efforts at Augeo
- Embrace Augeo's CORE values - Collaborative, Objective, Responsive and Earnest in all areas
Competencies
Desired Technical Skills
Education and Experience
Benefits of joining our team
Requirements :
