Integration Engineer

VEC; San Francisco (CA); Hybrid; USD 120,000 - 155,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

VEC, a leading construction technology services provider, seeks a Solutions Architect and lead BI developer to own integration, API data pipelines, and enterprise data modeling for its software ecosystem. Translate complex AEC financials into reliable automated workflows and maintain the Power BI semantic model.

In this hybrid role, integrate Rippling, Kantata, HubSpot, ClickUp, and Slack, build self-healing data flows, and deliver executive dashboards on utilization, margin, and backlog to

Qualifications

• 4–7 years in integration, BI development, backend engineering, or data architecture.
• Proficient in Power BI, DAX, SQL, and semantic data modeling.
• Experience building integrations via REST APIs, webhooks, OAuth 2.0 across Kantata, HubSpot, ClickUp, and Rippling.
• Hands-on iPaaS experience ( Workato, Celigo, Boomi, or Azure Logic Apps ).
• Able to translate technical constraints for non-technical stakeholders.

Responsibilities

• Lead Rippling integration with global HRM platforms and sync data into Kantata/ERP.
• Build integrations between HubSpot, Kantata, ClickUp, and Slack using iPaaS or custom scripts.
• Automate transitions, e.g., Closed-Won triggers for Kantata project shells and ClickUp workspaces.
• Design and maintain the enterprise Power BI data model and dashboards.
• Ensure reporting trust with clear data definitions and controlled dashboard proliferation.

Skills

Power BI

SQL

DAX

Semantic Modeling

Python/Node.js

REST APIs

iPaaS

Collaboration

Tools

Kantata

HubSpot

Rippling

Azure Logic Apps

Workato

Celigo

Boomi

Job description

Who We Are

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.

Key Responsibilities

Rippling Integration & Enterprise Data Pipelines

• 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”.

API Reliability & Serverless Infrastructure

• 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.

Data Modeling & Enterprise Analytics (Power BI)

• 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.

What This Role Is Not

• Identity & Access Management (IAM): You will not handle Rippling IT Administration (SSO/App provisioning), user account creation, or endpoint device management; this is owned by the IT Ops Manager.
• Business Process Owner: You build the technical integration and data models; the Business Operations Manager and CTO decide the system-of-record policies and business rules.

Required Skills And Qualifications

• 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.

What Success Looks Like (First 6 Months)

• Rippling integration with global HRM platforms.
• The HubSpot-to-ERP “Closed-Won” automation is fully mapped, tested, and live.
• Integration errors are caught by automated alerts and resolved quickly by you, rather than being discovered by end-users.
• The foundational Power BI semantic model is live, giving executives a single, trusted pane of glass for utilization and backlog.

Work Environment: Hybrid – must reside within commuting distance to the San Francisco HQ office.

Compensation Range: $120,000 — $155,000

EEO Statement

VEC is an Equal Employment Opportunity Employer. In accordance with federal and state laws, VEC does not discriminate in employment because of race, color, religion, sex, national origin, age, physical and mental disability, marital status, pregnancy, childbirth, breastfeeding or related condition, ancestry, medical condition (associated with cancer, a history cancer or genetic characteristics), veteran or military status, sexual orientation, gender, gender identity or gender expression, HIV/AIDS status, genetic information or any other characteristic protected by law.