Data Engineer - Team Lead at PrismHR

| Greater Boston Area
!Sorry, this job was removed at 5:59 p.m. (EST) on Wednesday, March 18, 2020

* Remote Possibility for Candidates Out-Of-State

You will lead a small team of data engineers in a very hands-on capacity, across a number of parallel customer implementation and data migration projects to the PrismHR core platform.  As a data engineer you will conduct data migrations to efficiently and reliably move data across systems, but also contribute to our next generation of data tools and analytics to better enable us to take full advantage of this data. 

You will own, reinforce and advance our data engineering best practices, and support the team on endeavors that increase efficiency of our data engineering processes, tools and automation.

As a Data Engineer you will conduct data migrations to efficiently and reliably move data across systems, but also build the next generation of data tools to enable us to take full advantage of this data. Though this is a team leadership role, expectation is for this hire to be 80+% hands on.


  • Day-to-day management oversight for a data engineering team of 3 to 5 staff.

  • Create, define, refine, execute and verify data migration scripts to transition customer data from the system of origin to the PrismHR product platform.

  • Design, build and run extremely efficient data migrations to move data to our large Data Warehouse 

  • Collaborate across implementation and engineering teams in high visibility roles on key customer data migration projects and initiatives

  • Work closely with customers and implementation teams to define, map, and migrate data from legacy HR and payroll systems to the PrismHR product platform.

  • Take ownership of assigned projects and drive them to completion in a timely manner.

  • Ensure that projects meet technical requirements and comply with PrismHR’s development and technology standards.


  • 5+ years of data migration experience

  • Prior experience as a highly hands-on data engineering team lead is highly desired, but will consider candidates with high potential and desire to grow into a team leadership role.

  • 5+ years of experience with dimensional data modeling & schema design in Data Warehouses 

  • 5+ years of experience in custom or structured ETL design, implementation and maintenance 

  • Ability to write well-abstracted, reusable code components 

  • Outstanding communication, collaboration and project management skills

  • Exceptional multi-tasking ability;  strong worth ethic with exceptional accountability and follow-through

  • BS or MS degree in Computer Science or a related technical field
  • Pluses:

    • Knowledge of PEO, human resources, and/or payroll software.
    • Experience with multi-value databases (PICK), UniBasic, or System Builder.
    • Postgres, ElasticSearch, Kafka, AWS


PrismHR is an EO/AA/VEV/Disabled Employer
Diversity Candidates are encouraged to apply

Read Full Job Description
Apply now

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavascriptLanguages
    • ReactLibraries
    • Twitter BootstrapLibraries
    • AngularJSFrameworks
    • ExpressFrameworks
    • Node.jsFrameworks
    • Sails.jsFrameworks
    • Angular 2+Frameworks
    • PostgreSQLDatabases
    • ElasticsearchDatabases
    • Google AnalyticsAnalytics
    • BalsamiqDesign
    • InVisionDesign
    • SketchDesign
    • Adobe XDDesign
    • ConfluenceManagement
    • JIRAManagement
    • DrupalCMS
    • Joomla!CMS
    • WordpressCMS
    • SalesforceCRM
    • GMailEmail
    • MarketoLead Gen


35 Parkwood Drive, Hopkinton, MA 01748

An Insider's view of PrismHR

What are some social events your company does?

PrismHR hosts a bunch of events, so it's easy to connect with other team members in the company. To name a few, we've hosted cornhole tournaments, painting classes, trivia nights, charity fundraisers, and holiday decorating contests, not to mention free food- breakfasts, potlucks, and an ice cream truck in the summer!


Marketing Programs Specialist

What are PrismHR Perks + Benefits

Volunteer in Local Community
Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Onsite Gym
Retirement & Stock Options Benefits
401(K) Matching
Perks & Discounts
Casual Dress
Company Outings
PrismHR hosts a variety of company outings each year.
Game Room
Our game room includes Shuffle Board, Video Games.
Stocked Kitchen
PrismHR has a fully stocked kitchen including unlimited snacks, coffee, tea and soda.
Pet Friendly
PrismHR is a dog-friendly office everyday.
Professional Development Benefits
Lunch and Learns
PrismHR hosts Lunch and Learns to support new initiatives across the company.