Case Study

Streamlining Data Management for Bobbitt Constructions

Background

Bobbitt Constructions, established in 1946, is a leading general contractor specializing in public and private buildings throughout the Southeast.

With offices in Raleigh, Burlington, Winston-Salem, and Leland, North Carolina, Bobbitt Constructions has a long history of meeting clients’ construction goals and taking on projects of all sizes.

The company’s mission is to simplify the construction process, making it easy and enjoyable for clients and partners alike, distinguishing itself in the commercial construction market.

The Challenge

Bobbitt Constructions faced a challenge with managing its contractor and employee data, which is stored in its HR system, BambooHR.

The company needed a solution to extract this data, transform it for usability, and store it securely in Amazon S3 for analysis by BI tools. This solution had to ensure the data was managed securely, and compliance requirements were met.

Our Solution

We provided a comprehensive data management solution for Bobbitt Constructions, utilizing AWS Appflow, AWS Glue, and Amazon S3:

  • Data Extraction: We used AWS Appflow to pull data securely from BambooHR, allowing for seamless integration with the company’s existing HR system.

  • Data Transformation: AWS Glue was then used to transform the extracted data into useful formats, making it suitable for analysis and visualization by BI tools.

  • Data Storage: The transformed data was stored in Amazon S3 in CSV format, ensuring it was accessible for further processing and visualization.

The Result

The new system has enabled Bobbitt Constructions to streamline its data management, ensuring compliance and improving employee services.

Here’s a testimonial from Daniel Welsch, Business Operation IT:

“Rambunct has successfully set up and transferred the client’s data securely. The team is quick to respond, constantly checked in, and delivers regular status updates. They maintain communication via virtual meetings, emails, and messages. Their fast, customer-centered service is remarkable.”

This solution has led to several key results:

  • Compliance: The new data management system ensures Bobbitt Constructions can access the information needed to comply with relevant regulations.

  • Improved Employee Services: The accessible data allows Bobbitt Constructions to serve its employees better, offering insights that aid in improving internal operations.

  • Streamlined Operations: The comprehensive solution simplifies the company’s data management, reducing complexity and freeing up resources for other areas of the business.

With its new system, Bobbitt Constructions is well-positioned to manage its contractor and employee data efficiently, supporting compliance and enhancing its ability to serve its workforce.