Data Integration Developer

About Field Service Holdings LLC

We are a remarkable company in remarkable times. Our business includes PestRoutes software and Lobster Marketing, together comprising Field Service Holdings LLC. PestRoutes® is a SaaS platform providing end-to-end office management software for field service providers in markets such as pest, pool, and lawn. Lobster Marketing adds market-facing web sites, buy online capability, dashboarding, and digital marketing services. PestRoutes was founded in 2012, and Forbes just named us on their list of "2020 Best Start-up Employers" based on employee enthusiasm, fast-growth, and financial strength. In January 2020, we joined the portfolio of Gryphon Investors and had outstanding financial support.

Development @ PestRoutes

On the PestRoutes software development team, code is released daily to tens of thousands of field service staff around the country (our customers' service about 4% of homes in America)—the code you write in the morning could be deployed to thousands of users the same day. Our office software runs on a LAMP stack deployed across self-hosted cloud servers running the same codebase, and our app uses React Native with a continuous integration solution for a clean, build-less release process.

There are lots of differently shaped problems to take on at PestRoutes, and we are looking for engineers who like challenges, are good problem solvers, and can build on an existing framework to optimize for scale. Customer growth presents interesting challenges—you can find something that interests you, with the opportunity to pioneer and take ownership of key features while you grow with the company. Whether you're interested in front-end user experience, mobile app development, query optimization, dev-ops, application security, or something else entirely, you'll be able to find your place.

As a Data Integration Developer, you will be responsible for working with the data management team to optimize loading data into the application from other systems. You will be responsible for designing, testing, and implementing migration scripts into a MySQL database environment to maximize the efficiency of the data migration process while maintaining excellent data quality standards, and will participate in other data management initiatives. Additionally, you will:

Responsibilities

• Run existing migration processes and ensure data mapping and data migration processes from external systems
• Continually seek ways to improve the process of data conversion, migration, and integration
• Share knowledge and proper documentation related to the data migration efforts
• Provide quality formal and informal documentation consistent with documentation standards
• Pay close attention to detail to ensure integrity and quality of data migration
• Report progress to business and project managers in a timely manner

Qualifications

• 5+ years' experience with prior data migration, conversion, or integration project for a new ERP system implementation
• Advanced knowledge of SQL scripting and working with relational database systems
• 5+ years' experience defining data objects, models, data definitions, and mapping data between various formats and systems
• Experience with various coding languages and systems. PHP and MySQL/SQL Server preferred
• Intermediate knowledge of PL/SQL scripting, databases, data structures, and data types/formats
• Clear and effective verbal and written communication
• U.S. Citizen or Permanent Resident status required
• Visa Sponsorship not available

Some of the Perks

• Generous Paid Time Off – 18 days to start and 12 annual paid holidays
• Competitive compensation
• Best-in-class health, dental and vision coverage, including Employee-only coverage options fully paid by the company and HSA options with company contributions
• 401k, life insurance, STD, and LTD programs
• Progressive paid family (maternity/paternity) and adoption leave