Availability awaiting confirmation
We are waiting for a fresh update from the source. This page preserves the last received job details; current availability is not confirmed.
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.
#J-18808-Ljbffr
Worksite address
san francisco, CA, 94199, US
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.