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 many industries and verticals. We serve thousands of clients, including 60+ of the top Fortune 500 companies, representing over 150 million 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- we feel comfortable bringing our authentic 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, each other and we over communicate around everything...especially while we are all connected virtually.

Summary of role

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. 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.


Essential functions

  • Set up participant and point load processes for new or migrating programs
  • Document data processing and data validation procedures for all assigned programs'keep documentation updated
  • Load and perform data validation procedures/checklist for participant and performance data on assigned programs and data migrations
  • Trouble-shoot and correct data load exceptions or inaccuracies
  • 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

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

  • Extensive experience developing ETL process with SSIS
  • Extensive experience with complex SQL development
  • Experience in building and supporting ETL batch process including Delta & Full loads
  • Understanding of process controls and security standards such as PCI or SOC2
  • Familiarity with C# for scripting tasks
  • Experience with code repositories including Azure Dev Ops / Git
  • Knowledge of data warehousing practices, data marts, and operational data stores


Education and Experience

  • At least a two-year college degree 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
  • Industry experience preferred

As a company, we have a responsibility to ensure the safety of our employees, their families, and the clients we serve. Augeo employees share this responsibility. Accordingly, before entering any of Augeo's offices or traveling for any Augeo related business, employees, contractors, and visitors will be required to provide proof of COVID-19 vaccine. Individuals who cannot be fully vaccinated due to a sincere religious belief or medical disability may request an accommodation to Human Resources. We cannot guarantee that all accommodation requests will be granted.


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Adtalem Global Education Adtalem Global Education |
|
Yesterday

Opportunity at a Glance:The Sr. Analyst, Business Intelliggence is responsible for successfully managing, advancing and delivering business intelligence solutions and services to meet the business objectives of the organization's institutions with minimal.

BaseCap Analytics BaseCap Analytics |
Today

Headquarters: New York URL: https://basecapanalytics.com/Data is at the heart of cost efficiency, business processes, and decisioning. Digitally savvy firms have an edge to benefit from new technologies. BaseCap is a rapid-growing software company that.

Press Ganey Associates Press Ganey Associates |
Today

About Press Ganey:Press Ganey pioneered the health care performance improvement movement 35 years ago. Today Press Ganey offers an integrated suite of solutions that enable enterprise transformation across the patient journey. Delivered through a cutting-edge.

Job Description:Ferguson is North America’s leading value-added distributor across residential, non-residential, new construction and repair, maintenance, and improvement (RMI) end markets. Spanning 34,000 suppliers and more than one million customers,.

Are you passionate about technology? Do you have a laser focus to provide exceptional products and services?At Dash Networks we have multiple openings in our Hosting Division supporting clients around the globe. We are looking for a seasoned Web Hosting.