Job Title: Software Design Engineer
Job Description
We are seeking a seasoned professional to support substantial information technology projects within the Utility Technologies Solutions team. The ideal candidate will possess extensive hands-on experience with Oracle Utilities WAM v1.9x and other platforms. This position involves leading data integration between Oracle Utilities Work and Asset Management (WAM) and Oracle Utilities Customer Care and Billing systems for rewire billing processes. You will play a pivotal role in understanding the business and technical flow of rewire events, defining billing rules, and overseeing the complete data lifecycle from extraction in WAMS to billing in the target system.
Responsibilities
Define the technical integration between Oracle Utilities WAM and the target system 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 the target system.
Support business process mapping to ensure technical design aligns with operational workflows.
Map WAMS data elements such as work orders, service locations, costs, and materials to corresponding billing structures.
Define transformation logic to convert WAMS data into formats ingestible by the target system, including CSV, XML, and JSON.
Architect secure, scalable, and auditable data exchange mechanisms using protocols such as SFTP.
Develop 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.
Adhere to architectural standards.
Troubleshoot integration issues and guide resolution strategies across systems.
Architect the logic and process to interpret batch responses from the target system, confirming billing success or exceptions.
Design mechanisms to update WAMS based on billing outcomes such as payment confirmation and 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.
Essential Skills
Software architecture design expertise.
Experience with AWS and Azure platforms.
Proficiency in Oracle Utilities WAM, particularly version 1.9x, including data model knowledge.
Expertise in Oracle Customer Care and Billing, including batch operations and data interfaces.
Strong understanding of relational database structures, ETL processes, and interface design.
Proficiency 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 leading solution design discussions, presenting architectural decisions, and writing clear documentation.
Additional Skills & 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.
Work Environment
This position is based on-site at the client facility located in Seattle, WA.
We reserve the right to pay above or below the posted wage based on factors unrelated to sex, race, or any other protected classification.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. This temporary role may be eligible for the following:
· Medical, dental & vision
· 401(k)/Roth
· Insurance (Basic/Supplemental Life & AD&D)
· Short and long-term disability
· Health & Dependent Care Spending Accounts (HSA & DCFSA)
· Transportation benefits
· Employee Assistance Program
.Time Off/Leave (PTO, Vacation or Sick Leave)
Pay and Benefits
The pay range for this position is $48.00 - $54.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
Medical, dental & vision - Critical Illness, Accident, and Hospital - 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available - Life Insurance (Voluntary Life & AD&D for the employee and dependents) - Short and long-term disability - Health Spending Account (HSA) - Transportation benefits - Employee Assistance Program - Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a hybrid position in Seattle,WA.
Application Deadline
This position is anticipated to close on Aug 25, 2025.
About Actalent
Actalent is a global leader in engineering and sciences services and talent solutions. We help visionary companies advance their engineering and science initiatives through access to specialized experts who drive scale, innovation and speed to market. With a network of almost 30,000 consultants and more than 4,500 clients across the U.S., Canada, Asia and Europe, Actalent serves many of the Fortune 500.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing due to a disability, please email actalentaccommodation@actalentservices.com (%20actalentaccommodation@actalentservices.com) for other accommodation options.
