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 seeking a highly skilled and experienced Senior Data Engineer to join our dynamic team. In this role, you will be responsible for designing and managing datawarehouses, datalakes and ETL flows and BI models. Your contributions will ensure seamless data integration and enhance the functionality of our platform for our growing user base.What you will be doingDevelop, deploy and maintain datawarehouse and datalake systems. Optimize data pipelines and workflows using tools like DBT, AWS Glue and Dockerized environments. Ensure high availability, scalability, and performance of data integrations while adhering to best practices in data engineering. Troubleshoot and resolve issues related to API integrations and data pipelines.Document technical processes, workflows, and data architecture to ensure maintainability and clarity. Stay current with emerging technologies and industry trends to recommend improvements to the existing tech stack. What you will need to be successful5+ years of hands-on experience in data engineering, with a focus on API development and data lake/warehouse designStrong OLAP/datawarehousing experience in Redshift, Snowflake etcExpertise in Python for building data pipelines and integration tools. Proficiency in working with REST APIs (design, implementation, and troubleshooting). Strong knowledge of AWS services, particularly AWS Glue, Lambda, S3, and EC2.Experience with containerization tools like Docker. Solid understanding of Linux environments and shell scriptingProven ability to troubleshoot complex data integration issues and optimize workflows. Excellent communication and teamwork skills, with the ability to work effectively with cross-functional teams. Nice to haveExperience with Orchestration/ETL tools (NiFi, Airflow, DBT etc...) Familiarity with Bitbucket/Github for version control and CI/CD pipelines.Knowledge of data governance and security best practices. Experience with third-party REST APIs for accessing CRM, Subscriptions, Software Experience etc...What's in it for you:The opportunity to join a dynamic team that landed into the top list of Inc. 5000 in 2024 You can make an immediate impact as PlanHub moves to dominate the industry! PlanHub offers:An excellent benefit package, including medical, dental, vision and life insuranceRRSP with a company matchFlexible PTOAn awesome culture where you will be empowered, make an impact, and learn a tonRemote friendly
Job Title
Senior Data Engineer