Logo for Red Clay Consulting

Integration Lead

Role overview

Qualifications

  • 8+ years of progressive experience in enterprise data integration and reporting
  • Advanced SQL and XML technologies expertise
  • Demonstrated solution-design and architecture experience in complex environments
  • Leadership experience in technical teams

Responsibilities

  • Own end-to-end solution design across Oracle Utilities MDM, CCB, ODM, and OUA
  • Architect and govern data integration solutions utilizing Oracle Data Integrator (ODI)
  • Design and lead implementation of enterprise reporting solutions with Oracle tools
  • Provide technical leadership, design review, and mentorship to team members

About the company

Red Clay Consulting logo

Red Clay Consulting

IT Services & IT Consulting

Red Clay Consulting leads utilities in digital transformation. Over the last twenty years, Red Clay has helped more than 300 utilities throughout the world evolve by improving operations and customer experiences. Our consultants provide expert guidance from a project’s conception to its post-production support. We focus on the industry’s leading software Oracle Utilities and are a Gold Level Member of the Oracle Partner Network. Red Clay takes great pride in our stellar reputation throughout the industry – a reputation built on training, experience, teamwork, and commitment to the client. Red Clay is dynamic company of engaged individuals eager to grow and contribute. Our employee-centric and award-winning culture focuses on collaboration and community and provides ongoing opportunity for development and career growth. Our core values – Achieve excellence together. Embrace and drive change. Exceed expectations. Invest in relationships. And, enjoy the journey – inform every aspect of how we operate. Visit www.redclay.com to learn more about our mission of doing what’s right and fair for our clients, our employees, and our company.

Company details

IndustryIT Services & IT Consulting
Company size51 - 200

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

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 

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. 

 

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Related jobs

Other jobs at Red Clay Consulting

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.