hero

We invest in #tech

Matchstick Ventures
Matchstick Ventures
57
companies
99
Jobs
If you are a Matchstick Ventures portfolio companyclaim your profile.

SQL Development Manager

Structural

Structural

West St Paul, MN, USA
Posted on Wednesday, April 24, 2024
Job Type
Full-time
Description

About us

Hello, we're Augeo--architects of enterprise engagement and loyalty platforms, delivering compelling experiences and fostering meaningful connections with employees, customers, members and channel partners across industries. We serve thousands of clients, including more than 70 of the top 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. Everyone is welcome, and our employees are comfortable bringing their authentic whole selves to work. Be you.

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 are all connected virtually.

Summary

This role will manage the data development team as a player/coach and participate in process improvement, data architecture, data management, and analytics tasks. Augeo Data Developers are 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 leading the development and operational cadence related to these activities, working with a cross-functional team to define and implement Augeo’s strategic data objectives and day-to-day tasks. You will be required to work on complex assignments and collaborate with Augeo's IT and SaaS applications teams. The ideal candidate understands business needs and translates them into technical solutions, as well as manages internal and external client relationships as needed.

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

  • Manage the development lifecycle of data management and modification projects
  • Maintain consistent flow and quality of data operations tasks
  • Document data processing and data validation procedures for all assigned programs
  • Trouble-shoot and correct data load exceptions or inaccuracies
  • Develop automated and reusable routines for extracting requested information
  • Assist account team with data queries and support Program Success Metrics process and account reviews on assigned programs
  • Research new technologies and processes to continuously improve the organization
  • 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

  • Strong written and verbal communication skills, including technical writing skills
  • Fundamental analytical, conceptional thinking and problem-solving abilities
  • Ability to participate in meetings to communicate findings and plans to cross-functional 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

  • Understanding of process controls and security standards such as SOC2
  • Strong familiarity with T-SQL and SQL:2023
  • Familiarity with Amazon RDS (SQL Server) and Amazon Aurora (Postgres)
  • 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

Education and Experience

  • Two-year or four-year 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
  • 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

  • Medical, Dental & Vision Insurance
  • Employer-sponsored Long-term disability and Life Insurance
  • Paid Time Off and flexible work schedule
  • 401(k) Plan
  • Fun and casual work environment
  • Career growth opportunities
  • Rewards & Incentives