SQL Data Developer
SQL Data Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Hello were Augeo we are a global leader in enterpriselevel 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 were 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 overcommunicate 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 Augeos 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 adhoc 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 Augeos 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
Highlevel Job Requirements
- Design develop and maintain ETL/ELT pipelines for data integration from multiple sources into Snowflake.
- Optimize and finetune 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 postimplementation
- Foster an innovative and inclusive teamoriented work environment.
- Contribute to process improvement efforts at Augeo
- Embrace Augeos CORE values Collaborative Objective Responsive and Earnest in all areas
Competencies
- Strong written and verbal communication skills including technical writing skills
- writing skills
- Fundamental analytical conceptional thinking and problemsolving abilities
- Ability to participate in meetings communicating findings and plans to crossfunctional team members management and clients
- Forward thinking on ways to improve product related challenges with an eye toward delivering value to the end user
- Organized with the ability to work independently toward project driven deadlines in person or remote
- Experience prioritizing initiatives based on internal and client business needs
Desired Technical Skills
- Strong experience with Snowflake (warehousing performance tuning Snowflake SQL Snowpipe Streams Tasks).
- Understanding of process controls and security standards such as SOC2
- Familiarity 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
Education and Experience
- Twoyear or fouryear college degree from a regionally accredited college or university preferred
- Microsoft Office Microsoft Excel and Microsoft SQL Server proficiency required
- Experience with complex Stored Procedures required
- Experience importing data files in a variety of formats
- Proficient with relational database technologies and theories
- Experience with SQL Server Integration Services (SSIS) or similar technologies
- Understanding of and discipline to follow rigorous IT data and systems policies
- Ability to work on multiple assignments and achieve objectives and deadlines
Benefits of joining our team
- We offer Medical Dental and Vision coverage with additional perks through third party vendors offering more virtual and in person care at your fingertips
- We offer paid LongTerm disability and Life Insurance
- HSA/FSA plans
- We offer 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
- EAP resources
- 13 paid holidays and PTO time
- Rewards and incentives for birthdays work anniversaries professional and personal milestones and company involvement
- Employee referral bonuses
- Employee group opportunities
- Fun casual and flexible working environment that embraces the hybrid workstyle
- Career growth opportunities
- Summer internship program
Employment Type
Full-Time
