Integration Engineer

VEC•San Francisco, CA

19d•$120,000 - $155,000•Hybrid

About The Position

VEC is a leading construction technology services provider at the forefront of innovation in the construction industry, delivering cutting-edge technology solutions that improve how construction projects are planned, designed, and built. Our mission is to challenge the status quo and reshape the built world so humanity can thrive sustainably. We partner with contractors, engineers, and developers/owners across the United States and deploy our team of construction and technology professionals across large, complex projects in sectors including Data Centers, Healthcare, Life Sciences, Technology, Education, Transportation, Aviation, Commercial Office Space, and Public Works. We value our VECommunity, continuous improvement, and helping the best build better. Our Core Values Goodness: Be ethical and do right by yourself, your teammates, and our partners. Extreme Ownership: We take responsibility and deliver results. Curiosity: We continuously seek better solutions. Better Together: Collaboration drives stronger outcomes. Balance: We support sustainable, long-term success for our people. Position Overview Own the technical integration, API data pipelines, and enterprise data modeling for VEC’s software ecosystem. Acting as a true Solutions Architect and lead BI developer, this role builds and maintains automated data flows between our core systems (Kantata/future ERP, HubSpot, ClickUp, Rippling). You will bridge the gap between business logic and technical execution, translating complex AEC financial structures into highly reliable, self-healing automated workflows, while owning the enterprise semantic model in Power BI.

Requirements

4–7+ years in integration engineering, BI development, backend engineering, or data architecture.
Analytics Mastery: VERY strong enterprise BI capabilities, including deep expertise in Power BI, DAX, SQL, and semantic data modeling.
API & Infrastructure Mastery: Practical experience building and maintaining integrations (REST APIs, webhooks, OAuth 2.0) across systems like Kantata/Mavenlink, HubSpot, ClickUp, and Rippling.
Proficiency in Python/Node.js and serverless deployments.
iPaaS Expertise: Hands-on experience with enterprise iPaaS platforms (Workato, Celigo, Boomi, or Azure Logic Apps).
Soft Skills: Able to work collaboratively with non-technical stakeholders and translate technical API/data constraints into plain language.

Responsibilities

Lead the custom technical integration of Rippling (HRM) with downstream platforms. You will ensure that employee master data, department mapping, and effective-dated cost rates automatically sync from Rippling into Kantata (and eventually our new ERP) via API.
Build and maintain integrations between HubSpot, Kantata, ClickUp, and Slack using iPaaS tools (e.g., Azure Logic Apps, Workato, Celigo) or custom API scripts.
Automate key business transitions, such as triggering a Kantata project shell and a ClickUp workspace creation when a HubSpot deal is marked "Closed-Won".
Develop custom, native integrations using Python or Node.js deployed in serverless environments (e.g., AWS Lambda, Google Cloud Functions) when pre-built iPaaS connectors are insufficient.
Architect self-healing, asynchronous integrations that handle REST API rate-limiting, pagination, and timeout issues.
Own integration monitoring, webhook maintenance, and implement Dead Letter Queues so failed syncs are caught and resolved without data loss.
Design and maintain the enterprise data model and semantic layer in Power BI, pulling financial truth from Kantata, pipeline context from HubSpot, and headcount/cost data from Rippling.
Build and own executive-grade Power BI dashboards calculating utilization, margin, backlog, and business development ROI.
Ensure reporting trust by maintaining strict data definitions and preventing dashboard sprawl.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume