Davita Inc.
Oracle Utilities Consultant (WAMS/CCB) - Remote Technology Systems
Davita Inc., Kent, Washington, us, 98089
Oracle Utilities Consultant needed for a contract opportunity with SOC's client to work remotely with occasional travel to Washington.
Contract Length:
6 months
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 Qualifications:
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
Desired 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
Employment Prerequisites
The following requirements must be met to be eligible for this position: successful completion of a background investigation and drug urinalysis.
SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability.
Note: Any pay ranges displayed are estimations, which may have been provided by job boards. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.
#INDSOC
Estimated Min Rate : $42.22
Estimated Max Rate : $60.32 #J-18808-Ljbffr
Contract Length:
6 months
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 Qualifications:
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
Desired 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
Employment Prerequisites
The following requirements must be met to be eligible for this position: successful completion of a background investigation and drug urinalysis.
SOC, a Day & Zimmermann company, is an Equal Opportunity Employer, EOE AA M/F/Vet/Disability.
Note: Any pay ranges displayed are estimations, which may have been provided by job boards. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.
#INDSOC
Estimated Min Rate : $42.22
Estimated Max Rate : $60.32 #J-18808-Ljbffr