Integration Engineer

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 VECs 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 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

• 47 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/ 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: Remote with occasional travel as business needs require.

Compensation Range: $120000 $155000

EEO Statement

VEC is an Equal Employment Opportunity 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.