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
The Integration Lead will own the design, delivery, and support of data integration and reporting solutions for utility clients. Serving the utility industry across the US and Canada. Red Clay partners with clients to modernize their Oracle Utilities environments and derive actionable insight from their data.
The Integration Lead operates at the level and knowledge depth of a seasoned 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) and is 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 solutions utilizing Oracle Data Integrator (ODI), establishing patterns, standards, and reusable frameworks for the delivery team.
Design and lead the implementation of enterprise reporting solutions utilizing Oracle 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 each component operates within the overall architecture, 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, and steer 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, typically demonstrated through 8+ years of progressive experience in enterprise data integration and reporting, including:
Technical Skills
Advanced SQL and XML technologies, with the ability to design and optimize at scale.
Demonstrated solution-design and architecture experience across complex, multi-component environments.
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% travel to client sites. The Integration Lead is expected to maintain a 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, and monitor for extended periods.
Ability to travel by air and ground to client locations, up to 80% of the time.
Occasional lifting of up to 15 pounds (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 with the 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 so would create an undue hardship. Applicants or employees who require an accommodation should contact Human Resources to request one.
Requires 8+ years in enterprise data integration and reporting, advanced SQL/XML, solution architecture, Oracle Data Integrator, BI reporting, technical leadership, and Oracle Utilities experience; Java, PL/SQL, and Informatica, Talend, or Astera preferred.
Key Responsibilities
- designing integrations
- architecting solutions
- mentoring developers
Skills & Tools
Oracle Utilities, Oracle Data Integrator, Oracle BI Publisher, OBIEE, OBIU, Cognos, Microsoft analytics, SQL, XML, Java, PL/SQL, Informatica, Talend, Astera
Job Details
- Category: Information Technology
- Seniority: Senior Level
- Commitment: Full Time
- Workplace: Remote — United States or Canada
- Languages: English
About Red Clay Consulting
A consulting firm that modernizes Oracle Utilities environments and delivers data integration and reporting solutions. — Industry: Consulting Services