Enterprise Holdings Engineer 2, Data (Madison, WI) in Madison, Wisconsin

Equal Opportunity Employer/Disability/Veterans

ARMS Business Solutions is a web-based vendor providing services and software solutions to insurance companies, vehicle manufacturers, fleets and collision repair centers. Our mission is simple: to bring all stakeholders in the collision repair industry together in a way that benefits everyone. Our web-based software solutions are designed to enhance performance management with complete transparency, concise measurements, and seamless data integration. We believe in the power of key performance indicators to drive improvement.

We’re looking for an ambitious and talented career-minded professional who would like to make a difference utilizing their skill set, while working in a thriving agile-methodology environment. We offer competitive career opportunities, great benefits and promote a work-life balance.

This position is based in Madison, WI.

As an Engineer 2, you will be responsible for the development and maintenance of our Data Warehouse. You will also design and maintain operational data store and reporting data structures. This includes creating and maintaining ETL processes from multiple sources. You will design and maintain data models, data dictionaries and business reports that are easily consumed by our stakeholders.

Key Areas of Responsibilities

  • Collaborate with our stakeholders, DBAs and software engineers to refine project scope and definition

  • Design and develop ETL data and event driven packages

  • Utilize ETL and Data Warehouse development best practices

  • Understand the business operations and processes on assigned projects

  • Create and maintain strategic documentation in support of the Data Warehouse

  • Assist in the design and development of the Data Warehouse

  • Design and maintain effective business intelligence reports by retrieving, analyzing, and transforming data

  • Work with our System Administrators and other Software Engineers in trouble shooting and resolving complex problems within our SaaS platform

  • Work across both project roadmap initiatives as well as production systems support

  • Production Systems Support and on-call dues maybe required in this role


  • Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future

  • Must be committed to incorporating security into all decisions and daily job responsibilities

  • 5+ years' of experience designing databases

  • 2+ years' of experience with data-driven and event-driven ETL processes

  • 5+ years' of experience with SQL and Stored Procedure development

  • 2+ years' of experience with Unix Shell scripting

  • 2+ years' of experience working with MySQL or MariahDB

  • 3+ years' of experience designing and maintaining business intelligence reports

  • Must have strong communication skills both written and verbal

  • Must possess the ability to work in a dynamic environment

  • Must possess initiative, results-oriented drive and a solid work ethic requiring minimal direction

  • Must possess effective analytical, problem-solving and decision-making skills

  • Must possess resiliency and flexibility in the face of changing priorities and requirements

  • Must be committed to incorporating security into all decisions and daily job responsibilities


  • Bachelor's degree in Computer Science or related field

  • Experience working with a large data warehouse

  • Experience with Pentaho product suite or similar

  • Experience using a source code repository such as Subversion

  • Experience with Amazon Redshift

  • Ability to identify and resolve data related issues via SQL performance tuning

Requisition Number: 2017-210251

External Company Name: Enterprise Holdings

External Company URL: www.erac.com