Red Clay Consulting Logo

Red Clay Consulting

Integration Lead

Posted 2 Months Ago
Be an Early Applicant
Remote
Hiring Remotely in United States
Senior level
Remote
Hiring Remotely in United States
Senior level
Owns the architecture, delivery, and support of Oracle Utilities integration and enterprise reporting solutions. Leads designs across MDM, CC&B, ODM, and OUA; governs Oracle Data Integrator standards; and implements reporting with Oracle analytics tools. Translates requirements into solution architectures, resolves complex synchronization issues, guides technical teams, mentors developers, and ensures performance and quality. Serves as the senior technical authority for clients while aligning solutions with Oracle’s future-state Utilities roadmap. The remote role requires up to 80% travel.
The summary above was generated by AI

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. 


Similar Jobs

19 Days Ago
Remote
Texas, USA
124K-285K Annually
Expert/Leader
124K-285K Annually
Expert/Leader
Artificial Intelligence • Cloud • Information Technology • Consulting
Leads channel services integration strategy and execution, including partner journey design, requirements gathering, architecture alignment, user stories, design sessions, testing, change management, and stakeholder communications. Develops business plans, performance metrics, data-driven analyses, and resource strategies. Engages distributors and resellers through presentations and webinars while coordinating cross-functional teams, IT, services organizations, and Accenture.
Top Skills: Financial ModelingInformation Technology ArchitectureMicrosoft AccessExcelNetworking ServicesStatistical Analysis
3 Days Ago
In-Office or Remote
49 Locations
148K-205K Annually
Expert/Leader
148K-205K Annually
Expert/Leader
Healthtech • Information Technology
Leads PBM data integration delivery across claims, eligibility, accumulator, and encounter systems. Profiles and validates data, writes advanced SQL, resolves reconciliation discrepancies, investigates production issues, and partners with engineering on scalable healthcare integration architecture. Owns timelines, risks, vendor dependencies, testing, UAT, migration, rollback planning, executive reporting, and post-deployment support. Requires deep PBM claims-processing expertise, data architecture experience, and hands-on knowledge of ETL, secure file transfer, job scheduling, and healthcare data standards.
Top Skills: Ansi/Ncpdp Telecommunication StandardC#ETLJavaJavaScriptAzurePgpPythonRSftpSQL
3 Days Ago
In-Office or Remote
Expert/Leader
Expert/Leader
Pet
Leads the SAP ECC FI/CO workstream for an acquisition integration, including functional design, parallel accounting for IFRS and US GAAP, master data migration, testing, reconciliation, cutover, and hypercare. The role coordinates with technology and finance stakeholders, ensures SOX-compliant change management, resolves complex functional issues, and maintains financial data integrity throughout implementation.
Top Skills: Sap EccSap Fi/Co

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account