Job Title: Software Design EngineerJob 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. 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 22, 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.