Senior Software Engineer - Workday PRISM ETL (Multiple openings).

U.S. Bank is seeking a full-time Senior Software Engineer specializing in Workday PRISM ETL. This role involves designing, developing, and maintaining ETL processes to support data integration within the Workday PRISM Analytics and Accounting Center platform, ensuring data accuracy and enabling data-driven decision making.

Responsibilities:

• Responsible for designing, developing, and maintaining ETL processes to support data integration within the Workday PRISM Analytics and Accounting Center platform
• Leading cross-functional initiatives to implement PRISM and Accounting Center transformations (unpivot, filter, rank, calculated fields) to enable granular financial reporting and audit-ready data lineage
• Directing integration efforts using Workday Studio, EIBs, and Orchestrate while collaborating with internal teams and external partners to ensure seamless data flow between Workday and third-party platforms
• Developing, optimizing, and maintaining PRISM and Accounting Center transformations, ensuring high volume data transformation accuracy and performance across financial systems
• Providing strategic leadership during critical incidents, including proactively identifying root causes and coordinating resolution efforts across engineering and finance teams
• Designing and optimizing accounting sources, rules, and posting flows for event based accounting, plan readiness, and performance validation for large data releases and cutovers
• Developing and testing inbound integrations (e.g., Workday Studio) to load accounting events, liabilities, and characteristics from external systems
• Engineering large volume export patterns (e.g., governed S3 pipelines) to support reconciliations and parallel run analysis with enterprise data platforms
• Delivering matrix and advanced reports on derived datasets, including crafting calculated fields and summarizations to provide drillable, performant views for Finance stakeholders; and
• Providing production support for the FDM product that represents a number of applications that includes triaging incidents, performing root cause analysis in transformations, and promoting fixes through controlled transports

Requirements:

• Bachelor's degree or equivalent in Information Technology, Computer Science, or Computer Engineering
• 5 years (progressive, post-baccalaureate) experience in a software development occupation
• 24 months of experience with implementing PRISM and Accounting Center transformations, including unpivot, filter, rank, and calculated fields
• 24 months of experience directing integration efforts using Workday Studio, EIBs, and Orchestrate to ensure seamless data flow between Workday and third-party platforms
• 24 months of experience engineering large volume export patterns, including governed S3 pipelines, to support reconciliations and parallel run analysis with enterprise data platforms
• 24 months of experience developing and testing inbound integrations, including Workday Studio, to load accounting events, liabilities, and characteristics from external systems