Oracle Utilities/ Work and Asset Management (WAM) Consultant

Job Title: (Oracle utilities) WAMS/CCB Technical/Functional Resource

Location: Remote

Duration: 6+ Months contract with Extensions

Responsibilities:

• Define the technical integration between Oracle Utilities WAM and CC&B specific to rewire billing processes
• Develop and document reusable patterns for data extraction, transformation, and integration
• Ensure data design supports business rules, regulatory compliance, and performance standards
• Collaborate with business stakeholders to define, clarify, and validate billing rules for rewire scenarios
• Document how rewire work orders and financial activities are represented in WAMS and how they map to billing entities in CC&B
• Support business process mapping to ensure technical design aligns with operational workflows
• Map WAMS data elements (work orders, service locations, costs, materials) to corresponding CC&B billing structures (accounts, service points, premises)
• Define transformation logic to convert WAMS data into formats ingestible by CC&B (e.g., CSV, XML, JSON)
• Architect secure, scalable, and auditable data exchange mechanisms using SFTP or similar protocols
• Development of extraction routines and transformation scripts
• Design and develop robust and scalable integrations that use OSB to expose and consume web services from the Oracle database.
• Adherence to architectural standards
• Troubleshoot integration issues and guide resolution strategies across systems
• Architect the logic and process to interpret batch responses from CC&B, confirming billing success or exceptions
• Design mechanisms to update WAMS based on billing outcomes (e.g., payment confirmation, status updates)
• Support system integration testing, data validation, and end-to-end scenario simulations
• Participate in UAT by preparing test data, supporting issue triage, and validating output accuracy
• Ensure technical solutions are thoroughly documented and ready for production deployment

Required Education & Experience:

• Bachelor s degree in business, Information Technology, Computer Science or related degree with 5+ years of hands-on experience with Oracle Utilities WAM v1.9x, preferably in a technical capacity. Additional years of experience may be considered in lieu of a degree.
• Oracle Utilities WAM, particularly version 1.9x, including data model knowledge
• Oracle CC&B, including batch operations and data interfaces
• Strong understanding of relational database structures, ETL processes, and interface design
• Proficient in working with CSV, XML, JSON, and secure file transfer protocols like SFTP
• Ability to architect solutions that are scalable, secure, and maintainable
• Strong collaboration and communication skills for working across technical and non-technical teams
• Comfortable with leading solution design discussions, presenting architectural decisions, and writing clear documentation

Preferred Qualifications

• Experience with utility billing for rewires or other complex field service scenarios
• Familiarity with enterprise integration platforms or middleware tools
• Prior experience working in regulated environments or with municipal utilities