Etl Testing Jobs in Iowa (NOW HIRING)

Job Family

IT - Development

Job Description Summary

Job Description Summary:
The Investment Reporting Technology team partners closely with Finance, Accounting, Investment Operations, and other Technology teams to deliver enterprise applications that support investment accounting, regulatory reporting, management reporting, data governance, and financial controls. Our solutions integrate investment data from multiple platforms and provide automated, scalable, and compliant applications and reporting capabilities for critical business functions.
The Senior Software Engineer will serve as a hands-on Murex Developer and integration specialist responsible for designing, developing, enhancing, and supporting solutions across the Murex ecosystem and related internal and third-party peripheral applications. The ideal candidate has strong Murex development experience, understands derivatives trade lifecycle processes, and can integrate Murex with downstream and upstream applications built using multiple technology stacks, including SQL Server, Oracle, SSIS, SSRS, Java, Python, APIs, batch scheduling, test automation, and cloud or modern data platforms. Provides support for design and development to one or more application development teams.
This role requires a blend of Murex platform expertise, data engineering, integration design, reporting knowledge, production support discipline. Responsibilities include Murex workflow and interface development, Datamart/reporting support, data pipelines, process automation, regulatory and accounting reporting support, production troubleshooting, and modernization of investment reporting and derivatives systems.

Job Description

Responsibilities

• Design, develop, enhance, and support Murex-based solutions across Front Office, Risk, Back Office, Accounting, and Datamart/reporting functions.
• Develop and maintain integrations between Murex and internal peripheral applications, including downstream reporting platforms, accounting systems, data warehouses, operational tools, and other company-developed applications built across varied technology stacks.
• Translate business and functional requirements into scalable technical solutions using Murex components, MxML, APIs, SQL, ETL pipelines, reporting frameworks, and integration services.
• Build and support Murex Datamart reporting solutions, including schemas, feeders, batches, extraction processes, reconciliation routines, and reporting data layers.
• Develop and optimize data pipelines and ETL processes using SQL Server, SSIS, AWS Glue, Oracle, or equivalent technologies to move and transform trade, position, valuation, and accounting data.
• Design, develop, and support operational, regulatory, valuation, accounting, and management reports using SSRS, SQL, BI tools, Excel VBA/macros, and other enterprise reporting platforms.
• Support trade lifecycle data flows, including deal capture, static data, valuation, accounting, reconciliation, reporting, EOD/EOM processing, and downstream data distribution.
• Perform root-cause analysis and resolve complex production issues involving Murex workflows, Datamart loads, market data interfaces, reporting discrepancies, batch failures, and integration breaks.
• Collaborate with Finance, Accounting, Investment Operations, Risk, business product owners, infrastructure teams, vendors, and offshore/contract development teams in an agile or hybrid delivery model.
• Lead design sessions and architecture discussions for end-to-end Murex and derivatives platform solutions, considering business needs, cost, operational risk, maintainability, scalability, and system impacts.
• Support SIT, UAT, regression testing, production releases, Murex upgrades, platform migrations, and modernization initiatives.
• Contribute to automation and process optimization initiatives to improve STP, reduce manual work, strengthen controls, and improve operational efficiency.
• Mentor developers and analysts on Murex development practices, integration design, coding standards, troubleshooting, documentation, and release readiness.
• Leverage modern AI-assisted development tools, including Kiro, to accelerate delivery, improve code quality, automate repetitive development tasks, and enhance engineering productivity across the software development lifecycle.

Qualifications

• Bachelor's degree in computer science, information systems, math, engineering, finance, or another technical field, or equivalent education and experience.
• Three or more years of software engineering experience using Java, SQL, or equivalent enterprise development technologies.
• Hands-on Murex development or functional development experience, preferably supporting derivatives, Front Office, Risk, Back Office, Accounting, Datamart, or reporting capabilities.
• Experience integrating Murex or similar financial platforms with internal and external applications through APIs, messaging, ETL pipelines, files, database interfaces, services, or batch orchestration.
• Strong experience with SQL Server and/or Oracle, including query development, stored procedures, data modeling, performance tuning, troubleshooting, and data reconciliation.
• Experience with ETL and data integration tools such as SSIS, AWS Glue, Control-M scheduled jobs, or equivalent enterprise integration technologies.
• Experience developing and supporting reporting solutions using SSRS, BI tools, Datamart extracts, Excel VBA/macros, or equivalent reporting platforms.
• Familiarity with coding platforms and frameworks such as OOD/OOP, Spring Framework, J2EE, service-oriented architecture, dependency injection, and core architecture principles.
• Experience with integration and service frameworks such as API gateways, Swagger/OpenAPI, Kafka, messaging tools, microservices, REST APIs, or equivalent technologies.
• Experience with build, deployment, and CI/CD tools such as Visual Studio, Git/Bitbucket, Maven, Jenkins, Nexus, SQL Management Studio, NUnit, Docker, OpenShift, Kubernetes, or similar tools.
• Working knowledge of Windows Server, Linux/Unix environments, scripting, batch scheduling, monitoring, and operational support processes.
• Understanding of derivatives products and trade lifecycle concepts, including FX, swaps, rates, fixed income, options, valuation, accounting, P&L, and regulatory or management reporting.
• Strong troubleshooting, analytical, documentation, and technical communication skills, with the ability to work independently and as part of a cross-functional team.
• Ability to prioritize workload, manage competing priorities, and deliver high-quality solutions within tight deadlines while maintaining strong customer focus.

