Integration Consultant, Tech

Gigawatt

Integration Consultant specializing in mapping and migrating utility data for Gigawatt's AI-native software platform. Collaborating with engineering and customer teams to ensure data flow and integration reliability.

Posted 7/29/2026full-time🇺🇸 United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data integration and engineering, focusing on building reliable enterprise integrations, data flows, and migration processes. Proficient in managing large data volumes and ensuring operational reliability through effective monitoring and exception handling.

Highest-signal resume keywords

Data Migration And ConversionIntegration And Data EngineeringBoomi Or Comparable iPaaSKafka / ConfluentOperational Reliability

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Source-To-Target MappingETLSQLChange-Data-CaptureREST APIsGraphQL APIsWebhooksData ValidationData ReconciliationData Modeling

Soft Skills

Strong OwnershipCollaborativeDependableCommunication SkillsComfortable With Ambiguity

Tools & Technologies

BoomiKafkaConfluentGoldenGateMonitoring Tools

Industry Keywords

Enterprise IntegrationsUtility SystemsCustomer DataBilling SystemsMaster Data Management

Tech Stack

Tools & technologies

ETLGraphQLKafkaSQL

About the role

Key responsibilities & impact

Own customer data readiness — Profile source systems, define the data each module needs, secure access, and get that data into shape to load — surfacing quality and structure issues early.
Build and run migration and conversion loads — Do the source-to-target mapping, run mock and iterative loads with the data team, validate results, and reconcile against the legacy system to stand up each go-live and work through the cleanup that follows.
Build inbound integrations — Stand up the four-pattern feeds (API read/write, Kafka initial load, Kafka CDC) through GoldenGate, Confluent, and Boomi into the Gigawatt replica.
Build outbound flows — Build the flows that publish Gigawatt data, bills, events, and results back out — for example bill results into the CIS / MACSS, EDI and market transactions, and curated data or regulatory outputs.
Own data mapping and quality, both ways — Maintain source-to-target and target-to-source mappings and a validation approach so data lands complete and correct in either direction and gaps are caught before testing.
Handle scale and performance — Build loads and syncs that perform against large data volumes and high-row-count tables, and tune them when they don’t.
Keep integrations reliable — Wire up triggers and handshakes and put monitoring, alerting, reconciliation, and exception handling in place, so feeds run automatically and failures are caught by alerting rather than by the customer.
Work directly with the customer’s data and integration teams — Agree interfaces, source and target access, field-level detail, and testing, API by API.
Reuse and contribute to the framework — Build on the shared patterns the Integrations Director sets, and feed reusable connectors and improvements back so each new connection is faster than the last.
Support cross-module delivery — Deliver the integration and data work the Customer, Revenue, and Service teams depend on, on the sequence the Director sets.

Requirements

What you’ll need

Hands-on integration and data engineering — Real experience designing and building enterprise integrations and data flows that you build yourself — REST / GraphQL APIs, webhooks and events, batch, change-data-capture, and ETL — in code and configuration, not just specify for others.
Data migration and conversion — A track record of source-to-target mapping, mock and production loads, validation, reconciliation, and cutover support on real implementations.
Tooling fluency — Working command of Boomi (or a comparable iPaaS), Kafka / Confluent, CDC (e.g., GoldenGate), and strong SQL, with comfort handling large data volumes and tuning for performance.
Solutions and data-model sense — Ability to reason clearly about a customer’s data landscape, data models, and master data, and to design a sound integration and load approach within it.
Operational reliability — Experience making production integrations dependable — triggers and handshakes, monitoring and alerting, reconciliation, and exception handling.
Enterprise / utility data — Experience integrating complex enterprise or utility systems (customer / billing, meter / interval usage and MDM, outage, and the like).
Delivery in a customer context — Consulting, systems-integration, or vendor-side experience delivering for demanding enterprise customers, with the communication skills to work directly with a customer’s data and integration teams.
High agency, low ego — Strong ownership — you diagnose the real problem, bring options, and drive to a working solution; collaborative, dependable, and comfortable with ambiguity.

Benefits

Comp & perks

Competitive salary and equity package.
Comprehensive benefits including health insurance, remote-work flexibility, and 401(k) match.
A collaborative culture focused on innovation and impact.