Integration Lead

Red Clay Consulting; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

RCC Global LLC, doing business as Red Clay Consulting, seeks a senior Integration Lead to own the design, delivery, and support of Oracle Utilities data integration and reporting for US/Canada utility clients. You will guide architecture decisions, review team work, and ensure scalable, future-state solutions across MDM, CC&B, ODM, and OUA.

Ideal candidates bring 8+ years in enterprise data integration, strong ODI/BI/tooling experience, and proven leadership.

Qualifications

• This role requires 8+ years in enterprise data integration and reporting.
• Strong depth in ODI, data integration patterns, and architecture.
• Proven leadership of technical teams and client-facing delivery.

Responsibilities

• Own end-to-end integration and reporting design across Oracle Utilities components.
• Architect and govern data integration solutions and reusable patterns.
• Lead implementation of enterprise reporting using Oracle tools (OUA, OBIEE, OBIU).
• Translate business requirements into coherent solution architectures.
• Guide and review work of developers and analysts; ensure quality.

Skills

Advanced SQL

XML technologies

Solution design

Architecture leadership

Java

PL/SQL

Tools

ODI (Oracle Data Integrator)

Oracle BI Publisher

OBIEE / OBIU

Informatica

Talend

Astera

Job description

Integration Lead

RCC Global LLC

Position Overview

Job Title:Oracle Utilities Integration Lead

Reports To:

Department:Solution Implementation

Location:Remote – United States

FLSA Status:Exempt

Employment Type:Full-Time

Career Level:Senior Consultant/Manager

Travel:Up to 80%

Position Summary

TheIntegration Leadwillown the design, delivery, and support of data integration and reporting solutions for utility clients. Serving the utility industry across theUS andCanada.Red Clay partners with clients to modernize their Oracle Utilities environments and derive actionable insight from their data.

The Integration Leadoperatesat the level and knowledge depth of aseasoned consultant or managing consultant. This role holds design authority over integration and reporting solutions spanning the full Oracle Meter to Cash ecosystem,Meter Data Management (MDM), Customer Care & Billing (CC&B), Oracle Data Management (ODM), and Oracle Utilities Analytics (OUA) andis accountable for the technical integrity, performance, and future-state alignment of those solutions. The Integration Lead sets technical direction, guides and reviews the work of developers and analysts, and serves as the senior integration and reporting authority to both the RCC delivery team and the client. Projects are typically time-sensitive and business-critical; a strong work ethic, sense of urgency, and commitment to quality are essential.

Essential Duties & Responsibilities

• Serve as the senior integration and reporting authority on client engagements, owning end-to-end solution design across Oracle Utilities MDM, CC&B, ODM, and OUA.
• Architect and govern data integration solutionsutilizingOracle Data Integrator (ODI), establishing patterns, standards, and reusable frameworks for the delivery team.
• Design and lead the implementation of enterprise reporting solutionsutilizingOracle tools including OUA, OBIEE, and OBIU, ensuring solutions meet client needs and scale.
• Partner with the Technical Architect and client stakeholders to translate business and technical requirements into a coherent, defensible solution architecture.
• Provide command of Oracle’s entire Meter to Cash solution and how eachcomponentoperateswithin the overallarchitecture, and use that depth to guide cross-component design decisions.
• Lead root cause analysis and resolution of complex data synchronization and integration issues, directing the team toward durable fixes.
• Own alignment to Oracle’s current and future reporting landscape and roadmap for Utilities products,specifically MDM and CC&B,andsteer solutions toward the future state.
• Provide technical leadership, design review, and mentorship to developers and junior team members, raising the capability of the practice.
• Establish and enforce quality, performance, and delivery standards across integration and reporting workstreams.

Required Qualifications

This role requires Solution Architect-level depth, typicallydemonstratedthrough 8+ years of progressive experience in enterprise data integration and reporting, including:

Technical Skills