Preferred Qualifications

• Experience with Murex upgrade, migration, or large-scale enhancement programs.
• Experience with test automation tools, including test case design, automation development, regression testing, and integration with enterprise testing and release management processes.
• Technology or platform certifications, such as AWS, Microsoft, Murex-related training, or equivalent technical certifications.
• Knowledge of financial services, insurance, asset management, capital markets, or derivatives reporting domain.

Working Conditions

• Hybrid-Office Environment (Tuesdays, Wednesdays, Thursdays)
• Work outside of normal business hours may be required
• Moderate Travel 5%

Compensation:

The Salary for this position generally ranges between $94,000-$115,000 annually. Please note that the salary range is a good faith estimate for this position and actual starting pay is determined by several factors including qualifications, experience, geography, work location designation (in-office, hybrid, remote) and operational needs. Salary may vary above and below the stated amounts, as permitted by applicable law.

Additionally, this position is typically eligible for an Annual Bonus based on the Company Bonus Plan/Individual Performance and is at the Company's discretion.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

This is a hybrid position requiring three days in office per week in our Denver or Cedar Rapids hub location. Relocation assistance will not be provided for this position.

Enterprise Technology is a global Aegon/Transamerica organization that enables the business to move quickly and deliver the best possible outcomes for clients, while keeping their information safe and secure.

With more than 1,000 employees across the UK, US, Netherlands, Hungary, Spain, and Hong Kong, Enterprise Technology is a diverse, global team. Our experts work across areas such as application development, information security, infrastructure, data & analytics, risk & controls, program management, and architecture. We offer a wide range of career opportunities and are committed to supporting employee development.

Curiosity is the quality we value most. Much of our work involves solving complex problems, applying knowledge in new ways, and continuously improving how we operate. As technology evolves rapidly, we look for inquisitive people who are confident challenging the status quo and helping us drive change.

This job description is not a contract of employment nor for any specific job responsibilities. The Company may change, add to, remove, or revoke the terms of this job description at its discretion. Managers may assign other duties and responsibilities as needed. In the event an employee or applicant requests or requires an accommodation to perform job functions, the applicable HR Business Partner should be contacted to evaluate the accommodation request.

What We Offer

For eligible employees, we offer a comprehensive benefits package designed to support both the personal and financial well-being of our employees.

Compensation Benefits

• Competitive Pay

• Bonus for Eligible Employees

Benefits Package

• Pension Plan

• 401k Match

• Employee Stock Purchase Plan

• Tuition Reimbursement

• Disability Insurance

• Medical Insurance

• Dental Insurance

• Vision Insurance

• Employee Discounts

• Career Training & Development Opportunities

Health and Work/Life Balance Benefits

• Paid Time Off starting at 160 hours annually for employees in their first year of service.

• Ten (10) paid holidays per year (typically mirroring the New York Stock Exchange (NYSE) holidays).

• Be Well Company holistic wellness program, which includes Wellness Coaching and Reward Dollars

• Parental Leave - fifteen (15) days of paid parental leave per calendar year to eligible employees with at least one year of service at the time of birth, placement of an adopted child, or placement of a foster care child.

• Adoption Assistance

• Employee Assistance Program

• Back-Up Care Program

• PTO for Volunteer Hours

• Employee Matching Gifts Program

• Employee Resource Groups

• Inclusion and Diversity Programs

• Employee Recognition Program

• Referral Bonus Programs

Inclusion & Diversity

We believe our commitment to diversity and inclusion creates a work environment filled with exceptional individuals. We're thrilled to have been recognized for our efforts through the Human Rights Campaign Corporate Equality Index, Dave Thomas Adoption Friendly Advocate, and several Seramount lists, including the Inclu...