PlanHub is the leading pre-construction SaaS platform and marketplace helping general contractors, subcontractors, and suppliers connect and grow their businesses. Built with tradespeople in mind, PlanHub is designed around the user workflow to help boost productivity, maintain deadlines, increase revenue, and create relationships. Easily post projects or submit bids with anytime-anywhere collaboration for every commercial construction trade.
We are looking for a dynamic Data Engineer to join our team based in West Palm Beach, FL or work Remote.
This role requires an aptitude in relational & noSQL databases, and big data skills. Required tasks for the role include building and optimizing the business’ data collection systems and processing pipelines, which will primarily align with the development efforts surrounding multiple platforms within PlanHub and the data integration between systems.
What you will be doing
Analyze raw, structured, and unstructured data to identify and optimize data sets and entities of interest
Ensure alignment between engineering, and analytical activities
Search for, obtain, analyze, and share information about datasets and their contents
Work on improving the existing data lake and data warehouse systems and architecture
Improve data lake / data warehouse monitoring and alerting
Perform database engineering for new product initiatives
Perform database code deployment and tooling
Define, develop, and optimize queries for product, insights, dashboards, and reporting
Assist software developers with query optimizations
Review and troubleshoot reported issues
What you will need to be successful
7+ years of software development experience in back-end systems
5+ years of professional experience in SQL development and data modeling
Degree in Computer Science or related technical discipline or equivalent experience
Good knowledge and hands-on experience with Python scripting
Good experience with AWS or cloud-based data services
Good experience with Apache NiFi, AWS Glue or similar ETL tools
Good experience with Snowflake AWS Redshift, AWS Lake Formation, or similar Data Warehouse / Data Lake tools
Good experience working with varied forms of data infrastructure inclusive of relational databases such as SQL, MySQL, and NoSQL such as MongoDB, Elasticsearch
Experience in data warehousing inclusive of dimensional modeling concepts and demonstrate proficiency in scripting languages such as PL/SQL Python, Perl, or similar
Experience in designing and implementing OLTP database solutions
Experience in building and maintaining reliable and scalable ETL on data platforms
Strong written and verbal communication skills and the ability to convey technical details to non-technical stakeholders
Self-motivated and willing to "do what it takes" to get the job done
Ability to plan, organize and work on multiple projects with minimal supervision
Agile or Lean software development experience such as Kanban or Scrum is a plus
Full systems lifecycle experience (from requirements to delivery) of database projects is a plus
What's in it for you:
The opportunity to join a dynamic team that landed into the top list of Inc. 5000 in 2022 You can make an immediate impact as PlanHub moves to dominate the industry! PlanHub offers:
An awesome culture where you will be empowered, make an impact, learn a ton,
Remote friendly
Open time-off policy
An excellent benefit package, including medical, dental, vision and life insurance
401(k) plan with company match
*This position will be a remote position within the United States. Occasional trips to our West Palm Beach, FL office, may be required. Applicants must be authorized to work for any employer within the United States. We are unable to sponsor or take over sponsorship of an employment Visa at this time.