• Advanced SQL and XML technologies, with the ability to design andoptimizeat scale.
• Demonstratedsolution-designand architecture experience across complex, multi-componentenvironments.

Product Knowledge

• Oracle Data Integrator 11g/12c, at a design and governance level.
• Oracle BI Publisher.
• ETL data processing and integration patterns.

Reporting & Business Intelligence

• Enterprise reporting and business intelligence solutions (OBIEE, Cognos, or comparable), including architecture and delivery.
• Depth across Oracle, Cognos, or Microsoft analytics products, SQL, and Business Intelligence.

Leadership

• Demonstrated ability to lead technical teams, own solution design, and serve as the senior technical point of contact for clients.

Preferred Qualifications

• Java and PL/SQL.
• Deep experience with enterprise data integration products and processes.
• Experience with enterprise data integration tools (Informatica, Talend, Astera).
• Hands-on architecture experience with Oracle Utilities products, particularly Meter Data Management (MDM) and Customer Care & Billing (CC&B).

Success Competencies

The following competencies define success in the Oracle Utilities Integration Lead role at Solution Architect level:

• Solution Architecture & Design Authority —Owns integration and reporting solution design across the Meter to Cash ecosystem, making sound architectural decisions that balance client needs, performance, and Oracle’s future-state roadmap.
• Technical Depth & Mastery —Commands SQL, XML, ODI, and the Oracle BI/analytics stack at a level that sets standards and resolves the hardest problems on the engagement.
• Technical Leadership & Mentorship —Directs, reviews, and elevates the work of developers and analysts, and grows the technical capability of the practice.
• Complex Problem Solving —Leads root cause analysis on integration and data synchronization issues, driving durable solutions rather than symptomatic fixes.
• Client Trust & Advisory Presence —Serves as the senior integration and reporting authority to clients, earning trust through credibility, clarity, and delivery.
• Communication —Translates highly technical architecture and trade-offs into clear business terms for executive, technical, and non-technical audiences.
• Ownership & Sense of Urgency —Takes end-to-end accountability for solution quality and delivery on time-sensitive, business-critical projects.
• Adaptability & Multitasking —Manages design authority across multiple concurrent workstreams and shifting demands without sacrificing quality.
• Forward-Looking Orientation —Anticipates Oracle’s evolving Utilities reporting landscape and positions solutions to fit the future state.

Work Environment & Physical Requirements

This is a remote-based position requiring up to 80%travelto client sites. The Integration Lead is expected tomaintaina reliable home office environment, high-speed internet connectivity, and availability during core business hours across client time zones.

The physical demands described here are representative of those that must be met to successfully perform the essential functions of this role. Reasonable accommodations may be made to enable individuals with disabilities to perform these functions.

• Prolonged periods of sitting at a desk and working on a computer.
• Frequent use of a keyboard, mouse, andmonitorfor extended periods.
• Ability to travel by air and ground to client locations, up to 80% of the time.
• Occasional lifting of up to15pounds (e.g., laptop bag, work materials, and equipment).
• Ability to communicate clearly by phone, video conference, and in person.
• Flexibility to work extended or non-standard hours during critical project phases.

Equal Employment Opportunity Statement

RCC Global LLC (Red Clay Consulting) is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, veteran status, or any other characteristic protected by applicable federal, state, or local law. Red Clay Consulting is committed to providing a work environment free of discrimination and harassment, and employment decisions are based on business needs, job requirements, and individual qualifications.

Americans with Disabilities Act (ADA) Statement

RCC Global LLC (Red Clay Consulting)complies withthe Americans with Disabilities Act (ADA) and applicable state and local laws providing for nondiscrimination in employment against qualified individuals with disabilities. Red Clay Consulting provides reasonable accommodations to qualified individuals with disabilities to enable them to perform the essential functions of the position, unless doing sowould createan undue hardship. Applicants or employees who requirean accommodationshould contact Human Resources to request one.